private string getCommonPurchaseData() { string date = Request.Form["date"]; DataTable dt = ImportPurchaseManage.findByMonth(date); if (dt == null) { return(null); } return(JsonHelper.DataTable2Json(dt)); }
private string InsertOrUpdateCommonPurchaseData() { string data = Request.Form["dataJson"]; List <Dictionary <string, string> > dictList = JsonHelper.DeserializeJsonToObject <List <Dictionary <string, string> > >(data); string year = Request.Form["year"]; string month = Request.Form["month"]; string msg = ImportPurchaseManage.insertOrUpdateCommonPurchaseData(dictList, year, month); // 保存到日志表中 UserInfo user = (UserInfo)Session["user"]; ImportPurchaseManage.saveRecord(dictList, user.userName); JObject jObject = new JObject(); jObject.Add("msg", msg); return(jObject.ToString()); }
private string getMonthReport() { string date = Request.Form["dateString"]; string sort = Request.Form["sort"]; string order = Request.Form["order"]; DataTable dt = ImportPurchaseManage.findByMonth(date); string json = ""; if (dt != null) { dt = PinYinHelper.SortByPinYin(dt, sort, order); json = JsonHelper.DataTable2Json(dt); } return(json); }
private string Import() { string res = "F"; string json = Request.Form["json"]; string type = Request.Form["type"]; Dictionary <string, string> dict = JsonHelper.DeserializeJsonToObject <Dictionary <string, string> >(json); if (!dict["状态"].Contains("已导入")) { dict = ImportPurchaseManage.ImportInfos(dict, type); } if (dict != null) { res = JsonHelper.SerializeObject(dict); } return(res); }