/// <summary>
///根据SQL语句获取集合
/// </summary>
private IList <Tbl_ProjectOuterCompany> getTbl_ProjectOuterCompanysBySql(string sql)
{
IList <Tbl_ProjectOuterCompany> list = new List <Tbl_ProjectOuterCompany>();
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_ProjectOuterCompany tbl_projectoutercompany = new Tbl_ProjectOuterCompany();
tbl_projectoutercompany.ID = Convert.ToInt32(dr["ID"]);
tbl_projectoutercompany.POC_Type1 = Convert.ToString(dr["POC_Type1"]);
tbl_projectoutercompany.POC_Type2 = Convert.ToString(dr["POC_Type2"]);
tbl_projectoutercompany.POC_Name = Convert.ToString(dr["POC_Name"]);
tbl_projectoutercompany.POC_LinkMan = Convert.ToString(dr["POC_LinkMan"]);
tbl_projectoutercompany.POC_LinkPhone = Convert.ToString(dr["POC_LinkPhone"]);
tbl_projectoutercompany.POC_Email = Convert.ToString(dr["POC_Email"]);
tbl_projectoutercompany.POC_Address = Convert.ToString(dr["POC_Address"]);
tbl_projectoutercompany.Remark = Convert.ToString(dr["Remark"]);
tbl_projectoutercompany.AddDate = Convert.ToDateTime(dr["AddDate"]);
tbl_projectoutercompany.DealFlag = Convert.ToInt32(dr["DealFlag"]);
tbl_projectoutercompany.DealUser = Convert.ToString(dr["DealUser"]);
tbl_projectoutercompany.DealTime = Convert.ToDateTime(dr["DealTime"]);
list.Add(tbl_projectoutercompany);
}
}
return(list);
}
public static int UpdateTbl_ProjectOuterCompany(Tbl_ProjectOuterCompany tbl_projectoutercompany)
{
WebCommon.Public.WriteLog("修改外包单位：" + tbl_projectoutercompany.POC_Name);
tbl_projectoutercompany.DealUser = WebCommon.Public.GetUserName();
tbl_projectoutercompany.DealTime = DateTime.Now;
return(new Tbl_ProjectOuterCompanyService().UpdateTbl_ProjectOuterCompanyById(tbl_projectoutercompany));
}
public int AddTbl_ProjectOuterCompany(Tbl_ProjectOuterCompany tbl_projectoutercompany)
{
string sql = "insert into [Tbl_ProjectOuterCompany] ([POC_Type1],[POC_Type2],[POC_Name],[POC_LinkMan],[POC_LinkPhone],[POC_Email],[POC_Address],[Remark],[DealUser]) values (@POC_Type1,@POC_Type2,@POC_Name,@POC_LinkMan,@POC_LinkPhone,@POC_Email,@POC_Address,@Remark,@DealUser)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@POC_Type1", tbl_projectoutercompany.POC_Type1),
new SqlParameter("@POC_Type2", tbl_projectoutercompany.POC_Type2),
new SqlParameter("@POC_Name", tbl_projectoutercompany.POC_Name),
new SqlParameter("@POC_LinkMan", tbl_projectoutercompany.POC_LinkMan),
new SqlParameter("@POC_LinkPhone", tbl_projectoutercompany.POC_LinkPhone),
new SqlParameter("@POC_Email", tbl_projectoutercompany.POC_Email),
new SqlParameter("@POC_Address", tbl_projectoutercompany.POC_Address),
new SqlParameter("@Remark", tbl_projectoutercompany.Remark),
new SqlParameter("@DealUser", tbl_projectoutercompany.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public int UpdateTbl_ProjectOuterCompanyById(Tbl_ProjectOuterCompany tbl_projectoutercompany)
{
string sql = "update [Tbl_ProjectOuterCompany] set [POC_Type1]=@POC_Type1,[POC_Type2]=@POC_Type2,[POC_Name]=@POC_Name,[POC_LinkMan]=@POC_LinkMan,[POC_LinkPhone]=@POC_LinkPhone,[POC_Email]=@POC_Email,[POC_Address]=@POC_Address,[Remark]=@Remark,[DealUser]=@DealUser where DealFlag=0 and [ID]=@ID";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ID", tbl_projectoutercompany.ID),
new SqlParameter("@POC_Type1", tbl_projectoutercompany.POC_Type1),
new SqlParameter("@POC_Type2", tbl_projectoutercompany.POC_Type2),
new SqlParameter("@POC_Name", tbl_projectoutercompany.POC_Name),
new SqlParameter("@POC_LinkMan", tbl_projectoutercompany.POC_LinkMan),
new SqlParameter("@POC_LinkPhone", tbl_projectoutercompany.POC_LinkPhone),
new SqlParameter("@POC_Email", tbl_projectoutercompany.POC_Email),
new SqlParameter("@POC_Address", tbl_projectoutercompany.POC_Address),
new SqlParameter("@Remark", tbl_projectoutercompany.Remark),
new SqlParameter("@DealUser", tbl_projectoutercompany.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public static int AddTbl_ProjectOuterCompany(Tbl_ProjectOuterCompany tbl_projectoutercompany)
{
WebCommon.Public.WriteLog("添加外包单位：" + tbl_projectoutercompany.POC_Name);
return(new Tbl_ProjectOuterCompanyService().AddTbl_ProjectOuterCompany(tbl_projectoutercompany));
}
