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);
}
