SenBiTeSolution.DAL/tbl_AnLi.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using SenBiTeSolution.Model;
using SenBiTeSolution.DBUtility;
using System.Data.OleDb;
using System.Data;

namespace SenBiTeSolution.DAL
{
    public class tbl_AnLi
    {
        //添加案例
        public int AddAnLi(Model.tbl_AnLi anLi)
        {
            string sqlString = "insert into tbl_AnLi(DuiXiang,FanWei,FWData,imgPath,Details,CreateDate) values(@DuiXiang,@FanWei,@FWData,@imgPath,@Details,@CreateDate)";

            OleDbParameter[] parameters = new OleDbParameter[6];

            parameters[0] = new OleDbParameter("@DuiXiang", OleDbType.VarChar, 30);
            parameters[0].Value = anLi.DuiXiang;

            parameters[1] = new OleDbParameter("@FanWei", OleDbType.VarChar, 30);
            parameters[1].Value = anLi.FanWei;

            parameters[2] = new OleDbParameter("@FWData", OleDbType.VarChar, 20);
            parameters[2].Value = anLi.FWData;

            parameters[3] = new OleDbParameter("@imgPath", OleDbType.VarChar, 200);
            parameters[3].Value = anLi.imgPath;

            parameters[4] = new OleDbParameter("@Details", OleDbType.VarChar, 3000);
            parameters[4].Value = anLi.Details;

            parameters[5] = new OleDbParameter("@CreateDate", OleDbType.VarChar, 20);
            parameters[5].Value = anLi.CreateDate;

            return DbHelperOleDb.ExecuteSql(sqlString, 1, parameters);
        }

        //修改案例
        public int UpdateAnLi(Model.tbl_AnLi anLi)
        {
            string sqlString = "update tbl_AnLi set DuiXiang=@DuiXiang,FanWei=@FanWei,FWData=@FWData,imgPath=@imgPath,Details=@Details,CreateDate=@CreateDate where ID=@ID";

            OleDbParameter[] parameters = new OleDbParameter[7];

            parameters[0] = new OleDbParameter("@DuiXiang", OleDbType.VarChar, 30);
            parameters[0].Value = anLi.DuiXiang;

            parameters[1] = new OleDbParameter("@FanWei", OleDbType.VarChar, 30);
            parameters[1].Value = anLi.FanWei;

            parameters[2] = new OleDbParameter("@FWData", OleDbType.VarChar, 20);
            parameters[2].Value = anLi.FWData;

            parameters[3] = new OleDbParameter("@imgPath", OleDbType.VarChar, 200);
            parameters[3].Value = anLi.imgPath;