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