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