private void btnOK_Click(object sender, System.EventArgs e)
{
//添加
if (txtContactNo.Text.Trim().Length == 0)
{
Popup("请输入合同编号！");
return;
}
if (txtDeliveryCompany.Text.Trim().Length == 0)
{
Popup("请输入单位名称！");
return;
}
string strContractSql = "select * from tbSpecialOilDept where cnvcContractNo='" + txtContactNo.Text + "' ";
string strDeliveryCompany = "select * from tbSpecialOilDept where cnvcDeliveryCompany = '" + txtDeliveryCompany.Text + "'";
DataTable dtContract = ReportQueryFacade.CommonQuery(strContractSql);
DataTable dtDeliveryCompany = ReportQueryFacade.CommonQuery(strDeliveryCompany);
if (dtContract.Rows.Count > 0)
{
Popup("相同的合同编号已存在！");
return;
}
if (dtDeliveryCompany.Rows.Count > 0)
{
Popup("相同的单位名称已存在！");
return;
}
SpecialOilDept specialOilDept = new SpecialOilDept();
specialOilDept.cnvcContractNo = txtContactNo.Text;
specialOilDept.cnvcDeliveryCompany = txtDeliveryCompany.Text;
Dept curDept = Session[ConstValue.LOGIN_DEPT_SESSION] as Dept;
Oper curOper = Session[ConstValue.LOGIN_USER_SESSION] as Oper;
BusiLog busiLog = new BusiLog();
busiLog.cndOperDate = DateTime.Now;
busiLog.cnnSerial = Guid.NewGuid();
busiLog.cnvcOperName = curOper.cnvcOperName;
busiLog.cnvcComments = "添加领用单位：" + txtContactNo.Text + "|" + txtDeliveryCompany.Text;
busiLog.cnvcDeptID = curDept.cnvcDeptID;
busiLog.cnvcDeptName = curDept.cnvcDeptName;
busiLog.cnvcOperType = "BS013";
busiLog.cnvcSource = "网站";
SpecialOilFacade.AddSpecialOilDept(specialOilDept, busiLog);
Popup("领用单位添加成功");
}
private void dgCompany_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
//
try
{
string strContractNo = e.Item.Cells[0].Text;
string strDeliveryCompany = e.Item.Cells[1].Text;
Dept curDept = Session[ConstValue.LOGIN_DEPT_SESSION] as Dept;
Oper curOper = Session[ConstValue.LOGIN_USER_SESSION] as Oper;
BusiLog busiLog = new BusiLog();
busiLog.cndOperDate = DateTime.Now;
busiLog.cnnSerial = Guid.NewGuid();
busiLog.cnvcOperName = curOper.cnvcOperName;
busiLog.cnvcComments = "删除领用单位：" + strContractNo + "|" + strDeliveryCompany;
busiLog.cnvcDeptID = curDept.cnvcDeptID;
busiLog.cnvcDeptName = curDept.cnvcDeptName;
busiLog.cnvcOperType = "BS015";
busiLog.cnvcSource = "网站";
SpecialOilDept specialOilDept = new SpecialOilDept();
specialOilDept.cnvcContractNo = strContractNo;
specialOilDept.cnvcDeliveryCompany = strDeliveryCompany;
SpecialOilFacade.DeleteSpecialOilDept(specialOilDept, busiLog);
this.dgCompany.EditItemIndex = -1;
this.BindCompany();
Popup("领用单位删除成功");
}
catch (System.Exception ex)
{
Popup(ex.Message);
}
}
private void dgCompany_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
//
try
{
string strOldContractNo = e.Item.Cells[0].Text;
string strOldDeliveryCompany = e.Item.Cells[1].Text;
string strContractNo = ((TextBox)e.Item.Cells[2].Controls[0]).Text;
string strDeliveryCompany = ((TextBox)e.Item.Cells[3].Controls[0]).Text;
if (strContractNo.Trim().Length == 0)
{
Popup("请输入合同编号！");
return;
}
if (strDeliveryCompany.Trim().Length == 0)
{
Popup("请输入单位名称！");
return;
}
string strContractSql = "select * from tbSpecialOilDept where cnvcContractNo='" + strContractNo + "' ";
string strDeliveryCompanySql = "select * from tbSpecialOilDept where cnvcDeliveryCompany = '" + strDeliveryCompany + "'";
DataTable dtContract = ReportQueryFacade.CommonQuery(strContractSql);
DataTable dtDeliveryCompany = ReportQueryFacade.CommonQuery(strDeliveryCompanySql);
if (dtContract.Rows.Count > 0 && strOldContractNo != strContractNo)
{
Popup("相同的合同编号已存在！");
return;
}
if (dtDeliveryCompany.Rows.Count > 0 && strOldDeliveryCompany != strDeliveryCompany)
{
Popup("相同的单位名称已存在！");
return;
}
Dept curDept = Session[ConstValue.LOGIN_DEPT_SESSION] as Dept;
Oper curOper = Session[ConstValue.LOGIN_USER_SESSION] as Oper;
BusiLog busiLog = new BusiLog();
busiLog.cndOperDate = DateTime.Now;
busiLog.cnnSerial = Guid.NewGuid();
busiLog.cnvcOperName = curOper.cnvcOperName;
busiLog.cnvcComments = "修改领用单位：" + strContractNo + "|" + strDeliveryCompany;
busiLog.cnvcDeptID = curDept.cnvcDeptID;
busiLog.cnvcDeptName = curDept.cnvcDeptName;
busiLog.cnvcOperType = "BS014";
busiLog.cnvcSource = "网站";
SpecialOilDept specialOilDept = new SpecialOilDept();
specialOilDept.cnvcContractNo = strContractNo;
specialOilDept.cnvcDeliveryCompany = strDeliveryCompany;
SpecialOilFacade.UpdateSpecialOilDept(strOldContractNo, specialOilDept, busiLog);
this.dgCompany.EditItemIndex = -1;
this.BindCompany();
Popup("领用单位修改成功");
}
catch (System.Exception ex)
{
Popup(ex.Message);
}
}
