private void btn发布_Click(object sender, EventArgs e)
{
try
{
try
{
gridView1.FocusedRowHandle -= 1;
gridView1.FocusedRowHandle += 1;
}
catch { }
if (txt发布人.Text.Trim() != "")
{
MessageBox.Show("已经发布");
return;
}
btn保存_Click(null, null);
string sSQL = "update UFDLImport..杜乐公告 set 发布人 = '" + FrameBaseFunction.ClsBaseDataInfo.sUid + "',发布日期 = '" + DateTime.Today.ToString("yyyy-MM-dd") + "' where guid = '" + sGuid + "'";
clsSQLCommond.ExecSql(sSQL);
MessageBox.Show("发布成功");
txt发布人.Text = FrameBaseFunction.ClsBaseDataInfo.sUid;
date_发布日期.Text = DateTime.Today.ToString("yyyy-MM-dd");
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
}
private void btn发布_Click(object sender, EventArgs e)
{
try
{
try
{
gridView2.FocusedRowHandle -= 1;
gridView2.FocusedRowHandle += 1;
}
catch { }
sSave();
string sSQL = "select * from UFDLImport..询价单 where [GUID] = '" + sGuid + "'";
DataTable dt = clsSQLCommond.ExecQuery(sSQL);
if (dt == null || dt.Rows.Count == 0)
{
throw new Exception("获得询价单失败");
}
if (dt.Rows[0]["发布人"].ToString().Trim() != "")
{
throw new Exception("已经发布");
}
sSQL = "update UFDLImport..询价单 set 发布人 = '" + FrameBaseFunction.ClsBaseDataInfo.sUid + "',发布日期 = '" + DateTime.Today.ToString("yyyy-MM-dd") + "' where guid = '" + sGuid + "'";
clsSQLCommond.ExecSql(sSQL);
MessageBox.Show("发布成功");
try
{
string[] s供应商 = label供应商.Text.Trim().Split(',');
for (int i = 0; i < s供应商.Length; i++)
{
sSQL = "select sEMail from UFDLImport.._vendUid where vendcode = '" + s供应商[i] + "' and isnull(sEMail,'') <> '' order by AccYear desc";
dt = clsSQLCommond.ExecQuery(sSQL);
if (dt != null && dt.Rows.Count > 0 && dt.Rows[0][0].ToString().Trim() != "")
{
SendMail(dt.Rows[0][0].ToString().Trim(), "报价单", "询价单" + labeliID.Text + "已经发布请尽快报价");
}
}
}
catch { }
this.Close();
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
}
private void btn撤销_Click(object sender, EventArgs e)
{
try
{
string sSQL = @"
select *
from UFDLImport..询价单供应商报价
where 供应商编码 = '@供应商编码' and GUID = '@GUID'
";
sSQL = sSQL.Replace("@供应商编码", lookUpEditcVenCode.EditValue.ToString().Trim());
sSQL = sSQL.Replace("@GUID", sGuid);
DataTable dt = clsSQLCommond.ExecQuery(sSQL);
if (dt == null || dt.Rows.Count == 0)
{
throw new Exception("询价单失败");
}
if (dt.Rows.Count > 0)
{
string s审批人 = dt.Rows[0]["审批人"].ToString().Trim();
if (s审批人 != "")
{
throw new Exception("已经审批不能撤销");
}
}
sSQL = @"
delete UFDLImport..询价单供应商报价
where 供应商编码 = '@供应商编码' and GUID = '@GUID'
";
sSQL = sSQL.Replace("@供应商编码", lookUpEditcVenCode.EditValue.ToString().Trim());
sSQL = sSQL.Replace("@GUID", sGuid);
clsSQLCommond.ExecSql(sSQL);
MessageBox.Show("撤销成功");
this.Close();
}
catch (Exception ee)
{
MessageBox.Show("撤销提交:" + ee.Message);
}
}