public static string DeleteTemplate(string type)
{
string res = LeaveStockInfoSrv.DeleteTemplate(type);
SqlExceRes sqlRes = new SqlExceRes(res);
return(sqlRes.GetResultString("删除成功！", ""));
}
public static DataSet GetInfos(DateTime start, DateTime end, string type)
{
DataSet ds = LeaveStockInfoSrv.GetInfos(start, end, type);
DataTable dt = ds.Tables[0];
DataSet dsRes = new DataSet();
dsRes.Tables.Add(dt.Copy());
dsRes.Tables.Add(GetDatagridFooter(dt));
return(dsRes);
}
public static Dictionary <string, string> GetFormDetail(string type)
{
Dictionary <string, string> dict = new Dictionary <string, string>();
DataSet ds = LeaveStockInfoSrv.GetFormDetail(type);
dict.Add("type", type);
if (ds != null)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
dict.Add(row["field"].ToString(), row["alias"].ToString());
}
}
return(dict);
}
public static DataSet GetTemplateInfo()
{
DataSet ds = LeaveStockInfoSrv.GetTemplateInfo();
if (ds != null)
{
//删掉Id和type字段
for (int i = ds.Tables[0].Rows.Count - 1; i >= 0; i--)
{
DataRow row = ds.Tables[0].Rows[i];
if (row["field"].ToString().Contains("Id") || row["field"].ToString().Contains("type"))
{
ds.Tables[0].Rows.Remove(row);
}
}
}
return(ds);
}
public static Dictionary <string, string> GetTemplate(string type)
{
DataSet ds = LeaveStockInfoSrv.GetFormDetail(type);
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
return(null);
}
Dictionary <string, string> dict = new Dictionary <string, string>();
foreach (DataRow row in ds.Tables[0].Rows)
{
if (!string.IsNullOrEmpty(row["alias"].ToString()))
{
dict.Add(row["field"].ToString(), row["alias"].ToString());
}
}
return(dict);
}
public static string UpdateTemplate(ArrayList list, string type)
{
string res = "";
string[] res1 = LeaveStockInfoSrv.UpdateTemplate(list, type).Split(';');
for (int i = 0; i < list.Count; i++)
{
SqlExceRes sqlRes = new SqlExceRes(res1[i]);
if (sqlRes.Result == SqlExceRes.ResState.Error)
{
res += sqlRes.ExceMsg;
}
}
if (string.IsNullOrEmpty(res))
{
return("提交成功！");
}
else
{
return(res);
}
}
public static Dictionary <string, string> ImportInfos(Dictionary <string, string> dict, string type)
{
string res = "";
if (string.IsNullOrEmpty(type))
{
res = "数据类型为空，请选择正确的数据类型！";
}
else
{
DataSet ds = LeaveStockInfoSrv.GetFormDetail(type);
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
res = "数据类型无数据！";
}
else
{
bool needToImport = true;
Dictionary <string, string> newDict = new Dictionary <string, string>();
foreach (DataRow field in ds.Tables[0].Rows)
{
string alias = field["alias"].ToString();
if (string.IsNullOrEmpty(alias))
{
continue;
}
else if (alias == "进发生数&出发生数")//针对“实发数量”字段的进发生数&出发生数的特殊情况做的处理
{
string number = "";
if (dict["单据类型"].ToString().Contains("退"))//退货类型
{
number = "-" + dict["进发生数"].ToString();
}
else if (dict["单据类型"].ToString() == "采购")//采购类型，直接忽略
{
needToImport = false;
res = "非销售数据无需导入";
break;
}
else//正常销售类型
{
number = dict["出发生数"].ToString();
}
newDict.Add(field["field"].ToString(), number);
}
else if (alias.IndexOf("DirectStorage") == 0)//列名以“DirectStorage”开头的直接存储别名
{
string val = alias.Substring("DirectStorage".Length);
newDict.Add(field["field"].ToString(), val);
}
else if (!dict.Keys.Contains(alias))//列名不存在说明数据类型不对
{
res = "导入文件数据类型与所选择的不符，请选择正确的数据类型！";
needToImport = false;
break;
}
else if (field["field"].ToString() == "date" || field["field"].ToString() == "dateValidity")
{
DateTime date = new DateTime(1900, 1, 1);
if (StringTools.IsInt(dict[alias].ToString()))
{
date = date.AddDays(Convert.ToInt32(dict[alias].ToString()));
}
else
{
date = Convert.ToDateTime(dict[alias].ToString());
}
newDict.Add(field["field"].ToString(), date.ToString("yyyy-MM-dd"));
}
else
{
newDict.Add(field["field"].ToString(), dict[alias].ToString());
}
}
if (needToImport)
{
newDict.Add("type", type);
res = LeaveStockInfoSrv.ImportInfos(newDict, type);
}
}
}
if (!string.IsNullOrEmpty(res))
{
if (res.Contains("操作成功"))
{
dict["状态"] = "已导入";
}
else
{
dict["状态"] = res;
}
}
return(dict);
}
public static string DeleteData(string id)
{
return(LeaveStockInfoSrv.DeleteData(id));
}
public static DataSet CheckInfo(string type)
{
return(LeaveStockInfoSrv.CheckInfo(type));
}
public static DataSet GetDatalistInfo()
{
return(LeaveStockInfoSrv.GetDatalistInfo());
}
public static string InsertInfos(ref DataTable dt, string type)
{
if (string.IsNullOrEmpty(type))
{
return("error:数据类型为空，请选择正确的数据类型！");
}
DataSet ds = LeaveStockInfoSrv.GetFormDetail(type);
//补齐空缺的或省略的cell，第一行为空除外
dt = FillBlankCell(dt, null);
ArrayList list = new ArrayList();
foreach (DataRow row in dt.Rows)
{
Dictionary <string, string> dict = new Dictionary <string, string>();
dict.Add("type", type);
bool DocumentTypeIsPurchase = false;
foreach (DataRow field in ds.Tables[0].Rows)
{
string alias = field["alias"].ToString();
if (string.IsNullOrEmpty(alias))
{
continue;
}
else if (alias == "进发生数&出发生数")//针对“实发数量”字段的进发生数&出发生数的特殊情况做的处理
{
string number = "";
if (row["单据类型"].ToString().Contains("退"))//退货类型
{
number = "-" + row["进发生数"].ToString();
}
else if (row["单据类型"].ToString() == "采购")//采购类型，直接忽略
{
DocumentTypeIsPurchase = true;
break;
}
else//正常销售类型
{
number = row["出发生数"].ToString();
}
dict.Add(field["field"].ToString(), number);
}
else if (alias.IndexOf("DirectStorage") == 0)//列名以“DirectStorage”开头的直接存储别名
{
string val = alias.Substring("DirectStorage".Length);
dict.Add(field["field"].ToString(), val);
}
else if (!dt.Columns.Contains(alias))//列名不存在说明数据类型不对
{
return("error:导入文件数据类型与所选择的不符，请选择正确的数据类型！");
}
else if (field["field"].ToString() == "date" || field["field"].ToString() == "dateValidity")
{
DateTime date = Convert.ToDateTime(row[alias].ToString());
dict.Add(field["field"].ToString(), date.ToString("yyyy-MM-dd"));
}
else
{
dict.Add(field["field"].ToString(), row[alias].ToString());
}
}
if (DocumentTypeIsPurchase)//采购类型，直接忽略
{
continue;
}
list.Add(dict);
}
string[] res = LeaveStockInfoSrv.InsertInfos(list).Split(';');
dt.Columns.Add("状态");
dt.Columns["状态"].SetOrdinal(0);//调整到第一列
for (int i = 0; i < dt.Rows.Count; i++)
{
SqlExceRes sqlRes = new SqlExceRes(res[i]);
if (sqlRes.Result == SqlExceRes.ResState.Success)
{
dt.Rows[i]["状态"] = "已导入";
}
else if (sqlRes.Result == SqlExceRes.ResState.Repetition)
{
dt.Rows[i]["状态"] = "有重复";
}
else
{
dt.Rows[i]["状态"] = sqlRes.ExceMsg;
}
}
return("插入成功！");
}