/// <summary>
///根据SQL语句获取集合
/// </summary>
private IList <Tbl_DesignChange> getTbl_DesignChangesBySql(string sql)
{
IList <Tbl_DesignChange> list = new List <Tbl_DesignChange>();
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_DesignChange tbl_designchange = new Tbl_DesignChange();
tbl_designchange.ID = Convert.ToInt32(dr["ID"]);
tbl_designchange.UserName = Convert.ToString(dr["UserName"]);
tbl_designchange.ProjectID = Convert.ToInt32(dr["ProjectID"]);
tbl_designchange.Contact = Convert.ToString(dr["Contact"]);
tbl_designchange.Phone = Convert.ToString(dr["Phone"]);
tbl_designchange.FileNo = Convert.ToString(dr["FileNo"]);
tbl_designchange.ChangeTime = Convert.ToDateTime(dr["ChangeTime"]);
tbl_designchange.ChangeInfo = Convert.ToString(dr["ChangeInfo"]);
tbl_designchange.ChangeFile = Convert.ToString(dr["ChangeFile"]);
tbl_designchange.ChangeDwg = Convert.ToString(dr["ChangeDwg"]);
tbl_designchange.Status = Convert.ToString(dr["Status"]);
tbl_designchange.DealFlag = Convert.ToInt32(dr["DealFlag"]);
tbl_designchange.DealTime = Convert.ToDateTime(dr["DealTime"]);
tbl_designchange.DealUser = Convert.ToString(dr["DealUser"]);
tbl_designchange.AddDate = Convert.ToDateTime(dr["AddDate"]);
list.Add(tbl_designchange);
}
}
return(list);
}
public static int UpdateTbl_DesignChange(Tbl_DesignChange tbl_designchange)
{
WebCommon.Public.WriteLog("修改项目变更单：" + tbl_designchange.ProjectID);
tbl_designchange.DealUser = WebCommon.Public.GetUserName();
tbl_designchange.DealTime = DateTime.Now;
return(new Tbl_DesignChangeService().UpdateTbl_DesignChangeById(tbl_designchange));
}
public int AddTbl_DesignChange(Tbl_DesignChange tbl_designchange)
{
string sql = "insert into [Tbl_DesignChange] ([UserName],[ProjectID],[Contact],[Phone],[FileNo],[ChangeTime],[ChangeInfo],[ChangeFile],[ChangeDwg],[Status],[DealUser]) values (@UserName,@ProjectID,@Contact,@Phone,@FileNo,@ChangeTime,@ChangeInfo,@ChangeFile,@ChangeDwg,@Status,@DealUser)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@UserName", tbl_designchange.UserName),
new SqlParameter("@ProjectID", tbl_designchange.ProjectID),
new SqlParameter("@Contact", tbl_designchange.Contact),
new SqlParameter("@Phone", tbl_designchange.Phone),
new SqlParameter("@FileNo", tbl_designchange.FileNo),
new SqlParameter("@ChangeTime", tbl_designchange.ChangeTime),
new SqlParameter("@ChangeInfo", tbl_designchange.ChangeInfo),
new SqlParameter("@ChangeFile", tbl_designchange.ChangeFile),
new SqlParameter("@ChangeDwg", tbl_designchange.ChangeDwg),
new SqlParameter("@Status", tbl_designchange.Status),
new SqlParameter("@DealUser", tbl_designchange.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public int UpdateTbl_DesignChangeById(Tbl_DesignChange tbl_designchange)
{
string sql = "update [Tbl_DesignChange] set [UserName]=@UserName,[ProjectID]=@ProjectID,[Contact]=@Contact,[Phone]=@Phone,[FileNo]=@FileNo,[ChangeTime]=@ChangeTime,[ChangeInfo]=@ChangeInfo,[ChangeFile]=@ChangeFile,[ChangeDwg]=@ChangeDwg,[Status]=@Status,[DealUser]=@DealUser where DealFlag=0 and [ID]=@ID";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ID", tbl_designchange.ID),
new SqlParameter("@UserName", tbl_designchange.UserName),
new SqlParameter("@ProjectID", tbl_designchange.ProjectID),
new SqlParameter("@Contact", tbl_designchange.Contact),
new SqlParameter("@Phone", tbl_designchange.Phone),
new SqlParameter("@FileNo", tbl_designchange.FileNo),
new SqlParameter("@ChangeTime", tbl_designchange.ChangeTime),
new SqlParameter("@ChangeInfo", tbl_designchange.ChangeInfo),
new SqlParameter("@ChangeFile", tbl_designchange.ChangeFile),
new SqlParameter("@ChangeDwg", tbl_designchange.ChangeDwg),
new SqlParameter("@Status", tbl_designchange.Status),
new SqlParameter("@DealUser", tbl_designchange.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public static int AddTbl_DesignChange(Tbl_DesignChange tbl_designchange)
{
WebCommon.Public.WriteLog("添加项目变更单：" + tbl_designchange.ProjectID);
return(new Tbl_DesignChangeService().AddTbl_DesignChange(tbl_designchange));
}
