/// <summary> /// 添加结算 /// </summary> /// <param name="en">结算实体</param> /// <returns></returns> public int add(MakeCostAccount en) { string strSql = "insert into MakeCostAccount (orderID, money, state, date, memo) values (@orderID, @money, @state, @date, @memo)"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@orderID", en.orderID), new SqlParameter("@money", en.money), new SqlParameter("@state", en.state), new SqlParameter("@date", en.date), new SqlParameter("@memo", en.memo) }; int result = SqlHelper.ExecuteNonQuery(BaseHelper.DBConnStr, CommandType.Text, strSql, param); return result; }
public JsonResult MakeCostAccount_add(string id, string money, string state, string date) { MakeCostAccount en = new MakeCostAccount(); en.orderID = id; en.money = Convert.ToDouble(money); en.state = Convert.ToInt32(state); en.date = Convert.ToDateTime(date); DaMakeCostAccount dal = new DaMakeCostAccount(); var result = new CustomJsonResult(); result.Data = dal.add(en); return result; }