/// <summary>
/// 将字符串转换成byte[]数组,再依仕样指定长度截取值
/// </summary>
/// <param name="IfType"></param>
/// <param name="seq"></param>
/// <param name="aRecord"></param>
/// <param name="FileEncoding"></param>
public IF_PROD_PLAN SetRecordValues(string IfType, int seq, string[] arrayRecord, Encoding FileEncoding)
{
ComLibrary com = new ComLibrary();
// 数据截取及默认数据的取得
IF_PROD_PLAN ifpp = new IF_PROD_PLAN();
//ifpp.IF_DATE = _if_date; //データ連携日
//ifpp.IF_HMS = _if_hms; // 連携データ区分
ifpp.IF_TYPE = _if_type; //連携データ区分
ifpp.IF_DATA_SEQ = seq; //データ順番
ifpp.IF_PLAN_NO = string.Empty; //取込計画№
ifpp.ITEM_NO = ToDBC(arrayRecord.Length > 0 ? arrayRecord[0] : "").Trim(); //品目コード
//ifpp.ITEM_DESC = ToDBC(arrayRecord.Length > 1 ? arrayRecord[1] : "").Trim(); //品目名称
//ifpp.WS_CD = ""; //作業区コード
//ifpp.PLAN_YM = com.StringToInt(arrayRecord.Length > 2 ? arrayRecord[2].Replace("/", "") : "0"); //計画年月
//ifpp.ORDER_QTY = com.StringToDouble(arrayRecord.Length > 3 ? arrayRecord[3] : "0"); //計画数量
//ifpp.IF_DATA_FLAG = 0; //取込結果区分
return(ifpp);
}
/// <summary>
/// 指定目录下所有[CSV]类型文件导入DataTable
/// XML方式一次性导入
/// </summary>
/// <returns></returns>
public int ImpFilesToDataTableBulk()
{
int rtn = 0;
ComLibrary com = new ComLibrary();
try
{
string strFileNm = "";
string[] strWk = _file_path.Split('\\');
strFileNm = strWk[strWk.Length - 1];
string strFileNmA = "";
string[] strWkA = strFileNm.Split('.');
strFileNmA = strWkA[0];
bool isEmpty = true;
int LineCnt = 0;
string IfType = _if_type;//連携データ区分
StringBuilder strXML = new StringBuilder();
strXML.Append("<IFRows>");
Boolean err_flag = false;
//if (_save_path != "")
//{
// if (_save_path.EndsWith("\\"))
// _save_file = _save_path + DateTime.Now.ToString("yyyyMMdd_HHmmss") + "_" + strFileNm;
// else
// _save_file = _save_path + "\\" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + "_" + strFileNm;
//}
// LOG FILE 名 2014.09.22
//if (_log_path != "")
//{
// if (_log_path.EndsWith("\\"))
// _log_file = _log_path + DateTime.Now.ToString("yyyyMMdd_HHmmss") + "_" + strFileNm;
// else
// _log_file = _log_path + "\\" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + "_" + strFileNm;
//}
// FILE COPY 2014.09.22
//if (_save_path != "")
//{
// File.Copy(_file_path, _save_file, true);
//}
Encoding FileEncoding = GetFileEncoding(_file_path);
// 最初にメモリに読むこむ
int wLineCnt = 0;
StreamReader sr = new StreamReader(_file_path, FileEncoding);
while (sr.Peek() >= 0)
{
wLineCnt++;
string strRecord = sr.ReadLine();
FileInfoClass fi = new FileInfoClass();
fi.LineCnt = wLineCnt;
fi.Data = strRecord;
lstFileInfo.Add(fi);
}
sr.Dispose();
sr.Close();
TextFieldParser parser = new TextFieldParser(_file_path, FileEncoding);
using (parser)
{
parser.TextFieldType = FieldType.Delimited;
parser.SetDelimiters(","); // 区切り文字はコンマ
while (!parser.EndOfData)
{
err_flag = false;
LineCnt++;
isEmpty = false;
string[] strRecord = parser.ReadFields(); // 1行読み込み 2014.09.22
string aRecord = "";
for (int p = 0; p < strRecord.Length; p++)
{
if (p > 0)
{
aRecord += "|";
}
aRecord += strRecord[p];
}
if (LineCnt <= lstFileInfo.Count)
{
((FileInfoClass)lstFileInfo[LineCnt - 1]).CnvData = aRecord;
}
//各項目属性ﾁｪｯｸ
//年月, 数量
//if (!com.IsNumeric(strRecord[2].Replace("/", "")) || !com.IsNumeric(strRecord[3]))
//{
// err_flag = true;
// // 2014.10.10
// if (LineCnt <= lstFileInfo.Count)
// {
// ((FileInfoClass)lstFileInfo[LineCnt - 1]).ErrFlag = 1;
// ((FileInfoClass)lstFileInfo[LineCnt - 1]).ErrMsg = "数値エラー。";
// }
//}
//数据各项值取得
IF_PROD_PLAN ifpl = SetRecordValues(IfType, LineCnt, strRecord, FileEncoding);
//if (ifpl.ITEM_NO.ToString().Length > 30
//|| ifpl.ITEM_DESC.ToString().Length > 50
//|| ifpl.PLAN_YM.ToString().Length > 6
//|| com.StringToDouble(ifpl.ORDER_QTY.ToString()) > 1000000000)
//{
// err_flag = true;
// if (LineCnt <= lstFileInfo.Count)
// {
// ((FileInfoClass)lstFileInfo[LineCnt - 1]).ErrFlag = 1;
// ((FileInfoClass)lstFileInfo[LineCnt - 1]).ErrMsg += "桁数エラー。";
// }
//}
if (err_flag) // 2014.10.10
{
//_len_err_cnt++;
////IF 取込データログに登録
//Poif poif = new Poif(_chg_user_id, _lang);
//Message msg = new Message(_chg_user_id, _lang);
//poif.if_date = ifpl.IF_DATE;
//poif.if_hms = ifpl.IF_HMS;
//poif.if_type = ifpl.IF_TYPE;
//poif.if_type_name = _if_type_name;
//poif.if_data_seq = ifpl.IF_DATA_SEQ;
//poif.if_data = aRecord;
//poif.if_data_err = msg.GetMessage("COLUMN_LENGTH_FORMAT_ERR");
//poif.if_data_flag = 2;
//poif.chg_pgm = _chg_pgm;
//poif.chg_user_id = _chg_user_id;
//poif.lang = _lang;
//poif.errcode = _errcode;
//poif.errmsg = _errmsg;
//poif.sqlcode = _sqlcode;
//poif.dbmsg = _dbmsg;
//rtn = poif.Ins_IF_IN_LOG();
//if (rtn == ComConst.FAILED)
//{
// goto RESULT;
//}
}
if (!err_flag) // 2014.09.22
{
//XML格式作成
strXML.Append("<IFRow ");
//strXML.Append(" IF_DATE=\"" + ifpl.IF_DATE.ToString() + "\"");
//strXML.Append(" IF_HMS=\"" + ifpl.IF_HMS.ToString() + "\"");
strXML.Append(" IF_TYPE=\"" + ifpl.IF_TYPE + "\"");
strXML.Append(" IF_DATA_SEQ=\"" + ifpl.IF_DATA_SEQ.ToString() + "\"");
strXML.Append(" IF_PLAN_NO=\"" + ifpl.IF_PLAN_NO + "\"");
strXML.Append(" ITEM_NO=\"" + ifpl.ITEM_NO + "\"");
//strXML.Append(" ITEM_DESC=\"" + com.XMLString(ifpl.ITEM_DESC) + "\"");
//strXML.Append(" WS_CD=\"" + ifpl.WS_CD + "\"");
//strXML.Append(" PLAN_YM=\"" + ifpl.PLAN_YM.ToString() + "\"");
//strXML.Append(" ORDER_QTY=\"" + ifpl.ORDER_QTY.ToString() + "\"");
//strXML.Append(" IF_DATA_FLAG=\"" + ifpl.IF_DATA_FLAG.ToString() + "\"");
//strXML.Append(" CHG_PGM=\"" + _chg_pgm + "\"");
strXML.Append(" CHG_USER_ID=\"" + _chg_user_id + "\"");
strXML.Append(" />");
}
}
}
strXML.Append("</IFRows>");
//_file_line_cnt = LineCnt;
if (isEmpty)
{
Message msg = new Message(_chg_user_id, _lang);
_strErr = msg.GetMessage("FILE_NOT_EXIST_ERR");
rtn = ComConst.CHECK_ERROR;
goto RESULT;
}
else
{
// [IF初期取込生産計画]の一括登録
#region : [IF初期取込生産計画]の一括登録
ComDB db = new ComDB(_db_type);
db.DbParametersClear();
db.DbPsetInt("rtn", rtn, ComConst.DB_RTN);
db.DbPsetXml("@I_XML", strXML.ToString(), strXML.ToString().Length, ComConst.DB_IN);
db.DbPsetInt("@I_LANG", _lang, ComConst.DB_IN);
db.DbPsetInt("@O_ERRCODE", _errcode, ComConst.DB_OUT);
db.DbPsetString("@O_MSG", _errmsg, ComConst.DB_OUT);
db.DbPsetInt("@O_SQLCODE", _sqlcode, ComConst.DB_OUT);
db.DbPsetString("@O_SQLMSG", _dbmsg, ComConst.DB_OUT);
db.DbPsetString("@O_PROC_NAME", _proc_name, ComConst.DB_OUT);
db.DbBeginTrans();
rtn = db.DbStored("SP_IF_PROD_PLAN_BULK_IMP");//一括登録
if (rtn == ComConst.SUCCEED)
{
db.DbCommit();
}
else
{
db.DbRollback();
rtn = db.DbPgetInt("rtn");
if (rtn > 0)
{
_errcode = db.DbPgetInt("@O_ERRCODE");
_errmsg = db.DbPgetString("@O_MSG");
_sqlcode = db.DbPgetInt("@O_SQLCODE");
_dbmsg = db.DbPgetString("@O_SQLMSG");
_proc_name = db.DbPgetString("@O_PROC_NAME");
_strErr = _errcode + ":" + _errmsg + "[" + _sqlcode + ":" + _dbmsg + "(" + _proc_name + ")]";
}
else
{
_strErr = db.strErr;
}
rtn = ComConst.FAILED;
}
#endregion
}
//File.Delete(_file_path);
}
catch (Exception ex)
{
_strErr = ex.ToString();
rtn = ComConst.FAILED;
}
RESULT:
return(rtn);
}
/// <summary>
/// 仕入先一覧の取得
///
/// 使用画面：MstVendorMnt, SrchVendor
/// </summary>
public DataSet GetVendorList()
{
ComDB db = new ComDB(_db_type);
ComLibrary comlibrary = new ComLibrary();
StringBuilder strSQL = new StringBuilder();
DataSet ds = new DataSet();
//--- sql
//-->ADD BY UBIQ-SUO 2010/09/25
strSQL.Append("SELECT COUNT(*) ");
//strSQL.Append("VENDOR_CD, BEG_EFF_DATE, END_EFF_DATE, PO_STOP_FLAG, ");
//strSQL.Append("VENDOR_NAME, VENDOR_DESC, VENDOR_NAME2, VENDOR_DESC2, ");
//strSQL.Append("COUNTRY_CD, FOREIGN_FLAG, CUR_CD, SUPPLY_WHS, ");
//strSQL.Append("BOND_SUPPLY_WHS, PO_SLIPLESS_FLAG, PO_SLIP_TYPE, FCST_FLAG, ");
//strSQL.Append("PAY_TERMS, VENDOR_ATTN, TELNO, FAXNO, ");
//strSQL.Append("ZIP_CD, STATE, ADDRESS1, ADDRESS2, ");
//strSQL.Append("ADDRESS2, ADDRESS4, STATE2, ADDRESS2_1, ");
//strSQL.Append("ADDRESS2_2, ADDRESS2_3, ADDRESS2_4, ");
//strSQL.Append("DATA_CHAR1, DATA_CHAR2, ");
//strSQL.Append("DATA_CHAR3, DATA_CHAR4, DATA_CHAR5, DATA_CHAR6, ");
//strSQL.Append("DATA_CHAR7, DATA_CHAR8, DATA_CHAR9, DATA_CHAR10, ");
//strSQL.Append("DATA_NUM1, DATA_NUM2, DATA_NUM3, DATA_NUM4, ");
//strSQL.Append("DATA_NUM5, DATA_NUM6, DATA_NUM7, DATA_NUM8, ");
//strSQL.Append("DATA_NUM9, DATA_NUM10, DATA_FLAG1, DATA_FLAG2, ");
//strSQL.Append("DATA_FLAG3, DATA_FLAG4, DATA_FLAG5, DATA_FLAG6, ");
//strSQL.Append("DATA_FLAG7, DATA_FLAG8, DATA_FLAG9, DATA_FLAG10, ");
//strSQL.Append("ENTRY_DATE, CHG_DATE, CHG_PGM, CHG_USERID, ");
//strSQL.Append("UPDATE_CNTR ");
strSQL.Append(" FROM VENDOR_MASTER ");
if (_vendor_cd != "" || _vendor_name != "")
{
strSQL.Append(" WHERE ");
if (_vendor_cd != "")
{
strSQL.Append(" VENDOR_CD LIKE '" + _vendor_cd + "%'");
if (_vendor_name != "")
{
strSQL.Append(" AND ");
}
}
if (_vendor_name != "")
{
strSQL.Append(" VENDOR_NAME LIKE '%" + _vendor_name + "%'");
}
}
//strSQL.Append(" ORDER BY VENDOR_CD");
db.DbParametersClear();
try
{
ds = db.DbDataSet(strSQL.ToString(), "TABLE");
if (ds == null)
{
_dbmsg = db.expmsg;
_strErr = db.strErr;
return(null);
}
//if (db.State() == ConnectionState.Open)
// db.DbClose();
if (comlibrary.StringToInt(ds.Tables[0].Rows[0][0].ToString()) > 2000)
{
_range = true;
}
else
{
_range = false;
}
}
catch
{
_dbmsg = db.expmsg;
_strErr = db.strErr;
if (db.State() == ConnectionState.Open)
{
db.DbClose();
}
return(null);
}
strSQL = new StringBuilder();
//<--ADD BY UBIQ-SUO 2010/09/25
strSQL.Append("SELECT TOP 2000 ");
strSQL.Append("VENDOR_CD, BEG_EFF_DATE, END_EFF_DATE, PO_STOP_FLAG, ");
strSQL.Append("VENDOR_NAME, VENDOR_DESC, VENDOR_NAME2, VENDOR_DESC2, ");
strSQL.Append("COUNTRY_CD, FOREIGN_FLAG, CUR_CD, SUPPLY_WHS, ");
strSQL.Append("BOND_SUPPLY_WHS, PO_SLIPLESS_FLAG, PO_SLIP_TYPE, FCST_FLAG, ");
strSQL.Append("PAY_TERMS, VENDOR_ATTN, TELNO, FAXNO, ");
strSQL.Append("ZIP_CD, STATE, ADDRESS1, ADDRESS2, ");
strSQL.Append("ADDRESS2, ADDRESS4, STATE2, ADDRESS2_1, ");
strSQL.Append("ADDRESS2_2, ADDRESS2_3, ADDRESS2_4, REJ_WHS, "); //ADD BY UBIQ-LIU 2010/11/23 add [REJ_WHS]
strSQL.Append("DATA_CHAR1, DATA_CHAR2, ");
strSQL.Append("DATA_CHAR3, DATA_CHAR4, DATA_CHAR5, DATA_CHAR6, ");
strSQL.Append("DATA_CHAR7, DATA_CHAR8, DATA_CHAR9, DATA_CHAR10, ");
strSQL.Append("DATA_NUM1, DATA_NUM2, DATA_NUM3, DATA_NUM4, ");
strSQL.Append("DATA_NUM5, DATA_NUM6, DATA_NUM7, DATA_NUM8, ");
strSQL.Append("DATA_NUM9, DATA_NUM10, DATA_FLAG1, DATA_FLAG2, ");
strSQL.Append("DATA_FLAG3, DATA_FLAG4, DATA_FLAG5, DATA_FLAG6, ");
strSQL.Append("DATA_FLAG7, DATA_FLAG8, DATA_FLAG9, DATA_FLAG10, ");
strSQL.Append("ENTRY_DATE, CHG_DATE, CHG_PGM, CHG_USERID, ");
strSQL.Append("UPDATE_CNTR ");
strSQL.Append(" FROM VENDOR_MASTER ");
if (_vendor_cd != "" || _vendor_name != "")
{
strSQL.Append(" WHERE ");
if (_vendor_cd != "")
{
strSQL.Append(" VENDOR_CD LIKE '" + _vendor_cd + "%'");
if (_vendor_name != "")
{
strSQL.Append(" AND ");
}
}
if (_vendor_name != "")
{
strSQL.Append(" VENDOR_NAME LIKE '%" + _vendor_name + "%'");
}
}
strSQL.Append(" ORDER BY VENDOR_CD");
db.DbParametersClear();
try
{
ds = db.DbDataSet(strSQL.ToString(), "TABLE");
if (ds == null)
{
_dbmsg = db.expmsg;
_strErr = db.strErr;
}
if (db.State() == ConnectionState.Open)
{
db.DbClose();
}
return(ds);
}
catch
{
_dbmsg = db.expmsg;
_strErr = db.strErr;
if (db.State() == ConnectionState.Open)
{
db.DbClose();
}
return(null);
}
}
/// <summary>
/// JOCの取得
///
/// <para>使用画面：SearchJoc</para>
/// </summary>
public DataSet GetJOCList()//UPD UBIQ-LIU 2010/07/01
{
ComDB db = new ComDB(_db_type);
StringBuilder strSQL = new StringBuilder();
DataSet ds = new DataSet();
ComLibrary comlibrary = new ComLibrary();
//--- sql
//--> ADD BY UBIQ-SUO 2010/09/25
strSQL.Append(" SELECT COUNT(*) ");
//strSQL.Append(" J.JOC_CD, J.BEG_EFF_DATE, J.END_EFF_DATE, ");
//strSQL.Append(" J.JOC_STATUS, J.JOC_TYPE, J.JOC_DESC, ");
//strSQL.Append(" J.JOC_DESC2, J.COST_CENTER, J.WS_CD, ");
//strSQL.Append(" J.PROCESS_CD, J.CHG_PGM, J.CHG_USERID, ");
//strSQL.Append(" J.UPDATE_CNTR, W.WS_DESC AS WS_DESC, ");
//strSQL.Append(" S.DATA_CHAR AS COST_CENTER_DESC ");
if (_db_type == "ORACLE")
{
strSQL.Append(" FROM JOC_MASTER J ");
//strSQL.Append(" LEFT OUTER JOIN WORKSHOP_MASTER W ON J.WS_CD = W.WS_CD ");
//strSQL.Append(" LEFT OUTER JOIN SYSTEM_PARAMETER S ON S.KEY01 ='COST_CENTER'");
//strSQL.Append(" AND J.COST_CENTER =S.KEY02 ");
strSQL.Append(" WHERE J.JOC_TYPE = @JOC_TYPE ");
strSQL.Append(" AND JOC_STATUS = @JOC_STATUS ");
db.DbParametersClear();
if (_item_no != "")
{
strSQL.Append(" AND J.JOC_ITEM_NO = @ITEM_NO ");
db.DbPsetString("@ITEM_NO", _item_no);
}
db.DbPsetInt("@JOC_STATUS", _srchflag);
db.DbPsetInt("@JOC_TYPE", _joc_type);
}
else
{
strSQL.Append(" FROM JOC_MASTER J ");
//strSQL.Append(" LEFT OUTER JOIN WORKSHOP_MASTER W ON J.WS_CD = W.WS_CD ");
//strSQL.Append(" LEFT OUTER JOIN SYSTEM_PARAMETER S ON S.KEY01 ='COST_CENTER'");
//strSQL.Append(" AND J.COST_CENTER =S.KEY02 ");
strSQL.Append(" WHERE J.JOC_TYPE = @JOC_TYPE ");
strSQL.Append(" AND JOC_STATUS = @JOC_STATUS ");
db.DbParametersClear();
if (_item_no != "")
{
strSQL.Append(" AND J.JOC_ITEM_NO = @ITEM_NO ");
db.DbPsetString("@ITEM_NO", _item_no);
}
db.DbPsetInt("@JOC_STATUS", _srchflag);
db.DbPsetInt("@JOC_TYPE", _joc_type);
}
try
{
ds = db.DbDataSet(strSQL.ToString(), "TABLE");
if (ds == null)
{
_dbmsg = db.expmsg;
_strErr = db.strErr;
return(null);
}
//if (db.State() == ConnectionState.Open)
// db.DbClose();
if (comlibrary.StringToInt(ds.Tables[0].Rows[0][0].ToString()) > 2000)
{
_range = true;
}
else
{
_range = false;
}
}
catch
{
_dbmsg = db.expmsg;
_strErr = db.strErr;
if (db.State() == ConnectionState.Open)
{
db.DbClose();
}
return(null);
}
strSQL = new StringBuilder();
//<-- ADD BY UBIQ-SUO 2010/09/25
strSQL.Append(" SELECT TOP 2000 "); //UPD BY UBIQ-SUO 2010/09/25 ADD TOP 2000
strSQL.Append(" J.JOC_CD, J.BEG_EFF_DATE, J.END_EFF_DATE, ");
strSQL.Append(" J.JOC_STATUS, J.JOC_TYPE, J.JOC_DESC, ");
strSQL.Append(" J.JOC_DESC2, J.COST_CENTER, J.WS_CD, ");
strSQL.Append(" J.PROCESS_CD, J.CHG_PGM, J.CHG_USERID, ");
strSQL.Append(" J.UPDATE_CNTR, W.WS_DESC AS WS_DESC, ");
strSQL.Append(" S.DATA_CHAR AS COST_CENTER_DESC ");
if (_db_type == "ORACLE")
{
strSQL.Append(" FROM JOC_MASTER J ");
strSQL.Append(" LEFT OUTER JOIN WORKSHOP_MASTER W ON J.WS_CD = W.WS_CD ");
strSQL.Append(" LEFT OUTER JOIN SYSTEM_PARAMETER S ON S.KEY01 ='COST_CENTER'");
strSQL.Append(" AND J.COST_CENTER =S.KEY02 ");
strSQL.Append(" WHERE J.JOC_TYPE = @JOC_TYPE ");
strSQL.Append(" AND JOC_STATUS = @JOC_STATUS ");
db.DbParametersClear();
if (_item_no != "")
{
strSQL.Append(" AND J.JOC_ITEM_NO = @ITEM_NO ");
db.DbPsetString("@ITEM_NO", _item_no);
}
db.DbPsetInt("@JOC_STATUS", _srchflag);
db.DbPsetInt("@JOC_TYPE", _joc_type);
}
else
{
strSQL.Append(" FROM JOC_MASTER J ");
strSQL.Append(" LEFT OUTER JOIN WORKSHOP_MASTER W ON J.WS_CD = W.WS_CD ");
strSQL.Append(" LEFT OUTER JOIN SYSTEM_PARAMETER S ON S.KEY01 ='COST_CENTER'");
strSQL.Append(" AND J.COST_CENTER =S.KEY02 ");
strSQL.Append(" WHERE J.JOC_TYPE = @JOC_TYPE ");
strSQL.Append(" AND JOC_STATUS = @JOC_STATUS ");
db.DbParametersClear();
if (_item_no != "")
{
strSQL.Append(" AND J.JOC_ITEM_NO = @ITEM_NO ");
db.DbPsetString("@ITEM_NO", _item_no);
}
db.DbPsetInt("@JOC_STATUS", _srchflag);
db.DbPsetInt("@JOC_TYPE", _joc_type);
}
try
{
ds = db.DbDataSet(strSQL.ToString(), "TABLE");
if (ds == null)
{
_dbmsg = db.expmsg;
_strErr = db.strErr;
}
if (db.State() == ConnectionState.Open)
{
db.DbClose();
}
return(ds);
}
catch
{
_dbmsg = db.expmsg;
_strErr = db.strErr;
if (db.State() == ConnectionState.Open)
{
db.DbClose();
}
return(null);
}
}
/// <summary>
/// 仕入先一覧の取得
///
/// 使用画面：MstVendorMnt, SrchVendor
/// </summary>
public DataSet GetCustomerList()
{
ComDB db = new ComDB(_db_type);
StringBuilder strSQL = new StringBuilder();
DataSet ds = new DataSet();
ComLibrary comlibrary = new ComLibrary();
//--- sql
//-->ADD BY UBIQ-SUO 2010/09/25
strSQL.Append("SELECT COUNT(*)");
//strSQL.Append("CUST_CD, CUST_SUB_CD, ");
//strSQL.Append("CUST_NAME, CUST_DESC, CUST_NAME2, CUST_DESC2, ");
//strSQL.Append("COUNTRY_CD, FOREIGN_FLAG, CUR_CD, SHIP_WHS, ");
//strSQL.Append("TRANS_LT, SHIP_SLIP_TYPE, PAY_TERMS, ");
//strSQL.Append("EVAL_RATIO, CUST_ATTN, TELNO, FAXNO, ");
//strSQL.Append("ZIP_CD, STATE, ADDRESS1, ADDRESS2, ");
//strSQL.Append("ADDRESS3, ADDRESS4, STATE2, ADDRESS2_1, ");
//strSQL.Append("ADDRESS2_2, ADDRESS2_3, ADDRESS2_4, ");
//strSQL.Append("DATA_CHAR1, DATA_CHAR2, ");
//strSQL.Append("DATA_CHAR3, DATA_CHAR4, DATA_CHAR5, DATA_CHAR6, ");
//strSQL.Append("DATA_CHAR7, DATA_CHAR8, DATA_CHAR9, DATA_CHAR10, ");
//strSQL.Append("DATA_NUM1, DATA_NUM2, DATA_NUM3, DATA_NUM4, ");
//strSQL.Append("DATA_NUM5, DATA_NUM6, DATA_NUM7, DATA_NUM8, ");
//strSQL.Append("DATA_NUM9, DATA_NUM10, DATA_FLAG1, DATA_FLAG2, ");
//strSQL.Append("DATA_FLAG3, DATA_FLAG4, DATA_FLAG5, DATA_FLAG6, ");
//strSQL.Append("DATA_FLAG7, DATA_FLAG8, DATA_FLAG9, DATA_FLAG10, ");
//strSQL.Append("CHG_PGM, CHG_USERID, ");
//strSQL.Append("UPDATE_CNTR");
strSQL.Append(" FROM CUSTOMER_MASTER ");
db.DbParametersClear();
if (_cust_cd != "" || _cust_name != "")
{
strSQL.Append(" WHERE ");
if (_cust_cd != "")
{
strSQL.Append(" CUST_CD LIKE '" + _cust_cd + "%'");
if (_cust_name != "")
{
strSQL.Append(" AND ");
}
}
if (_cust_name != "")
{
strSQL.Append(" CUST_NAME LIKE '%" + _cust_name + "%'");
}
}
//strSQL.Append(" ORDER BY CUST_CD");
try
{
ds = db.DbDataSet(strSQL.ToString(), "TABLE");
if (ds == null)
{
_dbmsg = db.expmsg;
_strErr = db.strErr;
return(null);
}
//if (db.State() == ConnectionState.Open)
// db.DbClose();
if (comlibrary.StringToInt(ds.Tables[0].Rows[0][0].ToString()) > 2000)
{
_range = true;
}
else
{
_range = false;
}
}
catch
{
_dbmsg = db.expmsg;
_strErr = db.strErr;
if (db.State() == ConnectionState.Open)
{
db.DbClose();
}
return(null);
}
strSQL = new StringBuilder();
//<--ADD BY UBIQ-SUO 2010/09/25
strSQL.Append("SELECT TOP 2000");
strSQL.Append("CUST_CD, CUST_SUB_CD, ");
strSQL.Append("CUST_NAME, CUST_DESC, CUST_NAME2, CUST_DESC2, ");
strSQL.Append("COUNTRY_CD, FOREIGN_FLAG, CUR_CD, SHIP_WHS, ");
strSQL.Append("TRANS_LT, SHIP_SLIP_TYPE, PAY_TERMS, ");
strSQL.Append("EVAL_RATIO, CUST_ATTN, TELNO, FAXNO, ");
strSQL.Append("ZIP_CD, STATE, ADDRESS1, ADDRESS2, ");
strSQL.Append("ADDRESS3, ADDRESS4, STATE2, ADDRESS2_1, ");
strSQL.Append("ADDRESS2_2, ADDRESS2_3, ADDRESS2_4, ");
strSQL.Append("DATA_CHAR1, DATA_CHAR2, ");
strSQL.Append("DATA_CHAR3, DATA_CHAR4, DATA_CHAR5, DATA_CHAR6, ");
strSQL.Append("DATA_CHAR7, DATA_CHAR8, DATA_CHAR9, DATA_CHAR10, ");
strSQL.Append("DATA_NUM1, DATA_NUM2, DATA_NUM3, DATA_NUM4, ");
strSQL.Append("DATA_NUM5, DATA_NUM6, DATA_NUM7, DATA_NUM8, ");
strSQL.Append("DATA_NUM9, DATA_NUM10, DATA_FLAG1, DATA_FLAG2, ");
strSQL.Append("DATA_FLAG3, DATA_FLAG4, DATA_FLAG5, DATA_FLAG6, ");
strSQL.Append("DATA_FLAG7, DATA_FLAG8, DATA_FLAG9, DATA_FLAG10, ");
strSQL.Append("CHG_PGM, CHG_USERID, ");
strSQL.Append("UPDATE_CNTR");
strSQL.Append(" FROM CUSTOMER_MASTER ");
db.DbParametersClear();
if (_cust_cd != "" || _cust_name != "")
{
strSQL.Append(" WHERE ");
if (_cust_cd != "")
{
strSQL.Append(" CUST_CD LIKE '" + _cust_cd + "%'");
if (_cust_name != "")
{
strSQL.Append(" AND ");
}
}
if (_cust_name != "")
{
strSQL.Append(" CUST_NAME LIKE '%" + _cust_name + "%'");
}
}
strSQL.Append(" ORDER BY CUST_CD");
try
{
ds = db.DbDataSet(strSQL.ToString(), "TABLE");
if (ds == null)
{
_dbmsg = db.expmsg;
_strErr = db.strErr;
}
if (db.State() == ConnectionState.Open)
{
db.DbClose();
}
return(ds);
}
catch
{
_dbmsg = db.expmsg;
_strErr = db.strErr;
if (db.State() == ConnectionState.Open)
{
db.DbClose();
}
return(null);
}
}
