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); } } }