protected void DbInit()
{
DataTable dt = new DataTable(), dt2 = new DataTable();
ErrorGV.DataSource = null;
ErrorGV.DataBind();
SamGV.DataSource = null;
SamGV.DataBind();
try
{
using (SqlConnection Conn = new SqlConnection(strConnectString))
{
SqlDataAdapter myAdapter = new SqlDataAdapter(selectsql("CheckData").ToString(), Conn);
myAdapter.Fill(dt); //---- 這時候執行SQL指令。取出資料，放進 DataSet。
}
#region query 使用 In
// using (SqlConnection conn1 = new SqlConnection(strConnectString))
// {
// SqlCommand command1 = conn1.CreateCommand();
// SqlTransaction transaction1;
// conn1.Open();
// transaction1 = conn1.BeginTransaction("createExcelImport");
// try
// {
// command1.Connection = conn1;
// command1.Transaction = transaction1;
// #region 匯入
// string[] parameters = SamArray.Select((s, i) => "@sam_nbr" + i.ToString()).ToArray();
// command1.CommandText = string.Format(@"SELECT a.receipt_date AS 發版日期,
// b.cus_name AS 客戶名稱, a.cus_style_no AS 款號,
// a.sam_nbr AS 打樣單號, dbo.F_DateToNull(a.samc_fin_date) AS 打版完成日期,
// a.samc_remark60 AS 備註, a.plan_fin_date AS 預計完成日,
// a.online_date AS 上線日期, a.samc_plan_fin_date AS 打版預計完成日,
// a.plan_fin_date AS 預計完日, dbo.F_DateToNull(a.last_date) AS 需求日
// ,dbo.F_DateToNull(a.samc_fin_date) 打版完成日
//from samc_reqm a left join bas_cus_master b on a.site=b.site and a.cus_id=b.cus_id
// where sam_nbr in ( {0} ) and a.site='GGF'
// ", string.Join(",", parameters));
// command1.Parameters.Add("@samc_fin_date", SqlDbType.DateTime).Value = DateRangeTB.Text;
// for (int i = 0; i < SamArray.Length; i++)
// command1.Parameters.AddWithValue(parameters[i], SamArray[i]);
// //command1.Parameters.Add("@sam_nbr", SqlDbType.DateTime).Value = DateRangeTB.Text;
// command1.ExecuteNonQuery();
// SqlDataReader dr = command1.ExecuteReader(CommandBehavior.CloseConnection);
// dt.Load(dr);
// #endregion
// //transaction1.Commit();
// }
// catch (Exception ex)
// {
// Log.ErrorLog(ex, "上傳失敗", StrProgram);
// transaction1.Rollback();
// throw;
// }
// finally
// {
// conn1.Close();
// transaction1.Dispose();
// }
// }
#endregion
if (dt.Rows.Count > 0)
{
DataView dv = new DataView(dt);
dv.RowFilter = " 打樣單狀態 = '無資料' or 打版完成日 = '無打版完成日'";
ErrorGV.DataSource = dv.ToTable();
ErrorGV.DataBind();
dv.RowFilter = String.Empty;
dv.RowFilter = " 打樣單狀態 = '有打樣單' and 打版完成日 <> '無打版完成日' ";
dt2 = dv.ToTable();
dv.RowFilter = String.Empty;
DataTable dt4 = new DataTable();
dv.RowFilter = "打版完成日 = '無打版完成日' and 打樣單狀態 = '有打樣單' ";
dt4 = dv.ToTable();
if (dt4.Rows.Count > 0)
{
SystemFunction systemFunction = new SystemFunction();
StringBuilder sb = new StringBuilder();
sb.Append(@"<h1><strong>樣品主副料到齊，未收到版套</strong></h1>
<table style='width: 498px; height: 180px;' border='1'>
<tbody>
<tr style='height: 52px;'>
<td style='width: 136px; height: 52px; text-align: center;'>
<h1><strong>打樣單號</strong></h1>
</td>
<td style='width: 143px; height: 52px; text-align: center;'>
<h1><strong>款號</strong></h1>
</td>
<td style='width: 130px; height: 52px;'>
<h1 style='text-align: center;'><strong>客戶代號</strong></h1>
</td>
</tr>");
foreach (DataRow item in dt4.Rows)
{
sb.AppendFormat(@"<tr style='height: 53.4688px;'>
<td style='width: 136px; height: 53.4688px; text-align: center;'><strong>{0}</strong></td>
<td style='width: 143px; height: 53.4688px; text-align: center;'><strong>{1}</strong></td>
<td style='width: 130px; height: 53.4688px; text-align: center;'><strong>{2}</strong></td>
</tr>", item["打樣單號"].ToString(), item["款號"].ToString(), item["客戶代號"].ToString());
}
sb.Append("</tbody></ table > ");
systemFunction.SendMail("[email protected];[email protected];", "樣品主副料到期，未收到版套", sb.ToString());
}
if (dt2.Rows.Count > 0)
{
if (UpDate(dt2))
{
using (SqlConnection Conn = new SqlConnection(strConnectString))
{
DataTable dt3 = new DataTable();
SqlDataAdapter myAdapter = new SqlDataAdapter(selectsql("Search", dt2).ToString(), Conn);
myAdapter.Fill(dt3); //---- 這時候執行SQL指令。取出資料，放進 DataSet。
SamGV.DataSource = dt3;
SamGV.DataBind();
}
}
}
//TESTGV.DataBind();
}
else
{
F_ErrorShow("搜尋不到資料");
}
}
catch (Exception ex)
{
Log.ErrorLog(ex, "資料搜尋異常", StrProgram);
F_ErrorShow("資料搜尋異常");
//throw;
}
}