/// <summary>
///根据SQL语句获取集合
/// </summary>
private IList <Tbl_ProjectContractPay> getTbl_ProjectContractPaysBySql(string sql)
{
IList <Tbl_ProjectContractPay> list = new List <Tbl_ProjectContractPay>();
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_ProjectContractPay tbl_projectcontractpay = new Tbl_ProjectContractPay();
tbl_projectcontractpay.ID = Convert.ToInt32(dr["ID"]);
tbl_projectcontractpay.ProjectID = Convert.ToInt32(dr["ProjectID"]);
tbl_projectcontractpay.ProjectContractID = Convert.ToInt32(dr["ProjectContractID"]);
tbl_projectcontractpay.PCP_Num = Convert.ToInt32(dr["PCP_Num"]);
tbl_projectcontractpay.PCP_MoneyTime = Convert.ToString(dr["PCP_MoneyTime"]);
tbl_projectcontractpay.PCP_Money = Convert.ToDouble(dr["PCP_Money"]);
tbl_projectcontractpay.PCP_Price = Convert.ToDouble(dr["PCP_Price"]);
tbl_projectcontractpay.PCP_Type = Convert.ToString(dr["PCP_Type"]);
tbl_projectcontractpay.Status = Convert.ToString(dr["Status"]);
tbl_projectcontractpay.AddDate = Convert.ToDateTime(dr["AddDate"]);
tbl_projectcontractpay.DealFlag = Convert.ToInt32(dr["DealFlag"]);
tbl_projectcontractpay.DealUser = Convert.ToString(dr["DealUser"]);
tbl_projectcontractpay.DealTime = Convert.ToDateTime(dr["DealTime"]);
list.Add(tbl_projectcontractpay);
}
}
return(list);
}
public static int UpdateTbl_ProjectContractPay(Tbl_ProjectContractPay tbl_projectcontractpay)
{
WebCommon.Public.WriteLog("修改项目收费：" + tbl_projectcontractpay.ProjectID);
tbl_projectcontractpay.DealUser = WebCommon.Public.GetUserName();
tbl_projectcontractpay.DealTime = DateTime.Now;
return(new Tbl_ProjectContractPayService().UpdateTbl_ProjectContractPayById(tbl_projectcontractpay));
}
public int AddTbl_ProjectContractPay(Tbl_ProjectContractPay tbl_projectcontractpay)
{
string sql = "insert into [Tbl_ProjectContractPay] ([ProjectID],[ProjectContractID],[PCP_Num],[PCP_MoneyTime],[PCP_Money],[PCP_Price],[PCP_Type],[Status],[DealUser]) values (@ProjectID,@ProjectContractID,@PCP_Num,@PCP_MoneyTime,@PCP_Money,@PCP_Price,@PCP_Type,@Status,@DealUser)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ProjectID", tbl_projectcontractpay.ProjectID),
new SqlParameter("@ProjectContractID", tbl_projectcontractpay.ProjectContractID),
new SqlParameter("@PCP_Num", tbl_projectcontractpay.PCP_Num),
new SqlParameter("@PCP_MoneyTime", tbl_projectcontractpay.PCP_MoneyTime),
new SqlParameter("@PCP_Money", tbl_projectcontractpay.PCP_Money),
new SqlParameter("@PCP_Price", tbl_projectcontractpay.PCP_Price),
new SqlParameter("@PCP_Type", tbl_projectcontractpay.PCP_Type),
new SqlParameter("@Status", tbl_projectcontractpay.Status),
new SqlParameter("@DealUser", tbl_projectcontractpay.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public int UpdateTbl_ProjectContractPayById(Tbl_ProjectContractPay tbl_projectcontractpay)
{
string sql = "update [Tbl_ProjectContractPay] set [ProjectID]=@ProjectID,[ProjectContractID]=@ProjectContractID,[PCP_Num]=@PCP_Num,[PCP_MoneyTime]=@PCP_MoneyTime,[PCP_Money]=@PCP_Money,[PCP_Price]=@PCP_Price,[PCP_Type]=@PCP_Type,[Status]=@Status,[DealUser]=@DealUser where DealFlag=0 and [ID]=@ID";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ID", tbl_projectcontractpay.ID),
new SqlParameter("@ProjectID", tbl_projectcontractpay.ProjectID),
new SqlParameter("@Alert", tbl_projectcontractpay.Alert),
new SqlParameter("@ProjectContractID", tbl_projectcontractpay.ProjectContractID),
new SqlParameter("@PCP_Num", tbl_projectcontractpay.PCP_Num),
new SqlParameter("@PCP_MoneyTime", tbl_projectcontractpay.PCP_MoneyTime),
new SqlParameter("@PCP_Money", tbl_projectcontractpay.PCP_Money),
new SqlParameter("@PCP_Price", tbl_projectcontractpay.PCP_Price),
new SqlParameter("@PCP_Type", tbl_projectcontractpay.PCP_Type),
new SqlParameter("@Status", tbl_projectcontractpay.Status),
new SqlParameter("@DealUser", tbl_projectcontractpay.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public static int AddTbl_ProjectContractPay(Tbl_ProjectContractPay tbl_projectcontractpay)
{
WebCommon.Public.WriteLog("添加项目收费：" + tbl_projectcontractpay.ProjectID);
return(new Tbl_ProjectContractPayService().AddTbl_ProjectContractPay(tbl_projectcontractpay));
}
