/// <summary>
/// LHA增加一条记录
/// </summary>
/// <param name="_modelOne"></param>
/// <param name="strSql"></param>
/// <returns></returns>
public string InsertLHA(barCodeEntity.JSKLHA _modelOne, StringBuilder strSql)
{
strSql = new StringBuilder( );
strSql.Append("INSERT INTO JSKLHA (");
strSql.Append("LHA001,LHA002,LHA003,LHA004,LHA012)");
strSql.Append(" VALUES (");
strSql.AppendFormat("'{0}','{1}','{2}','{3}','{4}')", _modelOne.LHA001, _modelOne.LHA002, _modelOne.LHA003, _modelOne.LHA004, _modelOne.LHA012);
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);
}
}
