/// <summary>
/// 新增申请付款单
/// </summary>
/// <param name="buypay"></param>
/// <returns></returns>
public int InsBuyPayment(BuyPayment buypay)
{
string sql = @"INSERT INTO T_BuyPayment
(Buy_Code
,Buy_BCode
,Buy_Date
,Buy_SuName
,Buy_AccountName
,Buy_AmountPay
,Buy_moneyOwed
,Buy_AccountPaid
,Buy_SalesMan
,Buy_Remark
,Buy_States
,Buy_Class)
Values
(@Buy_Code
,@Buy_BCode
,@Buy_Date
,@Buy_SuName
,@Buy_AccountName
,@Buy_AmountPay
,@Buy_moneyOwed
,@Buy_AccountPaid
,@Buy_SalesMan
,@Buy_Remark
,@Buy_States
,@Buy_Class)";
SqlParameter[] sps =
{
new SqlParameter("@Buy_Code", XYEEncoding.strCodeHex(buypay.Buy_Code)),
new SqlParameter("@Buy_BCode", XYEEncoding.strCodeHex(buypay.Buy_BCode)),
new SqlParameter("@Buy_Date", (buypay.Buy_Date)),
new SqlParameter("@Buy_SuName", XYEEncoding.strCodeHex(buypay.Buy_SuName)),
new SqlParameter("@Buy_AccountName", XYEEncoding.strCodeHex(buypay.Buy_AccountName)),
new SqlParameter("@Buy_AmountPay", XYEEncoding.strCodeHex(buypay.Buy_AmountPay)),
new SqlParameter("@Buy_moneyOwed", XYEEncoding.strCodeHex(buypay.Buy_moneyOwed)),
new SqlParameter("@Buy_AccountPaid", XYEEncoding.strCodeHex(buypay.Buy_AccountPaid)),
new SqlParameter("@Buy_SalesMan", XYEEncoding.strCodeHex(buypay.Buy_SalesMan)),
new SqlParameter("@Buy_Remark", buypay.Buy_Remark),
new SqlParameter("@Buy_States", buypay.Buy_States),
new SqlParameter("@Buy_Class", buypay.Buy_Class)
};
return(DbHelperSQL.ExecuteSql(sql, sps));
}
private int InsBuypaymentFun()
{
BuyPayment bp = new BuyPayment();
bp.Buy_Date = Convert.ToDateTime(dateTimePicker1.Text);
bp.Buy_Code = textBoxOddNumbers.Text.Trim();
bp.Buy_BCode = txt_caigoucode.Text.Trim();
bp.Buy_SuName = ltxt_suname.Text.Trim();
bp.Buy_AccountName = ltxt_AccountName.Text.Trim();
bp.Buy_AmountPay = txt_shif.Text.Trim();
bp.Buy_moneyOwed = ltxt_weipay.Text.Trim();
bp.Buy_AccountPaid = txt_yifu.Text.Trim().ToString();
bp.Buy_SalesMan = ltxt_saleman.Text.Trim();
bp.Buy_Remark = ltxt_remark.Text.Trim();
bp.Buy_States = zhuangtai;
bp.Buy_Class = "37425C525B0A5141";
return(bpm.InsBuyPayment(bp));
}
/*
* /// <summary>
* /// 分页获取数据列表
* /// </summary>
* public DataSet GetList(int PageSize,int PageIndex,string strWhere)
* {
* SqlParameter[] parameters = {
* new SqlParameter("@tblName", SqlDbType.VarChar, 255),
* new SqlParameter("@fldName", SqlDbType.VarChar, 255),
* new SqlParameter("@PageSize", SqlDbType.Int),
* new SqlParameter("@PageIndex", SqlDbType.Int),
* new SqlParameter("@IsReCount", SqlDbType.Bit),
* new SqlParameter("@OrderType", SqlDbType.Bit),
* new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
* };
* parameters[0].Value = "T_BuyPayment";
* parameters[1].Value = "Buy_ID";
* parameters[2].Value = PageSize;
* parameters[3].Value = PageIndex;
* parameters[4].Value = 0;
* parameters[5].Value = 0;
* parameters[6].Value = strWhere;
* return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
* }*/
#endregion BasicMethod
#region ExtensionMethod
/// <summary>
/// 更新付款状态和审核状态是方法
/// </summary>
public bool PaymentUpdate(BuyPayment model)
{
string sql = string.Format(@"update T_BuyPayment set
Buy_Zhuangtai=1,
Buy_States=1,
Buy_Actmoney='{0}',
Buy_AuditMan='{1}',
Buy_Remark='{2}'
where Buy_Class = '37425C525B0A5141' and Buy_Code = '{3}'", model.Buy_Actmoney, model.Buy_AuditMan, model.Buy_Remark, model.Buy_Code);
int rows = DbHelperSQL.ExecuteSql(sql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public BuyPayment GetModel(string Buy_Code)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Buy_ID,Buy_Code,Buy_SuCode,Buy_SuName,Buy_BCode,Buy_Name,Buy_AccountCode,Buy_AccountName,Buy_Date,Buy_AmountPay,Buy_AccountPaid,Buy_moneyOwed,Buy_SalesMan,Buy_SalesCode,Buy_AuditMan,Buy_Premoney,Buy_Actmoney,Buy_Zhuangtai,Buy_Remark,Buy_Satetyone,Buy_Satetytwo,Buy_Clear,Buy_States from T_BuyPayment ");
strSql.Append(" where Buy_Code=@Buy_Code");
SqlParameter[] parameters =
{
new SqlParameter("@Buy_Code", SqlDbType.NVarChar, 512)
};
parameters[0].Value = Buy_Code;
BuyPayment model = new BuyPayment();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BuyPayment model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BuyPayment model)
{
return(dal.Add(model));
}
/// <summary>
/// 新增申请付款单
/// </summary>
/// <param name="buypay"></param>
/// <returns></returns>
public int InsBuyPayment(BuyPayment buypay)
{
return(dal.InsBuyPayment(buypay));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BuyPayment model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_BuyPayment(");
strSql.Append("Buy_Code,Buy_SuCode,Buy_SuName,Buy_BCode,Buy_Name,Buy_AccountCode,Buy_AccountName,Buy_Date,Buy_AmountPay,Buy_AccountPaid,Buy_moneyOwed,Buy_SalesMan,Buy_SalesCode,Buy_AuditMan,Buy_Premoney,Buy_Actmoney,Buy_Zhuangtai,Buy_Remark,Buy_Satetyone,Buy_Satetytwo,Buy_Clear,Buy_States)");
strSql.Append(" values (");
strSql.Append("@Buy_Code,@Buy_SuCode,@Buy_SuName,@Buy_BCode,@Buy_Name,@Buy_AccountCode,@Buy_AccountName,@Buy_Date,@Buy_AmountPay,@Buy_AccountPaid,@Buy_moneyOwed,@Buy_SalesMan,@Buy_SalesCode,@Buy_AuditMan,@Buy_Premoney,@Buy_Actmoney,@Buy_Zhuangtai,@Buy_Remark,@Buy_Satetyone,@Buy_Satetytwo,@Buy_Clear,@Buy_States)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Buy_Code", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_SuCode", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_SuName", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_BCode", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_Name", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_AccountCode", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_AccountName", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_Date", SqlDbType.DateTime),
new SqlParameter("@Buy_AmountPay", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_AccountPaid", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_moneyOwed", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_SalesMan", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_SalesCode", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_AuditMan", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_Premoney", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_Actmoney", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_Zhuangtai", SqlDbType.Money, 8),
new SqlParameter("@Buy_Remark", SqlDbType.NVarChar, 1024),
new SqlParameter("@Buy_Satetyone", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_Satetytwo", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_Clear", SqlDbType.Int, 4),
new SqlParameter("@Buy_States", SqlDbType.Int, 4)
};
parameters[0].Value = model.Buy_Code;
parameters[1].Value = model.Buy_SuCode;
parameters[2].Value = model.Buy_SuName;
parameters[3].Value = model.Buy_BCode;
parameters[4].Value = model.Buy_Name;
parameters[5].Value = model.Buy_AccountCode;
parameters[6].Value = model.Buy_AccountName;
parameters[7].Value = model.Buy_Date;
parameters[8].Value = model.Buy_AmountPay;
parameters[9].Value = model.Buy_AccountPaid;
parameters[10].Value = model.Buy_moneyOwed;
parameters[11].Value = model.Buy_SalesMan;
parameters[12].Value = model.Buy_SalesCode;
parameters[13].Value = model.Buy_AuditMan;
parameters[14].Value = model.Buy_Premoney;
parameters[15].Value = model.Buy_Actmoney;
parameters[16].Value = model.Buy_Zhuangtai;
parameters[17].Value = model.Buy_Remark;
parameters[18].Value = model.Buy_Satetyone;
parameters[19].Value = model.Buy_Satetytwo;
parameters[20].Value = model.Buy_Clear;
parameters[21].Value = model.Buy_States;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public BuyPayment DataRowToModel(DataRow row)
{
BuyPayment model = new BuyPayment();
if (row != null)
{
if (row["Buy_ID"] != null && row["Buy_ID"].ToString() != "")
{
model.Buy_ID = int.Parse(row["Buy_ID"].ToString());
}
if (row["Buy_Code"] != null)
{
model.Buy_Code = row["Buy_Code"].ToString();
}
if (row["Buy_SuCode"] != null)
{
model.Buy_SuCode = row["Buy_SuCode"].ToString();
}
if (row["Buy_SuName"] != null)
{
model.Buy_SuName = row["Buy_SuName"].ToString();
}
if (row["Buy_BCode"] != null)
{
model.Buy_BCode = row["Buy_BCode"].ToString();
}
if (row["Buy_Name"] != null)
{
model.Buy_Name = row["Buy_Name"].ToString();
}
if (row["Buy_AccountCode"] != null)
{
model.Buy_AccountCode = row["Buy_AccountCode"].ToString();
}
if (row["Buy_AccountName"] != null)
{
model.Buy_AccountName = row["Buy_AccountName"].ToString();
}
if (row["Buy_Date"] != null && row["Buy_Date"].ToString() != "")
{
model.Buy_Date = DateTime.Parse(row["Buy_Date"].ToString());
}
if (row["Buy_AmountPay"] != null)
{
model.Buy_AmountPay = row["Buy_AmountPay"].ToString();
}
if (row["Buy_AccountPaid"] != null)
{
model.Buy_AccountPaid = row["Buy_AccountPaid"].ToString();
}
if (row["Buy_moneyOwed"] != null)
{
model.Buy_moneyOwed = row["Buy_moneyOwed"].ToString();
}
if (row["Buy_SalesMan"] != null)
{
model.Buy_SalesMan = row["Buy_SalesMan"].ToString();
}
if (row["Buy_SalesCode"] != null)
{
model.Buy_SalesCode = row["Buy_SalesCode"].ToString();
}
if (row["Buy_AuditMan"] != null)
{
model.Buy_AuditMan = row["Buy_AuditMan"].ToString();
}
if (row["Buy_Premoney"] != null)
{
model.Buy_Premoney = row["Buy_Premoney"].ToString();
}
if (row["Buy_Actmoney"] != null)
{
model.Buy_Actmoney = row["Buy_Actmoney"].ToString();
}
if (row["Buy_Zhuangtai"] != null && row["Buy_Zhuangtai"].ToString() != "")
{
model.Buy_Zhuangtai = int.Parse(row["Buy_Zhuangtai"].ToString());
}
if (row["Buy_Remark"] != null)
{
model.Buy_Remark = row["Buy_Remark"].ToString();
}
if (row["Buy_Satetyone"] != null)
{
model.Buy_Satetyone = row["Buy_Satetyone"].ToString();
}
if (row["Buy_Satetytwo"] != null)
{
model.Buy_Satetytwo = row["Buy_Satetytwo"].ToString();
}
if (row["Buy_Clear"] != null && row["Buy_Clear"].ToString() != "")
{
model.Buy_Clear = int.Parse(row["Buy_Clear"].ToString());
}
if (row["Buy_States"] != null && row["Buy_States"].ToString() != "")
{
model.Buy_States = int.Parse(row["Buy_States"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BuyPayment model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_BuyPayment set ");
strSql.Append("Buy_Code=@Buy_Code,");
strSql.Append("Buy_SuCode=@Buy_SuCode,");
strSql.Append("Buy_SuName=@Buy_SuName,");
strSql.Append("Buy_BCode=@Buy_BCode,");
strSql.Append("Buy_Name=@Buy_Name,");
strSql.Append("Buy_AccountCode=@Buy_AccountCode,");
strSql.Append("Buy_AccountName=@Buy_AccountName,");
strSql.Append("Buy_Date=@Buy_Date,");
strSql.Append("Buy_AmountPay=@Buy_AmountPay,");
strSql.Append("Buy_AccountPaid=@Buy_AccountPaid,");
strSql.Append("Buy_moneyOwed=@Buy_moneyOwed,");
strSql.Append("Buy_SalesMan=@Buy_SalesMan,");
strSql.Append("Buy_SalesCode=@Buy_SalesCode,");
strSql.Append("Buy_AuditMan=@Buy_AuditMan,");
strSql.Append("Buy_Premoney=@Buy_Premoney,");
strSql.Append("Buy_Actmoney=@Buy_Actmoney,");
strSql.Append("Buy_Zhuangtai=@Buy_Zhuangtai,");
strSql.Append("Buy_Remark=@Buy_Remark,");
strSql.Append("Buy_Satetyone=@Buy_Satetyone,");
strSql.Append("Buy_Satetytwo=@Buy_Satetytwo,");
strSql.Append("Buy_Clear=@Buy_Clear,");
strSql.Append("Buy_States=@Buy_States");
strSql.Append(" where Buy_ID=@Buy_ID");
SqlParameter[] parameters =
{
new SqlParameter("@Buy_Code", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_SuCode", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_SuName", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_BCode", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_Name", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_AccountCode", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_AccountName", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_Date", SqlDbType.DateTime),
new SqlParameter("@Buy_AmountPay", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_AccountPaid", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_moneyOwed", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_SalesMan", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_SalesCode", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_AuditMan", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_Premoney", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_Actmoney", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_Zhuangtai", SqlDbType.Money, 8),
new SqlParameter("@Buy_Remark", SqlDbType.NVarChar, 1024),
new SqlParameter("@Buy_Satetyone", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_Satetytwo", SqlDbType.NVarChar, 512),
new SqlParameter("@Buy_Clear", SqlDbType.Int, 4),
new SqlParameter("@Buy_States", SqlDbType.Int, 4),
new SqlParameter("@Buy_ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.Buy_Code;
parameters[1].Value = model.Buy_SuCode;
parameters[2].Value = model.Buy_SuName;
parameters[3].Value = model.Buy_BCode;
parameters[4].Value = model.Buy_Name;
parameters[5].Value = model.Buy_AccountCode;
parameters[6].Value = model.Buy_AccountName;
parameters[7].Value = model.Buy_Date;
parameters[8].Value = model.Buy_AmountPay;
parameters[9].Value = model.Buy_AccountPaid;
parameters[10].Value = model.Buy_moneyOwed;
parameters[11].Value = model.Buy_SalesMan;
parameters[12].Value = model.Buy_SalesCode;
parameters[13].Value = model.Buy_AuditMan;
parameters[14].Value = model.Buy_Premoney;
parameters[15].Value = model.Buy_Actmoney;
parameters[16].Value = model.Buy_Zhuangtai;
parameters[17].Value = model.Buy_Remark;
parameters[18].Value = model.Buy_Satetyone;
parameters[19].Value = model.Buy_Satetytwo;
parameters[20].Value = model.Buy_Clear;
parameters[21].Value = model.Buy_States;
parameters[22].Value = model.Buy_ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
