private String saveNetSalesNumOfReportSales()
{
String hospital = Request.Form["group"];
String product = Request.Form["item"];
String netSalesNum = Request.Form["netSales"];
String docCode = Request.Form["docCode"];
String time = Request.Form["time"];
UserInfo user = (UserInfo)Session["user"];
String sales = user.userName;
if (!StringTools.IsNumeric(docCode))
{
return(docCode);
}
Dictionary <string, string> dict = NetSalesInfoManage.SaveNetSales(hospital, product, sales, netSalesNum, docCode, time);
String result = dict["returnMsg"];
docCode = dict["docCode"];
if (result == "success")
{
return(docCode);
}
else
{
return(result);
}
}
private string getFlowNumOfReportSales()
{
string hospital = Request.Form["group"];
string product = Request.Form["item"];
UserInfo user = (UserInfo)Session["user"];
string res = NetSalesInfoManage.getFlowNumOfReportSales(hospital, product, user.userName);
String res1 = NetSalesInfoManage.getNetSalesNum(hospital, product, user.userName);
Dictionary <string, string> dict = new Dictionary <string, string>();
if (StringTools.IsInt(res))//返回流向数值
{
dict.Add("FlowNum", res);
dict.Add("errorMsg", "success");
}
else//返回错误信息
{
dict.Add("FlowNum", "0");
dict.Add("errorMsg", res);
}
// 返回保存的纯销数据
if (StringTools.IsInt(res1))
{
dict.Add("netSalesNum", res1);
}
else//返回错误信息
{
dict.Add("netSalesNum", "0");
}
return(JsonHelper.SerializeObject(dict));
}
private string getDatalist()
{
string res = "";
UserInfo user = (UserInfo)Session["user"];
DataTable dt = NetSalesInfoManage.getInfos(user.userId.ToString());
if (dt != null)
{
dt = PinYinHelper.SortByPinYin(dt, "Hospital", "asc");
ArrayList list = new ArrayList();
foreach (DataRow row in dt.Rows)
{
Dictionary <string, string> dict = new Dictionary <string, string>();
dict.Add("group", row["Hospital"].ToString());
dict.Add("item", row["Product"].ToString());
dict.Add("id", row["Id"].ToString());
dict.Add("status", row["State"].ToString());
dict.Add("docCode", row["DocCode"].ToString());
dict.Add("time", row["CorrespondingTime"].ToString());
list.Add(dict);
}
res = JsonHelper.SerializeObject(list);
}
return(res);
}
/*加载数据列表*/
private String getDataList()
{
UserInfo user = (UserInfo)Session["user"];
String type = Request.Params["type"];
DataTable dt = null;
String res = "";
// 查询我提交的
if ("mine".Equals(type))
{
dt = NetSalesApprovalInfoManage.getListOfCommitBySelf(user.userName);
}
else // 查询待我审批的
{
dt = NetSalesApprovalInfoManage.getListOfCommitByOthers(user.userId.ToString());
}
if (dt != null)
{
dt = PinYinHelper.SortByPinYin(dt, "Hospital", "asc");
ArrayList list = new ArrayList();
foreach (DataRow row in dt.Rows)
{
Dictionary <string, string> dict = new Dictionary <string, string>();
dict.Add("group", row["Hospital"].ToString());
dict.Add("item", row["Product"].ToString());
dict.Add("NetSalesNum", row["NetSalesNumber"].ToString());
dict.Add("sales", user.userName);
// 查询流向数据
string flowNumStr = NetSalesInfoManage.getFlowNumOfReportSales(row["Hospital"].ToString(),
row["Product"].ToString(), user.userName);
if (StringTools.IsInt(flowNumStr))
{
dict.Add("flowNum", flowNumStr);
}
else//返回错误信息
{
dict.Add("flowNum", "0");
}
list.Add(dict);
}
res = JsonHelper.SerializeObject(list);
}
return(res);
}
// 加载子表格数据
private String getSubDataList()
{
String hospital = Request.Params["hospital"];
String product = Request.Params["product"];
UserInfo user = (UserInfo)Session["user"];
String type = Request.Params["type"];
DataTable dt = NetSalesApprovalInfoManage.getSubDataList(hospital, product, user.userName, user.userId.ToString(), type);
String res = "";
if (dt != null)
{
ArrayList list = new ArrayList();
foreach (DataRow row in dt.Rows)
{
Dictionary <string, string> dict = new Dictionary <string, string>();
dict.Add("docCode", row["DocCode"].ToString());
dict.Add("createTime", row["CreateTime"].ToString());
dict.Add("sales", row["Sales"].ToString());
dict.Add("state", row["State"].ToString());
dict.Add("netSalesNum", row["NetSalesNumber"].ToString());
dict.Add("hospital", row["Hospital"].ToString());
dict.Add("product", row["Product"].ToString());
// 查询流向数据
string flowNumStr = NetSalesInfoManage.getFlowNumOfReportSales(row["Hospital"].ToString(),
row["Product"].ToString(), user.userName);
if (StringTools.IsInt(flowNumStr))
{
dict.Add("flowNum", flowNumStr);
}
else//返回错误信息
{
dict.Add("flowNum", "0");
}
list.Add(dict);
}
res = JsonHelper.SerializeObject(list);
}
return(res);
}
