/// <summary> /// 批量删除 /// </summary> /// <param name="cklst"></param> /// <returns></returns> public ActionResult DelByIDs(int[] cklst) { if (cklst == null || cklst.Length <= 0) { return(Content("请勾选你要删除的维修信息")); } string rtn = C_UserAdvice1.DelByIDs(cklst); return(Content(rtn)); }
public ActionResult CustomerPieCensus2() { string value = C_UserAdvice1.GetPieC_UserCountCensus(); if (string.IsNullOrWhiteSpace(value)) { return(Json("", JsonRequestBehavior.AllowGet)); } return(Json(value, JsonRequestBehavior.AllowGet)); }
//public static string AuditByIDtuihuan() //{ //public ActionResult AuditByIDtuihuan(ScaleOutStokeShow condition) // { // string sql = "select Product.ProductName ProductName,count(SN) sl from C_UserAdvice left join ScaleOutStoke on ScaleOutStoke.SmallCode=C_UserAdvice.SN left join Product on ScaleOutStoke.P_ID=Product.ProductNumber where C_UserAdvice.state2='已审核' AND ScaleOutStoke.Consignee='"+CurrentUser.UserName+"' and C_UserAdvice.OrderNo is NULL group by ProductName "; // System.Data.SqlClient.SqlParameter[] paramters1 = null; // List<C_UserAdvice> c_UserAdvice = EntityDataHelper.FillData2Entities<C_UserAdvice>(sql, paramters1); // string ordero = DateTime.Now.ToString("yyyymmddss"); // string strSql = string.Format("update C_UserAdvice set OrderNo='" + ordero + "' where SN in (select smallcode from ScaleOutStoke where Consignee='" + CurrentUser.UserName + "');"); // System.Data.SqlClient.SqlParameter[] paramters = { new System.Data.SqlClient.SqlParameter("@DatCreate", DateTime.Now.ToString()) }; // int cnt = DAL.SqlHelper.ExecuteNonQuery(strSql, paramters); // if (cnt > 0) // { // return "ok"; // } // else // { // return "审核失败"; // } //} /// <summary> /// 批量审核 /// </summary> /// <param name="cklst"></param> /// <returns></returns> public ActionResult AuditByIDs(int[] cklst) { if (cklst == null || cklst.Length <= 0) { return(Content("请勾选你要审核的人")); } string rtn = C_UserAdvice1.AuditByIDs(cklst); return(Content(rtn)); }