/// <summary>
///根据SQL语句获取集合
/// </summary>
private IList <Tbl_ProjectOuterPay> getTbl_ProjectOuterPaysBySql(string sql)
{
IList <Tbl_ProjectOuterPay> list = new List <Tbl_ProjectOuterPay>();
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_ProjectOuterPay tbl_projectcontractpay = new Tbl_ProjectOuterPay();
tbl_projectcontractpay.ID = Convert.ToInt32(dr["ID"]);
tbl_projectcontractpay.ProjectID = Convert.ToInt32(dr["ProjectID"]);
tbl_projectcontractpay.ProjectOuterID = Convert.ToInt32(dr["ProjectOuterID"]);
tbl_projectcontractpay.POP_Num = Convert.ToInt32(dr["POP_Num"]);
tbl_projectcontractpay.POP_MoneyTime = Convert.ToString(dr["POP_MoneyTime"]);
tbl_projectcontractpay.POP_Money = Convert.ToDouble(dr["POP_Money"]);
tbl_projectcontractpay.POP_Price = Convert.ToDouble(dr["POP_Price"]);
tbl_projectcontractpay.POP_Type = Convert.ToString(dr["POP_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_ProjectOuterPay(Tbl_ProjectOuterPay tbl_projectcontractpay)
{
WebCommon.Public.WriteLog("修改项目收费：" + tbl_projectcontractpay.ProjectID);
tbl_projectcontractpay.DealUser = WebCommon.Public.GetUserName();
tbl_projectcontractpay.DealTime = DateTime.Now;
return(new Tbl_ProjectOuterPayService().UpdateTbl_ProjectOuterPayById(tbl_projectcontractpay));
}
public int AddTbl_ProjectOuterPay(Tbl_ProjectOuterPay tbl_projectcontractpay)
{
string sql = "insert into [Tbl_ProjectOuterPay] ([ProjectID],[ProjectOuterID],[POP_Num],[POP_MoneyTime],[POP_Money],[POP_Price],[POP_Type],[Status],[DealUser]) values (@ProjectID,@ProjectOuterID,@POP_Num,@POP_MoneyTime,@POP_Money,@POP_Price,@POP_Type,@Status,@DealUser)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ProjectID", tbl_projectcontractpay.ProjectID),
new SqlParameter("@ProjectOuterID", tbl_projectcontractpay.ProjectOuterID),
new SqlParameter("@POP_Num", tbl_projectcontractpay.POP_Num),
new SqlParameter("@POP_MoneyTime", tbl_projectcontractpay.POP_MoneyTime),
new SqlParameter("@POP_Money", tbl_projectcontractpay.POP_Money),
new SqlParameter("@POP_Price", tbl_projectcontractpay.POP_Price),
new SqlParameter("@POP_Type", tbl_projectcontractpay.POP_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_ProjectOuterPayById(Tbl_ProjectOuterPay tbl_projectcontractpay)
{
string sql = "update [Tbl_ProjectOuterPay] set [ProjectID]=@ProjectID,[ProjectOuterID]=@ProjectOuterID,[POP_Num]=@POP_Num,[POP_MoneyTime]=@POP_MoneyTime,[POP_Money]=@POP_Money,[POP_Price]=@POP_Price,[POP_Type]=@POP_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("@ProjectOuterID", tbl_projectcontractpay.ProjectOuterID),
new SqlParameter("@POP_Num", tbl_projectcontractpay.POP_Num),
new SqlParameter("@POP_MoneyTime", tbl_projectcontractpay.POP_MoneyTime),
new SqlParameter("@POP_Money", tbl_projectcontractpay.POP_Money),
new SqlParameter("@POP_Price", tbl_projectcontractpay.POP_Price),
new SqlParameter("@POP_Type", tbl_projectcontractpay.POP_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_ProjectOuterPay(Tbl_ProjectOuterPay tbl_projectcontractpay)
{
WebCommon.Public.WriteLog("添加项目收费：" + tbl_projectcontractpay.ProjectID);
return(new Tbl_ProjectOuterPayService().AddTbl_ProjectOuterPay(tbl_projectcontractpay));
}
