//檢視異常報表
protected void but_Unusual_Report_Click(object sender, EventArgs e)
{
#region
try
{
System.Threading.Thread.Sleep(2000);
DataTable dtA = new DataTable();
this.gv_ErrorData.Visible = false;
this.gv_ErrorDataB.Visible = false;
if (this.TextBoxRowCountLimit.Text.Trim() == "")
{
this.TextBoxRowCountLimit.Text = "500";
}
VDMModel.ProcessImportVCMSLevel bcoA = new VDMModel.ProcessImportVCMSLevel(ConnectionDB);
VDMModel.ProcessImportVCMSFee bcoB = new VDMModel.ProcessImportVCMSFee(ConnectionDB);
if (this.rdoType1.Checked == true)
{
dtA = bcoA.QueryErrorByFind(Session["UID"].ToString(), Convert.ToDateTime(System.DateTime.Now.ToShortDateString()), Convert.ToDateTime(System.DateTime.Now.ToShortDateString()), Convert.ToInt32(this.TextBoxRowCountLimit.Text.Trim()));
#region 資料與GridView繫結
//抓取本頁初次登記的時間
if (dtA.Rows.Count == 0)
{
ErrorMsgLabel.Text = "查無資料！";
}
else
{
string SessionIDName = "VDM051A_gv_ItemInfo" + PageTimeStamp.Value;
this.gv_ErrorData.Visible = true;
Session["SessionID"] = SessionIDName;
Session[SessionIDName] = dtA;
this.gv_ErrorData.DataSource = dtA;
if (this.TextBoxPagesize.Text == "")
this.gv_ErrorData.PageSize = 10;
else
this.gv_ErrorData.PageSize = Convert.ToInt32(this.TextBoxPagesize.Text);
this.gv_ErrorData.PageIndex = 0;
this.gv_ErrorData.DataBind();
}
#endregion
}
else
{
dtA = bcoB.QueryErrorByFind(Session["UID"].ToString(), Convert.ToDateTime(System.DateTime.Now.ToShortDateString()), Convert.ToDateTime(System.DateTime.Now.ToShortDateString()), Convert.ToInt32(this.TextBoxRowCountLimit.Text.Trim()));
string SessionIDName = "VDM051B_gv_ItemInfo" + PageTimeStamp.Value;
this.gv_ErrorDataB.Visible = true;
Session["SessionID"] = SessionIDName;
Session[SessionIDName] = dtA;
this.gv_ErrorDataB.DataSource = dtA;
if (this.TextBoxPagesize.Text == "")
this.gv_ErrorDataB.PageSize = 10;
else
this.gv_ErrorDataB.PageSize = Convert.ToInt32(this.TextBoxPagesize.Text);
this.gv_ErrorDataB.PageIndex = 0;
this.gv_ErrorDataB.DataBind();
}
}
catch (Exception ex)
{
this.ErrorMsgLabel.Text = ex.Message;
}
finally { }
#endregion
}
//查詢
protected void ButtonQuery_Click(object sender, EventArgs e)
{
#region
try
{
#region 檢查條件
this.ErrorMsgLabel.Text = "";
string s_CheckPage = CheckPage(sender);
if (s_CheckPage != string.Empty)
{
this.ErrorMsgLabel.Text = s_CheckPage;
return;
}
#endregion
ErrorMsgLabel.Text = "";
DataTable dtA = new DataTable();
VDMModel.ProcessImportVCMSLevel bcoA = new VDMModel.ProcessImportVCMSLevel(ConnectionDB);
VDMModel.ProcessImportVCMSFee bcoB = new VDMModel.ProcessImportVCMSFee(ConnectionDB);
DateTime dateB, dateE;
DateTime.TryParse(this.SLP_SLPDateRange1.StartDate.ToString(), out dateB);
if (DateTime.TryParse(this.SLP_SLPDateRange1.EndDate.ToString(), out dateE) == false)
dateE = Convert.ToDateTime("3000/01/01");
else
DateTime.TryParse(this.SLP_SLPDateRange1.EndDate.ToString(), out dateE);
this.gv_ErrorData.Visible = false;
this.gv_ErrorDataB.Visible = false;
if (this.TextBoxRowCountLimit.Text.Trim() == "")
{
this.TextBoxRowCountLimit.Text = "500";
}
if (this.rdoTypeQ1.Checked == true)
{
//因為把"關鍵字搜尋"拿掉，所以沒有CheckBoxLikeSearch
//dtA = bcoA.QueryErrorByFind(GetValueSetParameter(this.txt_User.Text.Trim(), "string", this.CheckBoxLikeSearch.Checked).ToString(), dateB, dateE, Convert.ToInt32(this.TextBoxRowCountLimit.Text.Trim()));
dtA = bcoA.QueryErrorByFind(GetValueSetParameter(this.txt_User.Text.Trim(), "string", false).ToString(), dateB, dateE,Convert.ToInt32(this.TextBoxRowCountLimit.Text.Trim()));
#region 資料與GridView繫結
//抓取本頁初次登記的時間
if (dtA.Rows.Count == 0)
{
this.gv_ErrorData.Visible = false;
ErrorMsgLabel.Text = "查無資料！";
}
else
{
string SessionIDName = "VDM051A_gv_ItemInfo" + PageTimeStamp.Value;
this.gv_ErrorData.Visible = true;
Session["SessionID"] = SessionIDName;
Session[SessionIDName] = dtA;
this.gv_ErrorData.DataSource = dtA;
if (this.TextBoxPagesize.Text == "")
this.gv_ErrorData.PageSize = 10;
else
this.gv_ErrorData.PageSize = Convert.ToInt32(this.TextBoxPagesize.Text);
this.gv_ErrorData.PageIndex = 0;
this.gv_ErrorData.DataBind();
}
#endregion
}
else
{
//因為把"關鍵字搜尋"拿掉，所以沒有CheckBoxLikeSearch
//dtA = bcoB.QueryErrorByFind(GetValueSetParameter(this.txt_User.Text.Trim(), "string", this.CheckBoxLikeSearch.Checked).ToString(), dateB, dateE, Convert.ToInt32(this.TextBoxRowCountLimit.Text.Trim()));
dtA = bcoB.QueryErrorByFind(GetValueSetParameter(this.txt_User.Text.Trim(), "string", false).ToString(), dateB, dateE, Convert.ToInt32(this.TextBoxRowCountLimit.Text.Trim()));
string SessionIDName = "VDM051B_gv_ItemInfo" + PageTimeStamp.Value;
if (dtA.Rows.Count == 0)
{
this.gv_ErrorData.Visible = false;
ErrorMsgLabel.Text = "查無資料！";
}
else
{
this.gv_ErrorDataB.Visible = true;
Session["SessionID"] = SessionIDName;
Session[SessionIDName] = dtA;
this.gv_ErrorDataB.DataSource = dtA;
if (this.TextBoxPagesize.Text == "")
this.gv_ErrorDataB.PageSize = 10;
else
this.gv_ErrorDataB.PageSize = Convert.ToInt32(this.TextBoxPagesize.Text);
this.gv_ErrorDataB.PageIndex = 0;
this.gv_ErrorDataB.DataBind();
}
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}
private void ClientFileToServerTemp()
{
#region
try
{
this.ErrorMsgLabel.Text = "";
//設定頁面狀態
this.hid_FrmStatus.Value = "fmBroswe";
//LockPage();
System.Threading.Thread.Sleep(2000);
string s_UploadPath = string.Empty;
string s_BackPath = string.Empty;
string s_LoginUser = string.Empty;
ArrayList arl_FileUpload_Return = null;
ArrayList arl_FileToTmp_Return = null;
VDMModel.ProcessImportVCMSLevel bcoA = new VDMModel.ProcessImportVCMSLevel(ConnectionDB);
VDMModel.ProcessImportVCMSFee bcoB = new VDMModel.ProcessImportVCMSFee(ConnectionDB);
#region 上傳檔案到AP端
//取得要上傳的路徑
if (this.FileUpload1.FileName == "")
{
this.ErrorMsgLabel.Text = "請點選要匯入的檔案";
return;
}
s_UploadPath = Server.MapPath("..\\") + System.Configuration.ConfigurationManager.AppSettings["UploadPath"] + "\\VDM\\";
s_LoginUser = Session["UID"].ToString();
if (this.rdoType1.Checked)
arl_FileUpload_Return = bcoA.FileUpload(s_UploadPath, this.FileUpload1, s_LoginUser);
else
arl_FileUpload_Return = bcoB.FileUpload(s_UploadPath, this.FileUpload1, s_LoginUser);
#endregion
if (arl_FileUpload_Return[0].ToString() == "FALSE")//檔案上傳至AP端錯誤
{
#region
this.ErrorMsgLabel.Text = "檔案上傳至AP端錯誤";//檔案上傳至AP端錯誤，後面直接不做了
#endregion
}
else if (arl_FileUpload_Return[0].ToString() == "TRUE")//檔案上傳至AP端正常
{
#region
#region 讀取 txt 資料
DataTable dtA = new DataTable();
dtA = this.MakeDT();
int N_UPLOAD = 0;//上傳筆數
try
{
FileStream fs = new FileStream(arl_FileUpload_Return[1].ToString(), FileMode.Open, FileAccess.Read);
StreamReader m_streamReader = new StreamReader(fs, System.Text.Encoding.GetEncoding(950));
//使用StreamReader类来读取文件
m_streamReader.BaseStream.Seek(0, SeekOrigin.Begin);
string strLine = m_streamReader.ReadLine();
while (strLine != null)
{
DataRow drA = dtA.NewRow();
drA[0] = strLine;
dtA.Rows.Add(drA);
strLine = m_streamReader.ReadLine();
N_UPLOAD++;
}
}
catch (Exception ex)
{
this.Response.Write(ex.Message);
}
#endregion
#region 將檔案匯入TmpTable
int N_TMP_CNT = 0;
int N_TAB_CNT = 0;
string V_MSG = "";
if (this.rdoType1.Checked == true)
{
V_MSG=bcoA.FileToTmp(dtA, null, arl_FileUpload_Return[4].ToString(), Session["UID"].ToString());
if (V_MSG == "")
{
bcoA.QueryVcmsMainTmpImportStat(Session["UID"].ToString(), out N_TMP_CNT, out N_TAB_CNT);
}
else
{
this.ErrorMsgLabel.Text = V_MSG;
}
}
else
{
V_MSG=bcoB.FileToTmp(dtA, null, arl_FileUpload_Return[4].ToString(), Session["UID"].ToString());
if (V_MSG == "")
{
bcoB.QueryVcmsItemTmpImportStat(Session["UID"].ToString(), out N_TMP_CNT, out N_TAB_CNT);
}
else
{
this.ErrorMsgLabel.Text = V_MSG;
}
}
#endregion
//上傳結果
this.UploadStatusPanel1.UploadSum = N_UPLOAD;
this.UploadStatusPanel1.UploadOK = N_TMP_CNT;
this.UploadStatusPanel1.UploadNG = N_UPLOAD-N_TMP_CNT;
if (N_UPLOAD - N_TMP_CNT > 0)
{
((TextBox)UploadStatusPanel1.FindControl("txtUP13")).ForeColor = System.Drawing.Color.Red;
}
//匯入結果
this.UploadStatusPanel1.ImportSum = N_TMP_CNT;
this.UploadStatusPanel1.ImportOK = N_TAB_CNT;
this.UploadStatusPanel1.ImportNG = N_TMP_CNT - N_TAB_CNT;
if (N_TMP_CNT - N_TAB_CNT > 0)
{
((TextBox)UploadStatusPanel1.FindControl("txtUP23")).ForeColor = System.Drawing.Color.Red;
}
#endregion
}
unLockPage();
this.hid_FrmStatus.Value = "";
}
catch (Exception ex)
{
this.ErrorMsgLabel.Text = ex.Message;
unLockPage();
this.hid_FrmStatus.Value = "";
}
#endregion
}