/// <summary>
/// 提交
/// </summary>
protected void PostButton_Click(object sender, EventArgs e)
{
#region 检测
if (PRNo.Text.Trim().Length <= 0)
{
this.ShowWarningMessage("请输入请购单号！");
return;
}
#endregion
SqlConnection con = LocalGlobal.DbConnect();
con.Open();
SqlTransaction tran = con.BeginTransaction();//使用事务
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.Transaction = tran;
using (PurProvider purProvider = new PurProvider())
{
try
{
bool flag = false;
foreach (GridViewRow row in List.Rows)
{
HtmlInputCheckBox rowCheckControl = (HtmlInputCheckBox)row.FindControl("RowCheck");
if (rowCheckControl.Checked)
{
string seq = row.Cells[2].Text.Trim();
string status = row.Cells[14].Text.Trim();
if (status == "OK")
{
cmd.CommandText = purProvider.PostPRDetailSql(PRNo.Text.Trim(), seq.ToString());
cmd.ExecuteNonQuery();
flag = true;
}
}
}
if (flag)
{
//更新状态
cmd.CommandText = purProvider.UpdatePRStatusSql(PRNo.Text.Trim(), "PS");
cmd.ExecuteNonQuery();
}
else
{
this.ShowInfoMessage("未选中要提交的记录，请确认请购状态，或未填写价格/厂商！");
tran.Rollback();
return;
}
}
catch (Exception error)
{
tran.Rollback();
this.ShowErrorMessage("提交失败。" + error.Message);
return;
}
tran.Commit();
}
this.BindList();
}