DAL/BuginfoDAL.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Configuration;
using Common;
using System.Data.SqlClient;

namespace DAL
{
    public class BuginfoDAL : DALBase
    {
        public BuginfoDAL()
        {
            this.ConnStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        }
        public int AddUpdate(int Id,int Softtypeid,string Title,string bugInfo,string updateinfo,string causeinfo,int bugresultid,int Opid,DateTime Opdate,int Upopid,DateTime Upopdate)
        {
            this.ParameterList = new SqlParameterList();
            this.ParameterList.Add("Id", Id);
            this.ParameterList.Add("Softtypeid", Softtypeid);
            this.ParameterList.Add("Title", Title);
            this.ParameterList.Add("bugInfo", bugInfo);
            this.ParameterList.Add("updateinfo", updateinfo);
            this.ParameterList.Add("causeinfo", causeinfo);
            this.ParameterList.Add("bugresultid", bugresultid);
            this.ParameterList.Add("Opid", Opid);
            this.ParameterList.Add("Opdate", Opdate);
            this.ParameterList.Add("Upopid", Upopid);
            this.ParameterList.Add("Upopdate", Upopdate);

            string sqlstr = string.Empty;
            if (Id == 0)
            {
                sqlstr = "Insert into buginfo(Softtypeid,Title,bugInfo,bugresultid,Opid,Upopid,Opdate) values(@Softtypeid,@Title,@bugInfo,@bugresultid,@Opid,@Upopid,@Opdate)";
            }
            else
            {
                sqlstr = "Update buginfo set Softtypeid=@Softtypeid,Title=@Title,bugInfo=@bugInfo,Opid=@Opid,Upopid=@Upopid,Opdate=@Opdate where Id=@Id";
            }
            return this.ExecuteNonQueryFromSQL(sqlstr);
        }

        public int AddUpdate(int Id, int Upopid, DateTime Upopdate, string updateinfo, string causeinfo)
        {
            this.ParameterList = new SqlParameterList();
            this.ParameterList.Add("Id", Id);
            this.ParameterList.Add("Upopid", Upopid);
            this.ParameterList.Add("Upopdate", Upopdate);
            this.ParameterList.Add("updateinfo", updateinfo);
            this.ParameterList.Add("causeinfo", causeinfo);

            string sqlstr = string.Empty;
            sqlstr = "Update buginfo set Upopid=@Upopid,Upopdate=@Upopdate,updateinfo=@updateinfo,causeinfo=@causeinfo where Id=@Id";
            return this.ExecuteNonQueryFromSQL(sqlstr);
        }

        public int HuiFu(int Id, string Name)
        {
            this.ParameterList = new SqlParameterList();