public static int UpdateTbl_ProjectBuilderContract(Tbl_ProjectBuilderContract tbl_projectbuildercontract) { WebCommon.Public.WriteLog("修改施工合同:" + tbl_projectbuildercontract.ProjectID); tbl_projectbuildercontract.DealUser = WebCommon.Public.GetUserName(); tbl_projectbuildercontract.DealTime = DateTime.Now; return(new Tbl_ProjectBuilderContractService().UpdateTbl_ProjectBuilderContractById(tbl_projectbuildercontract)); }
/// <summary> ///根据SQL语句获取集合 /// </summary> private IList <Tbl_ProjectBuilderContract> getTbl_ProjectBuilderContractsBySql(string sql) { IList <Tbl_ProjectBuilderContract> list = new List <Tbl_ProjectBuilderContract>(); 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_ProjectBuilderContract tbl_projectbuildercontract = new Tbl_ProjectBuilderContract(); tbl_projectbuildercontract.ID = Convert.ToInt32(dr["ID"]); tbl_projectbuildercontract.ProjectID = Convert.ToInt32(dr["ProjectID"]); tbl_projectbuildercontract.PBC_CompanyID = Convert.ToInt32(dr["PBC_CompanyID"]); tbl_projectbuildercontract.PBC_StartTime = Convert.ToDateTime(dr["PBC_StartTime"]); tbl_projectbuildercontract.PBC_Time1 = Convert.ToDateTime(dr["PBC_Time1"]); tbl_projectbuildercontract.PBC_Time2 = Convert.ToDateTime(dr["PBC_Time2"]); tbl_projectbuildercontract.PBC_Link = Convert.ToString(dr["PBC_Link"]); tbl_projectbuildercontract.PBC_LinkPhone = Convert.ToString(dr["PBC_LinkPhone"]); tbl_projectbuildercontract.PBC_Content = Convert.ToString(dr["PBC_Content"]); tbl_projectbuildercontract.Remark = Convert.ToString(dr["Remark"]); tbl_projectbuildercontract.PBC_File = Convert.ToString(dr["PBC_File"]); tbl_projectbuildercontract.PBC_Price = Convert.ToDouble(dr["PBC_Price"]); tbl_projectbuildercontract.PBC_FeeType = Convert.ToString(dr["PBC_FeeType"]); tbl_projectbuildercontract.Status = Convert.ToString(dr["Status"]); tbl_projectbuildercontract.AddDate = Convert.ToDateTime(dr["AddDate"]); tbl_projectbuildercontract.DealFlag = Convert.ToInt32(dr["DealFlag"]); tbl_projectbuildercontract.DealUser = Convert.ToString(dr["DealUser"]); tbl_projectbuildercontract.DealTime = Convert.ToDateTime(dr["DealTime"]); list.Add(tbl_projectbuildercontract); } } return(list); }
public int AddTbl_ProjectBuilderContract(Tbl_ProjectBuilderContract tbl_projectbuildercontract) { string sql = "insert into [Tbl_ProjectBuilderContract] ([ProjectID],[PBC_CompanyID],[PBC_StartTime],[PBC_Time1],[PBC_Time2],[PBC_Link],[PBC_LinkPhone],[PBC_Content],[Remark],[PBC_File],[PBC_Price],[PBC_FeeType],[Status],[DealUser]) values (@ProjectID,@PBC_CompanyID,@PBC_StartTime,@PBC_Time1,@PBC_Time2,@PBC_Link,@PBC_LinkPhone,@PBC_Content,@Remark,@PBC_File,@PBC_Price,@PBC_FeeType,@Status,@DealUser)"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@ProjectID", tbl_projectbuildercontract.ProjectID), new SqlParameter("@PBC_CompanyID", tbl_projectbuildercontract.PBC_CompanyID), new SqlParameter("@PBC_StartTime", tbl_projectbuildercontract.PBC_StartTime), new SqlParameter("@PBC_Time1", tbl_projectbuildercontract.PBC_Time1), new SqlParameter("@PBC_Time2", tbl_projectbuildercontract.PBC_Time2), new SqlParameter("@PBC_Link", tbl_projectbuildercontract.PBC_Link), new SqlParameter("@PBC_LinkPhone", tbl_projectbuildercontract.PBC_LinkPhone), new SqlParameter("@PBC_Content", tbl_projectbuildercontract.PBC_Content), new SqlParameter("@Remark", tbl_projectbuildercontract.Remark), new SqlParameter("@PBC_File", tbl_projectbuildercontract.PBC_File), new SqlParameter("@PBC_Price", tbl_projectbuildercontract.PBC_Price), new SqlParameter("@PBC_FeeType", tbl_projectbuildercontract.PBC_FeeType), new SqlParameter("@Status", tbl_projectbuildercontract.Status), new SqlParameter("@DealUser", tbl_projectbuildercontract.DealUser) }; return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp)); }
public int UpdateTbl_ProjectBuilderContractById(Tbl_ProjectBuilderContract tbl_projectbuildercontract) { string sql = "update [Tbl_ProjectBuilderContract] set [ProjectID]=@ProjectID,[PBC_CompanyID]=@PBC_CompanyID,[PBC_StartTime]=@PBC_StartTime,[PBC_Time1]=@PBC_Time1,[PBC_Time2]=@PBC_Time2,[PBC_Link]=@PBC_Link,[PBC_LinkPhone]=@PBC_LinkPhone,[PBC_Content]=@PBC_Content,[Remark]=@Remark,[PBC_File]=@PBC_File,[PBC_Price]=@PBC_Price,[PBC_FeeType]=@PBC_FeeType,[Status]=@Status,[DealUser]=@DealUser where DealFlag=0 and [ID]=@ID"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@ID", tbl_projectbuildercontract.ID), new SqlParameter("@ProjectID", tbl_projectbuildercontract.ProjectID), new SqlParameter("@PBC_CompanyID", tbl_projectbuildercontract.PBC_CompanyID), new SqlParameter("@PBC_StartTime", tbl_projectbuildercontract.PBC_StartTime), new SqlParameter("@PBC_Time1", tbl_projectbuildercontract.PBC_Time1), new SqlParameter("@PBC_Time2", tbl_projectbuildercontract.PBC_Time2), new SqlParameter("@PBC_Link", tbl_projectbuildercontract.PBC_Link), new SqlParameter("@PBC_LinkPhone", tbl_projectbuildercontract.PBC_LinkPhone), new SqlParameter("@PBC_Content", tbl_projectbuildercontract.PBC_Content), new SqlParameter("@Remark", tbl_projectbuildercontract.Remark), new SqlParameter("@PBC_File", tbl_projectbuildercontract.PBC_File), new SqlParameter("@PBC_Price", tbl_projectbuildercontract.PBC_Price), new SqlParameter("@PBC_FeeType", tbl_projectbuildercontract.PBC_FeeType), new SqlParameter("@Status", tbl_projectbuildercontract.Status), new SqlParameter("@DealUser", tbl_projectbuildercontract.DealUser) }; return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp)); }
public static int AddTbl_ProjectBuilderContract(Tbl_ProjectBuilderContract tbl_projectbuildercontract) { WebCommon.Public.WriteLog("添加施工合同:" + tbl_projectbuildercontract.ProjectID); return(new Tbl_ProjectBuilderContractService().AddTbl_ProjectBuilderContract(tbl_projectbuildercontract)); }