public static DataTable findByDate(string date, string style) { DataSet ds = ExportSalesSrv.findByDate(date, style); if (ds == null) { return(null); } return(ds.Tables[0]); }
public static DataTable findByMonth(string date, string style) { string firstWeekFirstDay = date + "-1"; int day = GetWeekNum(firstWeekFirstDay); string firstWeekLastDay = date + "-" + (8 - day); string firstWeekCond = "between '" + firstWeekFirstDay + "' and '" + firstWeekLastDay + "'"; string secondWeekFirstDay = date + "-" + (9 - day); string secondWeekLastDay = date + "-" + (15 - day); string secondWeekCond = "between '" + secondWeekFirstDay + "' and '" + secondWeekLastDay + "'"; string thirdWeekFirstDay = date + "-" + (16 - day); string thirdWeekLastDay = date + "-" + (22 - day); string thirdWeekCond = "between '" + thirdWeekFirstDay + "' and '" + thirdWeekLastDay + "'"; string fourthWeekFirstDay = date + "-" + (23 - day); string fourthWeekLastDay = date + "-" + (29 - day); string fourthWeekCond = "between '" + fourthWeekFirstDay + "' and '" + fourthWeekLastDay + "'"; int lastDay = DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month); string fifthWeekFirstDay = ""; string fifthWeekLastDay = ""; string fifthWeekCond = "between '0000-00-01' and '0000-00-01'"; if ((29 - day) < lastDay) { fifthWeekFirstDay = date + "-" + (30 - day); fifthWeekLastDay = date + "-" + lastDay; fifthWeekCond = "between '" + fifthWeekFirstDay + "' and '" + fifthWeekLastDay + "'"; } string monthFirstDay = date + "-1"; string monthLastDay = date + "-" + lastDay; DataSet ds = ExportSalesSrv.findByMonth(firstWeekCond, secondWeekCond, thirdWeekCond, fourthWeekCond, fifthWeekCond, monthFirstDay, monthLastDay, style); if (ds == null) { return(null); } return(ds.Tables[0]); }
public static Dictionary <string, string> ImportInfos(Dictionary <string, string> dict, string type) { string code = ""; string date = ""; string salesNumber = ""; string docNo = ""; string batchNo = ""; string clientCode = ""; string hospitalCode = ""; string style = ""; if ("jd".Equals(type)) { style = "xs"; code = dict["产品代码"].ToString(); date = dict["日期"].ToString(); if (dict.ContainsKey("实发数量")) { salesNumber = dict["实发数量"].ToString(); } else { salesNumber = dict["数量"].ToString(); } docNo = dict["单据编号"].ToString(); if (dict.ContainsKey("批号")) { batchNo = dict["批号"].ToString(); } if (dict.ContainsKey("结算单位代码")) { hospitalCode = dict["结算单位代码"].ToString(); } else { hospitalCode = dict["客户代码"].ToString(); } if (!"Y".Equals(dict["审核标志"].ToString())) { dict["状态"] = "该单据未过账"; return(dict); } } else { code = dict["器械代码"].ToString(); date = dict["日期"].ToString(); salesNumber = dict["基本数量"].ToString(); docNo = dict["单号"].ToString(); clientCode = dict["客户代码"].ToString(); if (dict.ContainsKey("终端客户代码")) { hospitalCode = dict["终端客户代码"].ToString(); style = "xs"; } else { style = "db"; } if (dict.ContainsKey("批号/序列号")) { batchNo = dict["批号/序列号"].ToString(); } if (dict.ContainsKey("过帐") && "".Equals(dict["过帐"].ToString())) { dict["状态"] = "该单据未过账"; return(dict); } } if (docNo == null || "".Equals(docNo) || date == null || "".Equals(date) || code == null || "".Equals(code)) { dict["状态"] = "存在空值"; return(dict); } DataSet ds = ExportSalesSrv.findDuplicate(docNo, batchNo, code, date); if (ds != null && ds.Tables[0].Rows.Count > 0) { dict["状态"] = "单据重复"; return(dict); } Dictionary <string, string> resultDict = new Dictionary <string, string>(); resultDict.Add("code", code); resultDict.Add("date", date); resultDict.Add("salesNumber", salesNumber); resultDict.Add("docno", docNo); resultDict.Add("batchNo", batchNo); resultDict.Add("clientCode", clientCode); resultDict.Add("hospitalCode", hospitalCode); resultDict.Add("style", style); if ("jd".Equals(type)) { resultDict.Add("type", "jd"); } else if ("jb".Equals(type)) { resultDict.Add("type", "jb"); } string res = ExportSalesSrv.ImportInfos(resultDict); if (!string.IsNullOrEmpty(res)) { if (res.Contains("操作成功")) { dict["状态"] = "已导入"; } else { dict["状态"] = res; } } return(dict); }