public static int UpdateTbl_DesignCorrect(Tbl_DesignCorrect tbl_designcorrect)
{
WebCommon.Public.WriteLog("修改设计文件：" + tbl_designcorrect.DesignTaskID.ToString());
tbl_designcorrect.DealUser = WebCommon.Public.GetUserName();
tbl_designcorrect.DealTime = DateTime.Now;
return(new Tbl_DesignCorrectService().UpdateTbl_DesignCorrectById(tbl_designcorrect));
}
public int AddTbl_DesignCorrect(Tbl_DesignCorrect tbl_designcorrect)
{
string sql = "insert into [Tbl_DesignCorrect] ([UserName],[DesignTaskID],[DC_Name],[DC_File],[DC_FileInfo],[DC_FileTime],[Status]) values (@UserName,@DesignTaskID,@DC_Name,@DC_File,@DC_FileInfo,@DC_FileTime,@Status)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@UserName", tbl_designcorrect.UserName),
new SqlParameter("@DesignTaskID", tbl_designcorrect.DesignTaskID),
new SqlParameter("@DC_Name", tbl_designcorrect.DC_Name),
new SqlParameter("@DC_File", tbl_designcorrect.DC_File),
new SqlParameter("@DC_FileInfo", tbl_designcorrect.DC_FileInfo),
new SqlParameter("@DC_FileTime", tbl_designcorrect.DC_FileTime),
new SqlParameter("@Status", tbl_designcorrect.Status)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
/// <summary>
///根据SQL语句获取集合
/// </summary>
private IList <Tbl_DesignCorrect> getTbl_DesignCorrectsBySql(string sql)
{
IList <Tbl_DesignCorrect> list = new List <Tbl_DesignCorrect>();
DataSet ds = DBHelper.ExecuteDataset(this.connection, CommandType.Text, sql);
if (ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
Tbl_DesignCorrect tbl_designcorrect = new Tbl_DesignCorrect();
tbl_designcorrect.ID = Convert.ToInt32(dr["ID"]);
tbl_designcorrect.UserName = Convert.ToString(dr["UserName"]);
tbl_designcorrect.DesignTaskID = Convert.ToInt32(dr["DesignTaskID"]);
tbl_designcorrect.DC_Name = Convert.ToString(dr["DC_Name"]);
tbl_designcorrect.DC_File = Convert.ToString(dr["DC_File"]);
tbl_designcorrect.DC_FileInfo = Convert.ToString(dr["DC_FileInfo"]);
tbl_designcorrect.DC_FileTime = Convert.ToDateTime(dr["DC_FileTime"]);
tbl_designcorrect.DC_File1 = Convert.ToString(dr["DC_File1"]);
tbl_designcorrect.DC_File1Correct = Convert.ToString(dr["DC_File1Correct"]);
tbl_designcorrect.DC_File1CorrectInfo = Convert.ToString(dr["DC_File1CorrectInfo"]);
tbl_designcorrect.DC_File1Time = Convert.ToDateTime(dr["DC_File1Time"]);
tbl_designcorrect.DC_File2 = Convert.ToString(dr["DC_File2"]);
tbl_designcorrect.DC_File2Correct = Convert.ToString(dr["DC_File2Correct"]);
tbl_designcorrect.DC_File2CorrectInfo = Convert.ToString(dr["DC_File2CorrectInfo"]);
tbl_designcorrect.DC_File2Time = Convert.ToDateTime(dr["DC_File2Time"]);
tbl_designcorrect.DC_File3 = Convert.ToString(dr["DC_File3"]);
tbl_designcorrect.DC_File3Correct = Convert.ToString(dr["DC_File3Correct"]);
tbl_designcorrect.DC_File3CorrectInfo = Convert.ToString(dr["DC_File3CorrectInfo"]);
tbl_designcorrect.DC_File3Time = Convert.ToDateTime(dr["DC_File3Time"]);
tbl_designcorrect.DC_File4 = Convert.ToString(dr["DC_File4"]);
tbl_designcorrect.DC_File4Correct = Convert.ToString(dr["DC_File4Correct"]);
tbl_designcorrect.DC_File4CorrectInfo = Convert.ToString(dr["DC_File4CorrectInfo"]);
tbl_designcorrect.DC_File4Time = Convert.ToDateTime(dr["DC_File4Time"]);
tbl_designcorrect.ErrorNum1 = Convert.ToInt32(dr["ErrorNum1"]);
tbl_designcorrect.ErrorNum2 = Convert.ToInt32(dr["ErrorNum2"]);
tbl_designcorrect.ErrorNum3 = Convert.ToInt32(dr["ErrorNum3"]);
tbl_designcorrect.NodeUser = Convert.ToString(dr["NodeUser"]);
tbl_designcorrect.Status = Convert.ToString(dr["Status"]);
tbl_designcorrect.DealFlag = Convert.ToInt32(dr["DealFlag"]);
tbl_designcorrect.DealUser = Convert.ToString(dr["DealUser"]);
tbl_designcorrect.DealTime = Convert.ToDateTime(dr["DealTime"]);
list.Add(tbl_designcorrect);
}
}
return(list);
}
public int UpdateTbl_DesignCorrectById(Tbl_DesignCorrect tbl_designcorrect)
{
string sql = "update [Tbl_DesignCorrect] set [UserName]=@UserName,[DesignTaskID]=@DesignTaskID,[DC_Name]=@DC_Name,[DC_File]=@DC_File,[DC_FileInfo]=@DC_FileInfo,[DC_FileTime]=@DC_FileTime,[DC_File1]=@DC_File1,[DC_File1Correct]=@DC_File1Correct,[DC_File1CorrectInfo]=@DC_File1CorrectInfo,[DC_File1Time]=@DC_File1Time,[DC_File2]=@DC_File2,[DC_File2Correct]=@DC_File2Correct,[DC_File2CorrectInfo]=@DC_File2CorrectInfo,[DC_File2Time]=@DC_File2Time,[DC_File3]=@DC_File3,[DC_File3Correct]=@DC_File3Correct,[DC_File3CorrectInfo]=@DC_File3CorrectInfo,[DC_File3Time]=@DC_File3Time,[DC_File4]=@DC_File4,[DC_File4Correct]=@DC_File4Correct,[DC_File4CorrectInfo]=@DC_File4CorrectInfo,[DC_File4Time]=@DC_File4Time,[ErrorNum1]=@ErrorNum1,[ErrorNum2]=@ErrorNum2,[ErrorNum3]=@ErrorNum3,[Status]=@Status,[NodeUser]=@NodeUser,[DealFlag]=@DealFlag,[DealUser]=@DealUser,[DealTime]=@DealTime where [ID]=@ID";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ID", tbl_designcorrect.ID),
new SqlParameter("@UserName", tbl_designcorrect.UserName),
new SqlParameter("@DesignTaskID", tbl_designcorrect.DesignTaskID),
new SqlParameter("@DC_Name", tbl_designcorrect.DC_Name),
new SqlParameter("@DC_File", tbl_designcorrect.DC_File),
new SqlParameter("@DC_FileInfo", tbl_designcorrect.DC_FileInfo),
new SqlParameter("@DC_FileTime", tbl_designcorrect.DC_FileTime),
new SqlParameter("@DC_File1", tbl_designcorrect.DC_File1),
new SqlParameter("@DC_File1Correct", tbl_designcorrect.DC_File1Correct),
new SqlParameter("@DC_File1CorrectInfo", tbl_designcorrect.DC_File1CorrectInfo),
new SqlParameter("@DC_File1Time", tbl_designcorrect.DC_File1Time),
new SqlParameter("@DC_File2", tbl_designcorrect.DC_File2),
new SqlParameter("@DC_File2Correct", tbl_designcorrect.DC_File2Correct),
new SqlParameter("@DC_File2CorrectInfo", tbl_designcorrect.DC_File2CorrectInfo),
new SqlParameter("@DC_File2Time", tbl_designcorrect.DC_File2Time),
new SqlParameter("@DC_File3", tbl_designcorrect.DC_File3),
new SqlParameter("@DC_File3Correct", tbl_designcorrect.DC_File3Correct),
new SqlParameter("@DC_File3CorrectInfo", tbl_designcorrect.DC_File3CorrectInfo),
new SqlParameter("@DC_File3Time", tbl_designcorrect.DC_File3Time),
new SqlParameter("@DC_File4", tbl_designcorrect.DC_File4),
new SqlParameter("@DC_File4Correct", tbl_designcorrect.DC_File4Correct),
new SqlParameter("@DC_File4CorrectInfo", tbl_designcorrect.DC_File4CorrectInfo),
new SqlParameter("@DC_File4Time", tbl_designcorrect.DC_File4Time),
new SqlParameter("@ErrorNum1", tbl_designcorrect.ErrorNum1),
new SqlParameter("@ErrorNum2", tbl_designcorrect.ErrorNum2),
new SqlParameter("@ErrorNum3", tbl_designcorrect.ErrorNum3),
new SqlParameter("@NodeUser", tbl_designcorrect.NodeUser),
new SqlParameter("@Status", tbl_designcorrect.Status),
new SqlParameter("@DealFlag", tbl_designcorrect.DealFlag),
new SqlParameter("@DealUser", tbl_designcorrect.DealUser),
new SqlParameter("@DealTime", tbl_designcorrect.DealTime)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public static int AddTbl_DesignCorrect(Tbl_DesignCorrect tbl_designcorrect)
{
WebCommon.Public.WriteLog("添加设计文件：" + tbl_designcorrect.DC_File);
return(new Tbl_DesignCorrectService().AddTbl_DesignCorrect(tbl_designcorrect));
}
