/// <summary>
/// DEH是否存在
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
bool ExistsDEH(barCodeEntity.TPADEH _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.AppendFormat("SELECT COUNT(1) FROM TPADEH WHERE DEH001='{0}' AND DEH002='{1}'", _model.Dhe001, _model.Dhe002);
return(SqlHelper.Exists(strSql.ToString( )));
}
/// <summary>
/// DEH编辑一条记录
/// </summary>
/// <param name="_model"></param>
/// <param name="strSql"></param>
/// <returns></returns>
public string UpdateDEH(barCodeEntity.TPADEH _model, StringBuilder strSql)
{
strSql = new StringBuilder( );
strSql.Append("UPDATE TPADEH SET ");
strSql.Append("DEH004=CONVERT(varchar(100), GETDATE(), 112),");
strSql.Append("DEH005=CONVERT(varchar(100), GETDATE(), 112) ");
strSql.AppendFormat("WHERE DEH001='{0}' AND DEH002='{1}'", _model.Dhe001, _model.Dhe002);
return(strSql.ToString( ));
}
/// <summary>
/// DEH增加一条记录
/// </summary>
/// <param name="_model"></param>
/// <param name="strSql"></param>
/// <returns></returns>
public string InsertDEH(barCodeEntity.TPADEH _model, StringBuilder strSql)
{
strSql = new StringBuilder( );
strSql.Append("INSERT INTO TPADEH (");
strSql.Append("DEH001,DEH002,DEH003,DEH004,DEH005) ");
strSql.Append("VALUES (");
strSql.AppendFormat("'{0}','{1}','{2}',CONVERT(varchar(100), GETDATE(), 112),CONVERT(varchar(100), GETDATE(), 112)) ", _model.Dhe001, _model.Dhe002, _model.Dhe003);
return(strSql.ToString( ));
}
/// <summary>
/// 生成入库记录
/// </summary>
/// <param name="idxList"></param>
/// <param name="documentType"></param>
/// <returns></returns>
public bool InsertToLibrary(List <int> idxList, string rklx, DataTable table)
{
if (idxList.Count < 1)
{
return(false);
}
StringBuilder strSql = new StringBuilder( );
ArrayList SQLString = new ArrayList( );
DataTable dt = LibraryDa(idxList, strSql);
if (dt != null && dt.Rows.Count > 0)
{
barCodeEntity.JSKLHA _modelOne = new barCodeEntity.JSKLHA( );
barCodeEntity.JSKLHB _modelTwo = new barCodeEntity.JSKLHB( );
barCodeEntity.barCodeReportEntity _modelTre = new barCodeEntity.barCodeReportEntity( );
barCodeEntity.TPADEH _modelDHE = new barCodeEntity.TPADEH( );
_modelTre.BAR019 = 0;
_modelOne.LHA002 = "条码";
_modelOne.LHA004 = rklx;
_modelOne.LHA001 = _modelTwo.LHB001 = _modelTre.BAR011 = LibraryOrderOddNum( );
_modelOne.LHA003 = DateTime.Now.ToString("yyyyMMdd");
_modelOne.LHA012 = "F";
SQLString.Add(InsertLHA(_modelOne, strSql));
List <string> strList = new List <string> ( );
for (int i = 0; i < dt.Rows.Count; i++)
{
if (strList.Count < 1)
{
_modelTwo.LHB002 = "001";
}
else
{
_modelTwo.LHB002 = maxStrList(strList).ToString( );
if (Convert.ToInt32(_modelTwo.LHB002) < 9)
{
_modelTwo.LHB002 = "00" + (Convert.ToInt32(_modelTwo.LHB002) + 1).ToString( );
}
else if (Convert.ToInt32(_modelTwo.LHB002) >= 9 && Convert.ToInt32(_modelTwo.LHB002) < 99)
{
_modelTwo.LHB002 = "0" + (Convert.ToInt32(_modelTwo.LHB002) + 1).ToString( );
}
else
{
_modelTwo.LHB002 = (Convert.ToInt32(_modelTwo.LHB002) + 1).ToString( );
}
}
strList.Add(_modelTwo.LHB002);
_modelTre.BAR008 = dt.Rows [i] ["BAR008"].ToString( );
if (table.Select("BAR008='" + _modelTre.BAR008 + "'").Length > 0)
{
_modelTre.BAR019 = Convert.ToInt32(table.Select("BAR008='" + _modelTre.BAR008 + "'") [0] ["BAR023"].ToString( ));
}
_modelTre.BAR023 = 0;
SQLString.Add(EditBAR(_modelTre, strSql));
_modelTwo.LHB003 = _modelDHE.Dhe001 = dt.Rows [i] ["BAR001"].ToString( );
_modelTwo.LHB004 = dt.Rows [i] ["BAR002"].ToString( );
_modelTwo.LHB005 = dt.Rows [i] ["DEA003"].ToString( );
_modelTwo.LHB006 = dt.Rows [i] ["DDA001"].ToString( );
_modelTwo.LHB007 = 1;
_modelTwo.LHB008 = /*string . IsNullOrEmpty ( dt . Rows [ i ] [ "COUN" ] . ToString ( ) ) == true ? 0 : Convert . ToInt32 ( dt . Rows [ i ] [ "COUN" ] . ToString ( ) );*/ _modelTre.BAR019;
_modelTwo.LHB011 = "F";
_modelTwo.LHB019 = _modelDHE.Dhe002 = dt.Rows [i] ["BAR007"].ToString( );
_modelTwo.LHB020 = 1;
_modelTwo.LHB021 = 1;
_modelTwo.LHB022 = dt.Rows [i] ["DEA003"].ToString( );
_modelTwo.LHB023 = _modelTwo.LHB008;
_modelTwo.LHB024 = dt.Rows [i] ["BAR004"].ToString( );
_modelTwo.LHB960 = dt.Rows [i] ["BAR007"].ToString( );
_modelTwo.LHB980 = Math.Round(acreage(dt.Rows [i] ["DEA057"].ToString( )) * _modelTwo.LHB008, 2);
_modelTwo.LHB961 = dt.Rows [i] ["DEA961"].ToString( );
_modelDHE.Dhe003 = dt.Rows [i] ["BAR025"].ToString( );
SQLString.Add(InsertLHB(_modelTwo, strSql));
if (ExistsDEH(_modelDHE))
{
SQLString.Add(UpdateDEH(_modelDHE, strSql));
}
else
{
SQLString.Add(InsertDEH(_modelDHE, strSql));
}
}
//if ( !string . IsNullOrEmpty ( _modelOne . LHA001 ) )
//{
// SQLString . Add ( EditBAR ( _modelTre ,strSql ,idxList ) );
//}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
else
{
return(false);
}
}
