public ActionResult Sign_Edit(f_sign model) { string sql = string.Format("update f_sign t set poorid={0},name='{1}',time='{2}',datestart='{3}',dateend='{4}',weight={5},price={6} where t.id={7}", model.poorid, model.name, model.time, model.datestart, model.dateend, model.weight, model.price, model.id); int count = DbHelperMySQL.ExecuteSql(sql); return(Json(Result.AutoResult(count), JsonRequestBehavior.AllowGet)); }
public ActionResult Sign_Add(f_sign model) { string sql = string.Format("insert into f_sign(poorid,name,number,time,datestart,dateend,weight,price,del) values({0},'{1}','{2}','{3}','{4}','{5}',{6},{7},0)", model.poorid, model.name, model.number, model.time, model.datestart, model.dateend, model.weight, model.price); int count = DbHelperMySQL.ExecuteSql(sql); return(Json(Result.AutoResult(count), JsonRequestBehavior.AllowGet)); }