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