private void BtnDel_Click(object sender, EventArgs e)
{
if (this.dataGridView1 != null && this.dataGridView1.Rows.Count > 0)
{
if (dataGridView1.CurrentRow != null)
{
DataGridViewRow _dr = this.dataGridView1.Rows[dataGridView1.CurrentRow.Index];
if (_dr != null)
{
string _Company_Id = string.IsNullOrEmpty(_dr.Cells["Company_Id"].Value.ToString()) ? "" : (_dr.Cells["Company_Id"].Value.ToString()).ToString();
string _Notify_Id = string.IsNullOrEmpty((_dr.Cells["Notify_Id"].Value.ToString()).ToString()) ? "" : (_dr.Cells["Notify_Id"].Value.ToString()).ToString();
if (!CommomHelper.ChkDel("确认删除单据[" + _Notify_Id + "]?"))
{
return;
}
try
{
string insertWhere = " Where 1=1 and Company_Id='" + LoginInfo._Usr_Company + "' and Notify_Id='" + _Notify_Id + "'";
InsertDataForTemp(insertWhere);
bool _delOk = false;
if (DelteAudit(_Company_Id, _Notify_Id))
{
_delOk = Delete(_Company_Id, _Notify_Id);
}
if (_delOk)
{
StringBuilder strGetIdSql = new StringBuilder();
strGetIdSql.Append(" Exec dbo.usp_DelBilId1 ");
strGetIdSql.Append(" @Company_Id='" + LoginInfo._Usr_Company + "', ");
strGetIdSql.Append(" @Pgm_Tag_Id='TN', ");
strGetIdSql.Append(" @Bill_Date='" + System.DateTime.Now.ToShortDateString() + "', ");
strGetIdSql.Append(" @Serial_Number=1 , ");
strGetIdSql.Append(" @Bil_Id='" + _Notify_Id + "' ");
DataTable _dtRusult = SqlHelper.ExecuteDataTable(strGetIdSql.ToString());
string _where = " Where 1=1 and Company_Id='" + LoginInfo._Usr_Company + "'";
QueryData(_where);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
}
}
