public static int UpdateTbl_ProjectBuyContract(Tbl_ProjectBuyContract tbl_projectbuycontract) { WebCommon.Public.WriteLog("修改合同:" + tbl_projectbuycontract.PBC_Company); tbl_projectbuycontract.DealUser = WebCommon.Public.GetUserName(); tbl_projectbuycontract.DealTime = DateTime.Now; return(new Tbl_ProjectBuyContractService().UpdateTbl_ProjectBuyContractById(tbl_projectbuycontract)); }
/// <summary> ///根据SQL语句获取集合 /// </summary> private IList <Tbl_ProjectBuyContract> getTbl_ProjectBuyContractsBySql(string sql) { IList <Tbl_ProjectBuyContract> list = new List <Tbl_ProjectBuyContract>(); 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_ProjectBuyContract tbl_projectbuycontract = new Tbl_ProjectBuyContract(); tbl_projectbuycontract.ID = Convert.ToInt32(dr["ID"]); tbl_projectbuycontract.ProjectID = Convert.ToInt32(dr["ProjectID"]); tbl_projectbuycontract.PBC_Company = Convert.ToString(dr["PBC_Company"]); tbl_projectbuycontract.PBC_File = Convert.ToString(dr["PBC_File"]); tbl_projectbuycontract.PBC_Price = Convert.ToDouble(dr["PBC_Price"]); tbl_projectbuycontract.PBC_FeeType = Convert.ToString(dr["PBC_FeeType"]); tbl_projectbuycontract.Status = Convert.ToString(dr["Status"]); tbl_projectbuycontract.AddDate = Convert.ToDateTime(dr["AddDate"]); tbl_projectbuycontract.DealFlag = Convert.ToInt32(dr["DealFlag"]); tbl_projectbuycontract.DealUser = Convert.ToString(dr["DealUser"]); tbl_projectbuycontract.DealTime = Convert.ToDateTime(dr["DealTime"]); list.Add(tbl_projectbuycontract); } } return(list); }
public int AddTbl_ProjectBuyContract(Tbl_ProjectBuyContract tbl_projectbuycontract) { string sql = "insert into [Tbl_ProjectBuyContract] ([ProjectID],[PBC_Company],[PBC_File],[PBC_Price],[PBC_FeeType],[Status],[DealUser]) values (@ProjectID,@PBC_Company,@PBC_File,@PBC_Price,@PBC_FeeType,@Status,@DealUser)"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@ProjectID", tbl_projectbuycontract.ProjectID), new SqlParameter("@PBC_Company", tbl_projectbuycontract.PBC_Company), new SqlParameter("@PBC_File", tbl_projectbuycontract.PBC_File), new SqlParameter("@PBC_Price", tbl_projectbuycontract.PBC_Price), new SqlParameter("@PBC_FeeType", tbl_projectbuycontract.PBC_FeeType), new SqlParameter("@Status", tbl_projectbuycontract.Status), new SqlParameter("@DealUser", tbl_projectbuycontract.DealUser) }; return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp)); }
public int UpdateTbl_ProjectBuyContractById(Tbl_ProjectBuyContract tbl_projectbuycontract) { string sql = "update [Tbl_ProjectBuyContract] set [ProjectID]=@ProjectID,[PBC_Company]=@PBC_Company,[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_projectbuycontract.ID), new SqlParameter("@ProjectID", tbl_projectbuycontract.ProjectID), new SqlParameter("@PBC_Company", tbl_projectbuycontract.PBC_Company), new SqlParameter("@PBC_File", tbl_projectbuycontract.PBC_File), new SqlParameter("@PBC_Price", tbl_projectbuycontract.PBC_Price), new SqlParameter("@PBC_FeeType", tbl_projectbuycontract.PBC_FeeType), new SqlParameter("@Status", tbl_projectbuycontract.Status), new SqlParameter("@DealUser", tbl_projectbuycontract.DealUser) }; return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp)); }
public static int AddTbl_ProjectBuyContract(Tbl_ProjectBuyContract tbl_projectbuycontract) { WebCommon.Public.WriteLog("添加合同:" + tbl_projectbuycontract.PBC_Company); return(new Tbl_ProjectBuyContractService().AddTbl_ProjectBuyContract(tbl_projectbuycontract)); }