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