private bool DelteAudit(string Company_Id, string Bil_id)
{
bool isEor = true;
string _Head_Tbl_Name = "";
string _Body_Tbl_Name = "";
try
{
_Head_Tbl_Name = "[" + HeadTemp + "]";
_Body_Tbl_Name = "[" + BodyTemp + "]";
StringBuilder strSql = new StringBuilder();
strSql.Append(" Exec dbo.usp_TaskNotifyOrder_Del @Pgm_Id='TaskNotifyOrder', ");
strSql.Append(" @Company_Id='" + Company_Id + "', ");
strSql.Append(" @Notify_Id='" + Bil_id + "',");
strSql.Append(" @Loaded_Head_Tbl_Name='"+ HeadTemp + "', ");
strSql.Append(" @Loaded_Body_Tbl_Name='" + BodyTemp + "' ");
DataTable _dtRusult = SqlHelper.ExecuteDataTable(strSql.ToString());
if (_dtRusult != null && _dtRusult.Rows.Count > 0)
{
string _msg = "";
if (_dtRusult.Columns.Contains("Error_Msg"))
{
_msg = _dtRusult.Rows[0]["Error_Msg"].ToString();
}
if (!string.IsNullOrEmpty(_msg))
{
MessageBox.Show("出现错误：" + _msg);
isEor = false;
}
else
{
Dictionary <string, object> _ht = new Dictionary <string, object>();
_ht["SEND_SERVER_IP"] = _dtRusult.Rows[0]["SEND_SERVER_IP"].ToString();
_ht["SEND_PORT"] = _dtRusult.Rows[0]["SEND_PORT"].ToString();
_ht["SEND_EMAIL_ID"] = _dtRusult.Rows[0]["SEND_EMAIL_ID"].ToString();
_ht["SEND_PASSWORD"] = _dtRusult.Rows[0]["SEND_PASSWORD"].ToString();
_ht["RECIPIENT_EMAIL_IDS"] = _dtRusult.Rows[0]["RECIPIENT_EMAIL_IDS"].ToString();
_ht["CC_EMAIL_IDS"] = _dtRusult.Rows[0]["CC_EMAIL_IDS"].ToString();
MailClass.SendLargeMsg(tableLayoutPanel1, dataGridView1, "需求单", _ht);
}
}
}
catch (Exception _ex)
{
MessageBox.Show(_ex.Message.ToString());
}
finally
{
StringBuilder strDel = new StringBuilder();
strDel.Append("DROP TABLE [" + HeadTemp + "];");
strDel.Append("DROP TABLE [" + BodyTemp + "];");
SqlHelper.ExecuteQuery(strDel.ToString());
}
return(isEor);
}
/// <summary>
/// 撤回
/// </summary>
private void afterSendCh()
{
string _Head_Tbl_Name = "";
string _Body_Tbl_Name = "";
try
{
_Head_Tbl_Name = "[" + HeadTemp + "]";
_Body_Tbl_Name = "[" + BodyTemp + "]";
StringBuilder strSql = new StringBuilder();
strSql.Append(" Exec dbo.usp_ShippingInfoConfirmOrder_Rev @Pgm_Id='ShippingInfoConfirmOrder',");
strSql.Append(" @Company_Id='" + LoginInfo._Usr_Company + "', ");
strSql.Append(" @Shipping_Id='" + this.Shipping_Id.Text + "',");
strSql.Append(" @Loaded_Head_Tbl_Name='" + _Head_Tbl_Name + "', ");
strSql.Append(" @Loaded_Body_Tbl_Name='" + _Body_Tbl_Name + "', ");
strSql.Append(" @User_Id='" + LoginInfo._Usr_id + "' ");
DataTable _dtRusult = SqlHelper.ExecuteDataTable(strSql.ToString());
if (_dtRusult != null && _dtRusult.Rows.Count > 0)
{
string _msg = "";
if (_dtRusult.Columns.Contains("Error_Msg"))
{
_msg = _dtRusult.Rows[0]["Error_Msg"].ToString();
}
if (!string.IsNullOrEmpty(_msg))
{
MessageBox.Show("出现错误：" + _msg);
return;
}
else
{
Dictionary <string, object> _ht = new Dictionary <string, object>();
_ht["SEND_SERVER_IP"] = _dtRusult.Rows[0]["SEND_SERVER_IP"].ToString();
_ht["SEND_PORT"] = _dtRusult.Rows[0]["SEND_PORT"].ToString();
_ht["SEND_EMAIL_ID"] = _dtRusult.Rows[0]["SEND_EMAIL_ID"].ToString();
_ht["SEND_PASSWORD"] = _dtRusult.Rows[0]["SEND_PASSWORD"].ToString();
_ht["RECIPIENT_EMAIL_IDS"] = _dtRusult.Rows[0]["RECIPIENT_EMAIL_IDS"].ToString();
_ht["CC_EMAIL_IDS"] = _dtRusult.Rows[0]["CC_EMAIL_IDS"].ToString();
MailClass.SendLargeMsg(tableLayoutPanel1, dataGridView1, "确认单", _ht);
}
}
}
catch (Exception _ex)
{
MessageBox.Show(_ex.Message.ToString());
}
finally
{
StringBuilder strDel = new StringBuilder();
strDel.Append("DROP TABLE " + _Head_Tbl_Name + ";");
strDel.Append("DROP TABLE " + _Body_Tbl_Name + ";");
SqlHelper.ExecuteQuery(strDel.ToString());
}
}
