/// <summary>
///根据Sql语句返回集合
/// </summary>
private IList <Tbl_OtherWork> getTbl_OtherWorksBySql(string Sql)
{
IList <Tbl_OtherWork> list = new List <Tbl_OtherWork>();
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_OtherWork tbl_otherwork = new Tbl_OtherWork();
tbl_otherwork.ID = Convert.ToInt32(dr["ID"]);
tbl_otherwork.ProjectID = Convert.ToInt32(dr["ProjectID"]);
tbl_otherwork.ProjectName = Convert.ToString(dr["ProjectName"]);
tbl_otherwork.UserName = Convert.ToString(dr["UserName"]);
tbl_otherwork.WorkType = Convert.ToString(dr["WorkType"]);
tbl_otherwork.WorkDay = Convert.ToString(dr["WorkDay"]);
tbl_otherwork.WorkInfo = Convert.ToString(dr["WorkInfo"]);
tbl_otherwork.NodeUser = Convert.ToString(dr["NodeUser"]);
tbl_otherwork.Status = Convert.ToString(dr["Status"]);
tbl_otherwork.DealUser = Convert.ToString(dr["DealUser"]);
tbl_otherwork.DealFlag = Convert.ToInt32(dr["DealFlag"]);
tbl_otherwork.DealTime = Convert.ToDateTime(dr["DealTime"]);
tbl_otherwork.AddDate = Convert.ToDateTime(dr["AddDate"]);
list.Add(tbl_otherwork);
}
}
return(list);
}
public static int DeleteTbl_OtherWork(int ID)
{
Tbl_OtherWork tbl_otherwork = GetTbl_OtherWorkById(ID);
WebCommon.Public.WriteLog("删除其他工日");
return(new Tbl_OtherWorkService().DeleteTbl_OtherWorkById(ID));
}
public int AddTbl_OtherWork(Tbl_OtherWork tbl_otherwork)
{
string Sql = "insert into [Tbl_OtherWork] ([ProjectID],[ProjectName],[UserName],[WorkType],[WorkDay],[WorkInfo],[NodeUser],[Status],[DealUser],[DealFlag],[DealTime],[AddDate]) values (@ProjectID,@ProjectName,@UserName,@WorkType,@WorkDay,@WorkInfo,@NodeUser,@Status,@DealUser,@DealFlag,@DealTime,@AddDate)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ProjectID", tbl_otherwork.ProjectID),
new SqlParameter("@ProjectName", tbl_otherwork.ProjectName),
new SqlParameter("@UserName", tbl_otherwork.UserName),
new SqlParameter("@WorkType", tbl_otherwork.WorkType),
new SqlParameter("@WorkDay", tbl_otherwork.WorkDay),
new SqlParameter("@WorkInfo", tbl_otherwork.WorkInfo),
new SqlParameter("@NodeUser", tbl_otherwork.NodeUser),
new SqlParameter("@Status", tbl_otherwork.Status),
new SqlParameter("@DealUser", tbl_otherwork.DealUser),
new SqlParameter("@DealFlag", tbl_otherwork.DealFlag),
new SqlParameter("@DealTime", tbl_otherwork.DealTime),
new SqlParameter("@AddDate", tbl_otherwork.AddDate)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, Sql, sp));
}
public int UpdateTbl_OtherWorkById(Tbl_OtherWork tbl_otherwork)
{
string Sql = "update [Tbl_OtherWork] set [ProjectID]=@ProjectID,[ProjectName]=@ProjectName,[UserName]=@UserName,[WorkType]=@WorkType,[WorkDay]=@WorkDay,[WorkInfo]=@WorkInfo,[NodeUser]=@NodeUser,[Status]=@Status,[DealUser]=@DealUser,[DealFlag]=@DealFlag,[DealTime]=@DealTime,[AddDate]=@AddDate where [ID]=@ID";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ProjectID", tbl_otherwork.ProjectID),
new SqlParameter("@ProjectName", tbl_otherwork.ProjectName),
new SqlParameter("@UserName", tbl_otherwork.UserName),
new SqlParameter("@WorkType", tbl_otherwork.WorkType),
new SqlParameter("@WorkDay", tbl_otherwork.WorkDay),
new SqlParameter("@WorkInfo", tbl_otherwork.WorkInfo),
new SqlParameter("@NodeUser", tbl_otherwork.NodeUser),
new SqlParameter("@Status", tbl_otherwork.Status),
new SqlParameter("@DealUser", tbl_otherwork.DealUser),
new SqlParameter("@DealFlag", tbl_otherwork.DealFlag),
new SqlParameter("@DealTime", tbl_otherwork.DealTime),
new SqlParameter("@AddDate", tbl_otherwork.AddDate),
new SqlParameter("@ID", tbl_otherwork.ID)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, Sql, sp));
}
public static int UpdateTbl_OtherWork(Tbl_OtherWork tbl_otherwork)
{
WebCommon.Public.WriteLog("修改其他工日");
return(new Tbl_OtherWorkService().UpdateTbl_OtherWorkById(tbl_otherwork));
}
public static int AddTbl_OtherWork(Tbl_OtherWork tbl_otherwork)
{
WebCommon.Public.WriteLog("添加其他工日");
return(new Tbl_OtherWorkService().AddTbl_OtherWork(tbl_otherwork));
}
