public int DeleteSpecialOilDept(SpecialOilDept specialOilDept, BusiLog busiLog)
{
//SqlConnection conn = ConnectionPool.BorrowConnection();
int iRet = 0;
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
iRet = SpecialOilDeptAccess.DeleteSpecialOilDept(trans, specialOilDept);
BusiLogAccess.AddBusiLog(trans, busiLog);
trans.Commit();
}
catch (SqlException sex)
{
trans.Rollback();
throw sex;
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
return(iRet);
}
private void BindList()
{
DataTable dt = Helper.Query("select * from tbSpecialOilDept where cnvcdeliverycompany like '" + CMSMData.CMSMDataAccess.SysInitial.LocalDeptNameTmp + "%'", true);
listView1.Items.Clear();
listView1.Columns.Clear();
listView1.GridLines = true; //显示行与行之间的分隔线
listView1.FullRowSelect = true; //要选择就是一行
listView1.View = View.Details; //定义列表显示的方式
listView1.Scrollable = true; //需要时候显示滚动条
listView1.MultiSelect = false; // 不可以多行选择
listView1.HeaderStyle = ColumnHeaderStyle.Clickable;
listView1.Columns.Add("合同编号", 200, HorizontalAlignment.Left);
listView1.Columns.Add("单位名称", 270, HorizontalAlignment.Left);
listView1.BeginUpdate();
foreach (DataRow dr in dt.Rows)
{
Entity.SpecialOilDept so = new SpecialOilDept(dr);
ListViewItem lvi = new ListViewItem(new string[] { so.cnvcContractNo, so.cnvcDeliveryCompany });
listView1.Items.Add(lvi);
}
listView1.EndUpdate();
}
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("领用单位添加成功");
}
public static void DeleteSpecialOilDept(SpecialOilDept specialOilDept, BusiLog busiLog)
{
try
{
BusinessRules.SysManage.SpecialOil specialOil = new BusinessRules.SysManage.SpecialOil();
specialOil.DeleteSpecialOilDept(specialOilDept, busiLog);
}
catch (SqlException sex)
{
LogAdapter.WriteDatabaseException(sex);
throw new Exception("数据库访问异常。");
}
catch (Exception ex)
{
LogAdapter.WriteFeaturesException(ex);
throw new Exception("业务规则层异常。");
}
}
private void sbtnMod_Click(object sender, System.EventArgs e)
{
if (this.listView1.SelectedItems.Count < 1)
{
MessageBox.Show(this, "请选择专供油合同", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
Entity.SpecialOilDept so = new SpecialOilDept();
so.cnvcContractNo = listView1.SelectedItems[0].SubItems[0].Text;
so.cnvcDeliveryCompany = listView1.SelectedItems[0].SubItems[1].Text;
so.SetOriginalValue();
frmContractAdd frm = new frmContractAdd();
frm.Flag = OperFlag.MOD;
frm.SO = so;
frm.ShowDialog(this);
BindList();
}
private void sbtnOK_Click(object sender, System.EventArgs e)
{
//保存
if (!SOValidate())
{
return;
}
Entity.BusiLog bl = new CMSM.Entity.BusiLog();
bl.cnvcDeptID = CMSMData.CMSMDataAccess.SysInitial.LocalDeptID;
bl.cnvcDeptName = CMSMData.CMSMDataAccess.SysInitial.LocalDeptName;
bl.cnvcOperName = CMSMData.CMSMDataAccess.SysInitial.CurOps.strOperName;
ContractFacade cf = new ContractFacade();
try
{
switch (_flag)
{
case OperFlag.ADD:
Entity.SpecialOilDept so = new SpecialOilDept();
so.cnvcContractNo = this.textBox1.Text;
so.cnvcDeliveryCompany = this.textBox2.Text;
cf.SOADD(so, bl);
cf.SOSync(CMSMData.CMSMDataAccess.SysInitial.LocalDeptNameTmp);
MessageBox.Show(this, "专供油合同添加成功");
break;
case OperFlag.MOD:
//Entity.SpecialOilDept so = new SpecialOilDept();
_so.cnvcContractNo = this.textBox1.Text;
_so.cnvcDeliveryCompany = this.textBox2.Text;
cf.SOMOD(_so, bl);
cf.SOSync(CMSMData.CMSMDataAccess.SysInitial.LocalDeptNameTmp);
MessageBox.Show(this, "专供油合同修改成功");
break;
}
LoadPara();
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message, "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
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);
}
}
public static int DeleteSpecialOilDept(SqlTransaction trans, SpecialOilDept specialOilDept)
{
return(EntityMapping.Delete(specialOilDept, trans));
}
public static int UpdateSpecialOilDept(SqlTransaction trans, string strContractNo, SpecialOilDept specialOilDept)
{
return(SqlHelper.ExecuteNonQuery(trans, CommandType.Text, "update tbSpecialOilDept set cnvcContractNo='" + specialOilDept.cnvcContractNo + "',cnvcDeliveryCompany='" + specialOilDept.cnvcDeliveryCompany + "' where cnvcContractNo='" + strContractNo + "'"));
}
// 这里写你的代码
//添加
public static long AddSpecialOilDept(SqlTransaction trans, SpecialOilDept specialOilDept)
{
return(EntityMapping.Create(specialOilDept, trans));
}
public void SOSync(string strDeptName)
{
ConnectionPool.IsCenter = true;
DataTable dtCenter = null;
string strsql = "select * from tbSpecialOilDept where cnvcdeliverycompany like '" + strDeptName + "%'";
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
//SqlTransaction trans = conn.BeginTransaction(IsolationLevel.ReadCommitted);
try
{
dtCenter = SqlHelper.ExecuteDataTable(conn, CommandType.Text, strsql);
}
catch (BusinessException bex)
{
//trans.Rollback();
LogAdapter.WriteBusinessException(bex);
throw bex;
}
catch (SqlException sex)
{
//trans.Rollback();
LogAdapter.WriteDatabaseException(sex);
throw sex;
}
catch (Exception ex)
{
//trans.Rollback();
LogAdapter.WriteFeaturesException(ex);
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
ConnectionPool.IsCenter = false;
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
SqlTransaction trans = conn.BeginTransaction(IsolationLevel.ReadCommitted);
try
{
DataTable dtLocal = SqlHelper.ExecuteDataTable(trans, CommandType.Text, strsql);
foreach (DataRow dr in dtCenter.Rows)
{
Entity.SpecialOilDept so = new SpecialOilDept(dr);
DataRow[] drs = dtLocal.Select("cnvcContractNo='" + so.cnvcContractNo + "'");
if (drs.Length > 0)
{
Entity.SpecialOilDept oldso = new SpecialOilDept(drs[0]);
so.SynchronizeModifyValue(oldso);
EntityMapping.Update(so, trans);
}
else
{
EntityMapping.Create(so, trans);
}
}
trans.Commit();
}
catch (BusinessException bex)
{
trans.Rollback();
LogAdapter.WriteBusinessException(bex);
throw bex;
}
catch (SqlException sex)
{
trans.Rollback();
LogAdapter.WriteDatabaseException(sex);
throw sex;
}
catch (Exception ex)
{
trans.Rollback();
LogAdapter.WriteFeaturesException(ex);
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
}
