/// <summary>
/// 得到一个对象实体
/// </summary>
public MobileSoft.Model.Charge.Tb_Charge_Receipt GetModel(string ReceiptCode)
{
SqlParameter[] parameters =
{
new SqlParameter("@ReceiptCode", SqlDbType.VarChar, 50)
};
parameters[0].Value = ReceiptCode;
MobileSoft.Model.Charge.Tb_Charge_Receipt model = new MobileSoft.Model.Charge.Tb_Charge_Receipt();
DataSet ds = DbHelperSQL.RunProcedure("Proc_Tb_Charge_Receipt_GetModel", parameters, "ds");
if (ds.Tables[0].Rows.Count > 0)
{
model.ReceiptCode = ds.Tables[0].Rows[0]["ReceiptCode"].ToString();
if (ds.Tables[0].Rows[0]["BussId"].ToString() != "")
{
model.BussId = long.Parse(ds.Tables[0].Rows[0]["BussId"].ToString());
}
if (ds.Tables[0].Rows[0]["OrderId"].ToString() != "")
{
model.OrderId = ds.Tables[0].Rows[0]["OrderId"].ToString();
}
model.ReceiptSign = ds.Tables[0].Rows[0]["ReceiptSign"].ToString();
if (ds.Tables[0].Rows[0]["Receivables"].ToString() != "")
{
model.Receivables = decimal.Parse(ds.Tables[0].Rows[0]["Receivables"].ToString());
}
model.Method = ds.Tables[0].Rows[0]["Method"].ToString();
model.CardNum = ds.Tables[0].Rows[0]["CardNum"].ToString();
model.MemberCardCode = ds.Tables[0].Rows[0]["MemberCardCode"].ToString();
model.CustCode = ds.Tables[0].Rows[0]["CustCode"].ToString();
if (ds.Tables[0].Rows[0]["Balance"].ToString() != "")
{
model.Balance = decimal.Parse(ds.Tables[0].Rows[0]["Balance"].ToString());
}
if (ds.Tables[0].Rows[0]["Discount"].ToString() != "")
{
model.Discount = decimal.Parse(ds.Tables[0].Rows[0]["Discount"].ToString());
}
if (ds.Tables[0].Rows[0]["Amount"].ToString() != "")
{
model.Amount = decimal.Parse(ds.Tables[0].Rows[0]["Amount"].ToString());
}
model.ReceiptMemo = ds.Tables[0].Rows[0]["ReceiptMemo"].ToString();
model.ReceiptType = ds.Tables[0].Rows[0]["ReceiptType"].ToString();
if (ds.Tables[0].Rows[0]["ReceiptDate"].ToString() != "")
{
model.ReceiptDate = DateTime.Parse(ds.Tables[0].Rows[0]["ReceiptDate"].ToString());
}
if (ds.Tables[0].Rows[0]["IsDelete"].ToString() != "")
{
model.IsDelete = int.Parse(ds.Tables[0].Rows[0]["IsDelete"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(MobileSoft.Model.Charge.Tb_Charge_Receipt model)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@ReceiptCode", SqlDbType.VarChar, 36),
new SqlParameter("@BussId", SqlDbType.BigInt, 8),
new SqlParameter("@OrderId", SqlDbType.VarChar, 36),
new SqlParameter("@ReceiptSign", SqlDbType.VarChar, 36),
new SqlParameter("@Receivables", SqlDbType.Decimal, 9),
new SqlParameter("@Method", SqlDbType.VarChar, 12),
new SqlParameter("@CardNum", SqlDbType.VarChar, 36),
new SqlParameter("@MemberCardCode", SqlDbType.VarChar, 36),
new SqlParameter("@CustCode", SqlDbType.VarChar, 36),
new SqlParameter("@Balance", SqlDbType.Decimal, 9),
new SqlParameter("@Discount", SqlDbType.Decimal, 9),
new SqlParameter("@Amount", SqlDbType.Decimal, 9),
new SqlParameter("@ReceiptMemo", SqlDbType.VarChar, 1000),
new SqlParameter("@ReceiptType", SqlDbType.VarChar, 30),
new SqlParameter("@ReceiptDate", SqlDbType.DateTime),
new SqlParameter("@IsDelete", SqlDbType.Int, 4)
};
parameters[0].Value = model.ReceiptCode;
parameters[1].Value = model.BussId;
parameters[2].Value = model.OrderId;
parameters[3].Value = model.ReceiptSign;
parameters[4].Value = model.Receivables;
parameters[5].Value = model.Method;
parameters[6].Value = model.CardNum;
parameters[7].Value = model.MemberCardCode;
parameters[8].Value = model.CustCode;
parameters[9].Value = model.Balance;
parameters[10].Value = model.Discount;
parameters[11].Value = model.Amount;
parameters[12].Value = model.ReceiptMemo;
parameters[13].Value = model.ReceiptType;
parameters[14].Value = model.ReceiptDate;
parameters[15].Value = model.IsDelete;
DbHelperSQL.RunProcedure("Proc_Tb_Charge_Receipt_Update", parameters, out rowsAffected);
}
