/// <summary> /// 删除对象 /// </summary> /// <param name="en">对象</param> /// <returns></returns> public int delete(MakeCostTarget en) { string strSql = "delete from MakeCostTarget where id=@id"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@id", en.id) }; int result = SqlHelper.ExecuteNonQuery(BaseHelper.DBConnStr, CommandType.Text, strSql, param); return result; }
/// <summary> /// 添加对象 /// </summary> /// <param name="en">对象</param> /// <returns></returns> public int add(MakeCostTarget en) { string strSql = "insert into MakeCostTarget (target, memo) values (@target, @memo)"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@target", en.target), new SqlParameter("@memo", en.memo) }; int result = SqlHelper.ExecuteNonQuery(BaseHelper.DBConnStr, CommandType.Text, strSql, param); return result; }
/// <summary> /// 修改对象 /// </summary> /// <param name="en">对象</param> /// <returns></returns> public int update(MakeCostTarget en) { string strSql = "update MakeCostTarget set target=@target, memo=@memo where id=@id"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@id", en.id), new SqlParameter("@target", en.target), new SqlParameter("@memo", en.memo) }; int result = SqlHelper.ExecuteNonQuery(BaseHelper.DBConnStr, CommandType.Text, strSql, param); return result; }
/// <summary> /// 删除制作费结算对象 /// </summary> /// <param name="id"></param> /// <returns></returns> public JsonResult MakeCost_remove(string id) { MakeCostTarget en = new MakeCostTarget(); en.id = Convert.ToInt32(id); DaMakeCostTarget dal = new DaMakeCostTarget(); var result = new CustomJsonResult(); result.Data = dal.delete(en); return result; }
public JsonResult MakeCost_edit(string id, string name, string memo) { MakeCostTarget en = new MakeCostTarget(); en.id = Convert.ToInt32(id); en.target = name; en.memo = memo; DaMakeCostTarget dal = new DaMakeCostTarget(); var result = new CustomJsonResult(); result.Data = dal.update(en); return result; }
public JsonResult MakeCost_add(string name, string memo) { MakeCostTarget en = new MakeCostTarget(); en.target = name; en.memo = memo; DaMakeCostTarget dal = new DaMakeCostTarget(); var result = new CustomJsonResult(); result.Data = dal.add(en); return result; }