/// <summary>
/// 登记到账
/// </summary>
/// <param name="en">实体</param>
/// <returns></returns>
public int add(CustomerPay en)
{
string strSql = "insert into CustomerPay (contractID, orderID, money, date, backHandler) values (@contractID, @orderID, @money, @date, @back)";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@contractID", en.contractID),
new SqlParameter("@orderID", en.orderID),
new SqlParameter("@money", en.money),
new SqlParameter("@date", en.date),
new SqlParameter("@back", en.backHandler)
};
int result = SqlHelper.ExecuteNonQuery(BaseHelper.DBConnStr, CommandType.Text, strSql, param);
return result;
}
public JsonResult CPay_add(string id, string money, string date)
{
CustomerPay en = new CustomerPay();
en.contractID = id;
en.money = Convert.ToDouble(money);
en.date = Convert.ToDateTime(date);
DaCustomerPay dal = new DaCustomerPay();
var result = new CustomJsonResult();
result.Data = dal.add(en);
return result;
}
