/// <summary>
///根据SQL语句获取集合
/// </summary>
private IList <Tbl_ProjectBuilder> getTbl_ProjectBuildersBySql(string sql)
{
IList <Tbl_ProjectBuilder> list = new List <Tbl_ProjectBuilder>();
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_ProjectBuilder tbl_projectbuilder = new Tbl_ProjectBuilder();
tbl_projectbuilder.ID = Convert.ToInt32(dr["ID"]);
tbl_projectbuilder.ProjectID = Convert.ToInt32(dr["ProjectID"]);
tbl_projectbuilder.ProjectBuilderContractID = Convert.ToInt32(dr["ProjectBuilderContractID"]);
tbl_projectbuilder.POC_Name = Convert.ToString(dr["POC_Name"]);
tbl_projectbuilder.POC_LinkMan = Convert.ToString(dr["POC_LinkMan"]);
tbl_projectbuilder.POC_LinkPhone = Convert.ToString(dr["POC_LinkPhone"]);
tbl_projectbuilder.POC_Email = Convert.ToString(dr["POC_Email"]);
tbl_projectbuilder.Remark = Convert.ToString(dr["Remark"]);
tbl_projectbuilder.AddDate = Convert.ToDateTime(dr["AddDate"]);
tbl_projectbuilder.DealFlag = Convert.ToInt32(dr["DealFlag"]);
tbl_projectbuilder.DealUser = Convert.ToString(dr["DealUser"]);
tbl_projectbuilder.DealTime = Convert.ToDateTime(dr["DealTime"]);
list.Add(tbl_projectbuilder);
}
}
return(list);
}
public static int UpdateTbl_ProjectBuilder(Tbl_ProjectBuilder tbl_projectbuilder)
{
WebCommon.Public.WriteLog("修改施工单位：" + tbl_projectbuilder.POC_Name);
tbl_projectbuilder.DealUser = WebCommon.Public.GetUserName();
tbl_projectbuilder.DealTime = DateTime.Now;
return(new Tbl_ProjectBuilderService().UpdateTbl_ProjectBuilderById(tbl_projectbuilder));
}
public int AddTbl_ProjectBuilder(Tbl_ProjectBuilder tbl_projectbuilder)
{
string sql = "insert into [Tbl_ProjectBuilder] ([ProjectID],[ProjectBuilderContractID],[POC_Name],[POC_LinkMan],[POC_LinkPhone],[POC_Email],[Remark],[DealUser]) values (@ProjectID,@ProjectBuilderContractID,@POC_Name,@POC_LinkMan,@POC_LinkPhone,@POC_Email,@Remark,@DealUser)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ProjectID", tbl_projectbuilder.ProjectID),
new SqlParameter("@ProjectBuilderContractID", tbl_projectbuilder.ProjectBuilderContractID),
new SqlParameter("@POC_Name", tbl_projectbuilder.POC_Name),
new SqlParameter("@POC_LinkMan", tbl_projectbuilder.POC_LinkMan),
new SqlParameter("@POC_LinkPhone", tbl_projectbuilder.POC_LinkPhone),
new SqlParameter("@POC_Email", tbl_projectbuilder.POC_Email),
new SqlParameter("@Remark", tbl_projectbuilder.Remark),
new SqlParameter("@DealUser", tbl_projectbuilder.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public int UpdateTbl_ProjectBuilderById(Tbl_ProjectBuilder tbl_projectbuilder)
{
string sql = "update [Tbl_ProjectBuilder] set [ProjectID]=@ProjectID,[ProjectBuilderContractID]=@ProjectBuilderContractID,[POC_Name]=@POC_Name,[POC_LinkMan]=@POC_LinkMan,[POC_LinkPhone]=@POC_LinkPhone,[POC_Email]=@POC_Email,[Remark]=@Remark,[DealUser]=@DealUser where DealFlag=0 and [ID]=@ID";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ID", tbl_projectbuilder.ID),
new SqlParameter("@ProjectID", tbl_projectbuilder.ProjectID),
new SqlParameter("@ProjectBuilderContractID", tbl_projectbuilder.ProjectBuilderContractID),
new SqlParameter("@POC_Name", tbl_projectbuilder.POC_Name),
new SqlParameter("@POC_LinkMan", tbl_projectbuilder.POC_LinkMan),
new SqlParameter("@POC_LinkPhone", tbl_projectbuilder.POC_LinkPhone),
new SqlParameter("@POC_Email", tbl_projectbuilder.POC_Email),
new SqlParameter("@Remark", tbl_projectbuilder.Remark),
new SqlParameter("@DealUser", tbl_projectbuilder.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public static int AddTbl_ProjectBuilder(Tbl_ProjectBuilder tbl_projectbuilder)
{
WebCommon.Public.WriteLog("添加施工单位：" + tbl_projectbuilder.POC_Name);
return(new Tbl_ProjectBuilderService().AddTbl_ProjectBuilder(tbl_projectbuilder));
}
