public JsonResult ADCost_add(string name, string memo) { ADCostTarget en = new ADCostTarget(); en.target = name; en.memo = memo; DaADCostTarget dal = new DaADCostTarget(); var result = new CustomJsonResult(); result.Data = dal.add(en); return result; }
public JsonResult ADCost_edit(string id, string name, string memo) { ADCostTarget en = new ADCostTarget(); en.id = Convert.ToInt32(id); en.target = name; en.memo = memo; DaADCostTarget dal = new DaADCostTarget(); var result = new CustomJsonResult(); result.Data = dal.update(en); return result; }
/// <summary> /// 删除广告费结算对象 /// </summary> /// <param name="id"></param> /// <returns></returns> public JsonResult ADCost_remove(string id) { ADCostTarget en = new ADCostTarget(); en.id = Convert.ToInt32(id); DaADCostTarget dal = new DaADCostTarget(); var result = new CustomJsonResult(); result.Data = dal.delete(en); return(result); }
/// <summary> /// 删除对象 /// </summary> /// <param name="en">对象</param> /// <returns></returns> public int delete(ADCostTarget en) { string strSql = "delete from ADCostTarget 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 delete(ADCostTarget en) { string strSql = "delete from ADCostTarget where id=@id"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@id", en.id) }; int result = SqlHelper.ExecuteNonQuery(BaseHelper.DBConnStr, CommandType.Text, strSql, param); return(result); }
public JsonResult ADCost_add(string name, string memo) { ADCostTarget en = new ADCostTarget(); en.target = name; en.memo = memo; DaADCostTarget dal = new DaADCostTarget(); var result = new CustomJsonResult(); result.Data = dal.add(en); return(result); }
/// <summary> /// 添加对象 /// </summary> /// <param name="en">对象</param> /// <returns></returns> public int add(ADCostTarget en) { string strSql = "insert into ADCostTarget (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 add(ADCostTarget en) { string strSql = "insert into ADCostTarget (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); }
public JsonResult ADCost_edit(string id, string name, string memo) { ADCostTarget en = new ADCostTarget(); en.id = Convert.ToInt32(id); en.target = name; en.memo = memo; DaADCostTarget dal = new DaADCostTarget(); var result = new CustomJsonResult(); result.Data = dal.update(en); return(result); }
/// <summary> /// 修改对象 /// </summary> /// <param name="en">对象</param> /// <returns></returns> public int update(ADCostTarget en) { string strSql = "update ADCostTarget 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="en">对象</param> /// <returns></returns> public int update(ADCostTarget en) { string strSql = "update ADCostTarget 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 ADCost_remove(string id) { ADCostTarget en = new ADCostTarget(); en.id = Convert.ToInt32(id); DaADCostTarget dal = new DaADCostTarget(); var result = new CustomJsonResult(); result.Data = dal.delete(en); return result; }