/// <summary>
/// 出库
/// </summary>
/// <param name="da"></param>
/// <param name="state"></param>
/// <returns></returns>
public bool signOfStorage(DataTable da, string orderType, string personNum)
{
if (da != null && da.Rows.Count > 0)
{
ArrayList SQLString = new ArrayList();
StringBuilder strSql = new StringBuilder();
SmartDeviceProjectEntity.HDTBAR _model = new SmartDeviceProjectEntity.HDTBAR();
//13 样品 14 返工类别 --其它出库
if (orderType == "13" || orderType == "14")
{
SmartDeviceProjectEntity.JSKLIA _modelTre = new SmartDeviceProjectEntity.JSKLIA();
SmartDeviceProjectEntity.JSKLIB _modelFor = new SmartDeviceProjectEntity.JSKLIB();
LIALIB(da, SQLString, strSql, _modelTre, _modelFor, personNum, orderType, _model);
}
//15 销货
else if (orderType == "15")
{
SmartDeviceProjectEntity.JSKKEA _modelOne = new SmartDeviceProjectEntity.JSKKEA();
SmartDeviceProjectEntity.JSKKEB _modelTwo = new SmartDeviceProjectEntity.JSKKEB();
KEAKEB(da, SQLString, strSql, _modelOne, _modelTwo, personNum, orderType, _model);
}
else
{
return(false);
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
else
{
return(false);
}
}
/// <summary>
/// 编辑条码记录表状态
/// </summary>
/// <param name="SQLString"></param>
/// <param name="strSql"></param>
/// <returns></returns>
string EditHDTBAR(StringBuilder strSql, SmartDeviceProjectEntity.HDTBAR _model)
{
strSql = new StringBuilder();
strSql.Append("UPDATE HDTBAR SET ");
strSql.Append("BAR013='T',");
strSql.Append("BAR016='F',");
strSql.AppendFormat("BAR010='{0}',", _model.BAR010);
strSql.AppendFormat("BAR009='{0}',", _model.BAR009);
strSql.AppendFormat("BAR015='{0}',", DateTime.Now);
strSql.AppendFormat("BAR020='{0}'", _model.BAR020);
strSql.AppendFormat(" WHERE BAR008='{0}'", _model.BAR008);
return(strSql.ToString());
}
void KEAKEB(DataTable dt, ArrayList SQLString, StringBuilder strSql, SmartDeviceProjectEntity.JSKKEA _modelOne, SmartDeviceProjectEntity.JSKKEB _modelTwo, string personNum, string orderType, SmartDeviceProjectEntity.HDTBAR _model)
{
try
{
SQLString.Clear();
DataTable da, de; int num = 0;
List <string> strCount = new List <string>(); List <string> strList = new List <string>();
for (int i = 0; i < dt.Rows.Count; i++)
{
num = 0;
_model.BAR009 = dt.Rows[i]["IBB001"].ToString().Trim();
if (i == 0)
{
strCount.Add(_model.BAR009);
_modelOne.KEA001 = _model.BAR010 = storageOfOddNum();
}
else
{
if (!strCount.Contains(_model.BAR009))
{
_modelOne.KEA001 = _model.BAR010 = (Convert.ToInt64(_modelOne.KEA001) + 1).ToString();
strCount.Add(_model.BAR009);
}
}
_model.BAR008 = dt.Rows[i]["BAR008"].ToString();
_model.BAR020 = string.IsNullOrEmpty(dt.Rows[i]["BAR020"].ToString()) == true ? 0 : Convert.ToInt32(dt.Rows[i]["BAR020"].ToString());
num = _model.BAR020;
_model.BAR020 += getCkNum(_model.BAR008);
_modelOne.KEA002 = "条码";
_modelOne.KEA003 = DateTime.Now.ToString("yyyyMMdd");
da = GetDataTableJSKKEA(_model.BAR009);
if (da != null && da.Rows.Count > 0)
{
_modelOne.KEA004 = da.Rows[0]["IBA004"].ToString();
_modelOne.KEA005 = da.Rows[0]["DFA001"].ToString();
_modelOne.KEA006 = "";
_modelOne.KEA007 = da.Rows[0]["IBA006"].ToString();
_modelOne.KEA008 = "RMB";
_modelOne.KEA040 = "F";
}
else
{
_modelOne.KEA004 = string.Empty;
_modelOne.KEA005 = string.Empty;
_modelOne.KEA006 = string.Empty;
_modelOne.KEA007 = string.Empty;
_modelOne.KEA008 = string.Empty;
_modelOne.KEA040 = string.Empty;
}
string str = InsertJSKKEA(_modelOne, strSql);
if (SQLString.Count < 1)
{
SQLString.Add(str);
}
else
{
if (!SQLString.Contains(str))
{
SQLString.Add(str);
}
}
str = "";
str = EditHDTBAR(strSql, _model);
if (SQLString.Count < 1)
{
SQLString.Add(str);
}
else
{
if (!SQLString.Contains(str))
{
SQLString.Add(str);
}
}
_modelTwo.KEB001 = _modelOne.KEA001;
de = GetDataTableJSKKEB(_model.BAR009, _model.BAR008);
if (de != null && de.Rows.Count > 0)
{
for (int k = 0; k < de.Rows.Count; k++)
{
if (strList.Count < 1)
{
_modelTwo.KEB002 = "001";
}
else
{
_modelTwo.KEB002 = maxStrList(strList).ToString();
if (Convert.ToInt32(_modelTwo.KEB002) < 9)
{
_modelTwo.KEB002 = "00" + (Convert.ToInt32(_modelTwo.KEB002) + 1).ToString();
}
else if (Convert.ToInt32(_modelTwo.KEB002) >= 9 && Convert.ToInt32(_modelTwo.KEB002) < 99)
{
_modelTwo.KEB002 = "0" + (Convert.ToInt32(_modelTwo.KEB002) + 1).ToString();
}
else
{
_modelTwo.KEB002 = (Convert.ToInt32(_modelTwo.KEB002) + 1).ToString();
}
}
strList.Add(_modelTwo.KEB002);
_modelTwo.KEB003 = de.Rows[k]["IBB003"].ToString();
_modelTwo.KEB004 = de.Rows[k]["IBB004"].ToString();
_modelTwo.KEB005 = de.Rows[k]["IBB005"].ToString();
_modelTwo.KEB006 = de.Rows[k]["DEA008"].ToString();
//_modelTwo.KEB007 = string.IsNullOrEmpty(de.Rows[k]["IBB006"].ToString()) == true ? 0 : Convert.ToDecimal(de.Rows[k]["IBB006"].ToString());
_modelTwo.KEB037 = _modelTwo.KEB007 = num;
_modelTwo.KEB009 = string.IsNullOrEmpty(de.Rows[k]["IBB008"].ToString()) == true ? 0 : Convert.ToDecimal(de.Rows[k]["IBB008"].ToString());
_modelTwo.KEB010 = string.IsNullOrEmpty(de.Rows[k]["IBB009"].ToString()) == true ? 0 : Convert.ToDecimal(de.Rows[k]["IBB009"].ToString());
_modelTwo.KEB011 = string.IsNullOrEmpty(de.Rows[k]["IBB010"].ToString()) == true ? 0 : Convert.ToDecimal(de.Rows[k]["IBB010"].ToString());
_modelTwo.KEB012 = string.IsNullOrEmpty(de.Rows[k]["IBB011"].ToString()) == true ? 0 : Convert.ToDecimal(de.Rows[k]["IBB011"].ToString());
_modelTwo.KEB013 = de.Rows[k]["IBB012"].ToString();
_modelTwo.KEB015 = "32";
_modelTwo.KEB016 = dt.Rows[i]["IBB001"].ToString();
_modelTwo.KEB017 = de.Rows[k]["IBB002"].ToString();
_modelTwo.KEB019 = string.IsNullOrEmpty(de.Rows[k]["IBB021"].ToString()) == true ? 0 : Convert.ToDecimal(de.Rows[k]["IBB021"].ToString());
_modelTwo.KEB020 = string.IsNullOrEmpty(de.Rows[k]["IBB022"].ToString()) == true ? 0 : Convert.ToDecimal(de.Rows[k]["IBB022"].ToString());
_modelTwo.KEB021 = "F";
_modelTwo.KEB029 = string.IsNullOrEmpty(de.Rows[k]["IBB031"].ToString()) == true ? 0 : Convert.ToDecimal(de.Rows[k]["IBB031"].ToString());
_modelTwo.KEB030 = string.IsNullOrEmpty(de.Rows[k]["IBB032"].ToString()) == true ? 0 : Convert.ToDecimal(de.Rows[k]["IBB032"].ToString());
_modelTwo.KEB031 = string.IsNullOrEmpty(de.Rows[k]["IBB033"].ToString()) == true ? 0 : Convert.ToDecimal(de.Rows[k]["IBB033"].ToString());
_modelTwo.KEB034 = 1;
_modelTwo.KEB035 = 1;
_modelTwo.KEB036 = de.Rows[k]["IBB038"].ToString();
//_modelTwo.KEB037 = string.IsNullOrEmpty(de.Rows[k]["IBB039"].ToString()) == true ? 0 : Convert.ToDecimal(de.Rows[k]["IBB039"].ToString());
_modelTwo.KEB039 = string.IsNullOrEmpty(de.Rows[k]["IBB040"].ToString()) == true ? 0 : Convert.ToDecimal(de.Rows[k]["IBB040"].ToString());
_modelTwo.KEB040 = de.Rows[k]["IBB041"].ToString();
_modelTwo.KEB041 = de.Rows[k]["BAR007"].ToString();
_modelTwo.KEB960 = de.Rows[k]["BAR007"].ToString();
_modelTwo.KEB980 = Math.Round(acreage(de.Rows[k]["DEA057"].ToString()) * _modelTwo.KEB007, 2);
_modelTwo.KEB961 = de.Rows[k]["DEA961"].ToString();
str = "";
str = IsertJSKKEB(_modelTwo, strSql);
if (SQLString.Count < 1)
{
SQLString.Add(str);
}
else
{
if (!SQLString.Contains(str))
{
SQLString.Add(str);
}
}
}
}
else
{
if (strList.Count < 1)
{
_modelTwo.KEB002 = "001";
}
else
{
_modelTwo.KEB002 = maxStrList(strList).ToString();
if (Convert.ToInt32(_modelTwo.KEB002) < 9)
{
_modelTwo.KEB002 = "00" + (Convert.ToInt32(_modelTwo.KEB002) + 1).ToString();
}
else if (Convert.ToInt32(_modelTwo.KEB002) >= 9 && Convert.ToInt32(_modelTwo.KEB002) < 99)
{
_modelTwo.KEB002 = "0" + (Convert.ToInt32(_modelTwo.KEB002) + 1).ToString();
}
else
{
_modelTwo.KEB002 = (Convert.ToInt32(_modelTwo.KEB002) + 1).ToString();
}
}
strList.Add(_modelTwo.KEB002);
_modelTwo.KEB003 = string.Empty;
_modelTwo.KEB004 = string.Empty;
_modelTwo.KEB005 = string.Empty;
_modelTwo.KEB006 = string.Empty;
_modelTwo.KEB007 = 0;
_modelTwo.KEB009 = 0;
_modelTwo.KEB010 = 0;
_modelTwo.KEB011 = 0;
_modelTwo.KEB012 = 0;
_modelTwo.KEB013 = string.Empty;
_modelTwo.KEB015 = "32";
_modelTwo.KEB016 = string.Empty;
_modelTwo.KEB017 = string.Empty;
_modelTwo.KEB019 = 0;
_modelTwo.KEB020 = 0;
_modelTwo.KEB021 = "F";
_modelTwo.KEB029 = 0;
_modelTwo.KEB030 = 0;
_modelTwo.KEB031 = 0;
_modelTwo.KEB034 = 1;
_modelTwo.KEB035 = 1;
_modelTwo.KEB036 = string.Empty;
_modelTwo.KEB037 = 0;
_modelTwo.KEB039 = 0;
_modelTwo.KEB040 = string.Empty;
_modelTwo.KEB960 = string.Empty;
_modelTwo.KEB980 = 0;
_modelTwo.KEB961 = string.Empty;
str = "";
str = IsertJSKKEB(_modelTwo, strSql);
if (SQLString.Count < 1)
{
SQLString.Add(str);
}
else
{
if (!SQLString.Contains(str))
{
SQLString.Add(str);
}
}
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message + "\n\r" + ex.StackTrace);
}
}
void LIALIB(DataTable dt, ArrayList SQLString, StringBuilder strSql, SmartDeviceProjectEntity.JSKLIA _modelTre, SmartDeviceProjectEntity.JSKLIB _modelFor, string personNum, string orderType, SmartDeviceProjectEntity.HDTBAR _model)
{
SQLString.Clear();
_modelTre.LIA001 = _model.BAR010 = storageOfOddNumJSKLIA();
_modelTre.LIA002 = "条码";
_modelTre.LIA003 = DateTime.Now.ToString("yyyyMMdd");
_modelTre.LIA004 = orderType;
_modelTre.LIA005 = personNum;
_modelTre.LIA012 = "F";
DataTable da = GetDataTableJSKLIA(personNum);
if (da != null && da.Rows.Count > 0)
{
_modelTre.LIA016 = da.Rows[0]["DBA005"].ToString();
}
else
{
_modelTre.LIA016 = string.Empty;
}
SQLString.Add(IsertJSKLIA(_modelTre, strSql));
_modelFor.LIB001 = _modelTre.LIA001;
List <string> strList = new List <string>();
for (int i = 0; i < dt.Rows.Count; i++)
{
_model.BAR009 = dt.Rows[i]["IBB001"].ToString();
_model.BAR008 = dt.Rows[i]["BAR008"].ToString();
_model.BAR020 = string.IsNullOrEmpty(dt.Rows[i]["BAR020"].ToString()) == true ? 0 : Convert.ToInt32(dt.Rows[i]["BAR020"].ToString());
_model.BAR020 += getCkNum(_model.BAR008);
SQLString.Add(EditHDTBAR(strSql, _model));
}
string[] fileNames = { "BAR001", "BAR007" };
DataTable ds = distinct(dt, fileNames);
for (int k = 0; k < ds.Rows.Count; k++)
{
_modelFor.LIB003 = ds.Rows[k]["BAR001"].ToString();
//if (!string.IsNullOrEmpty(dt.Select("BAR001='" + _modelFor.LIB003 + "'").Length.ToString()))
// _modelFor.LIB008 = dt.Select("BAR001='" + _modelFor.LIB003 + "'").Length;
//else
// _modelFor.LIB008 = 0;
_modelFor.LIB008 = string.IsNullOrEmpty(dt.Rows[k]["BAR020"].ToString()) == true ? 0 : Convert.ToInt32(dt.Rows[k]["BAR020"].ToString());
if (strList.Count < 1)
{
_modelFor.LIB002 = "001";
}
else
{
_modelFor.LIB002 = maxStrList(strList).ToString();
if (Convert.ToInt32(_modelFor.LIB002) < 9)
{
_modelFor.LIB002 = "00" + (Convert.ToInt32(_modelFor.LIB002) + 1).ToString();
}
else if (Convert.ToInt32(_modelFor.LIB002) >= 9 && Convert.ToInt32(_modelFor.LIB002) < 99)
{
_modelFor.LIB002 = "0" + (Convert.ToInt32(_modelFor.LIB002) + 1).ToString();
}
else
{
_modelFor.LIB002 = (Convert.ToInt32(_modelFor.LIB002) + 1).ToString();
}
}
strList.Add(_modelFor.LIB002);
DataTable de = GetDataTableJSKLIB(_modelFor.LIB003);
if (de != null && de.Rows.Count > 0)
{
_modelFor.LIB004 = de.Rows[0]["DEA002"].ToString();
_modelFor.LIB005 = de.Rows[0]["DEA003"].ToString();
_modelFor.LIB006 = de.Rows[0]["DEA008"].ToString();
_modelFor.LIB024 = de.Rows[0]["DEA057"].ToString();
_modelFor.LIB960 = de.Rows[0]["BAR007"].ToString();
_modelFor.LIB980 = Math.Round(acreage(de.Rows[0]["DEA057"].ToString()) * _modelFor.LIB008, 2);
_modelFor.LIB961 = de.Rows[0]["DEA961"].ToString();
_modelFor.LIB019 = de.Rows[0]["BAR007"].ToString();
//_modelFor.LIB008 = string.IsNullOrEmpty(de.Rows[0]["COUN"].ToString()) == true ? 0 : Convert.ToInt32(de.Rows[0]["COUN"].ToString());
}
else
{
_modelFor.LIB004 = string.Empty;
_modelFor.LIB005 = string.Empty;
_modelFor.LIB006 = string.Empty;
_modelFor.LIB024 = string.Empty;
_modelFor.LIB960 = string.Empty;
_modelFor.LIB980 = 0;
_modelFor.LIB961 = string.Empty;
_modelFor.LIB019 = string.Empty;
//_modelFor.LIB008 = 0;
}
_modelFor.LIB007 = -1;
_modelFor.LIB011 = "F";
_modelFor.LIB020 = 1;
_modelFor.LIB021 = 1;
_modelFor.LIB022 = _modelFor.LIB005;
_modelFor.LIB023 = _modelFor.LIB008;
SQLString.Add(IsertJSKLIB(_modelFor, strSql));
}
}
