/// <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)); }