public DataTable getAllDept()
{
DataTable dtDept = null;
try
{
conn = ConnectionPool.BorrowConnection();
dtDept = SqlHelper.ExecuteDataTable(conn, CommandType.Text, "select cnnDeptID as 部门ID,cnvcDeptName as 部门名称,cnnParentDeptID as 上级部门ID,cnvcManager as 部门管理员,cnnDiscount as 部门折扣上限 from tbDept");
}
catch (BusinessException bex) //业务异常
{
//LogAdapter.WriteBusinessException(bex);
//trans.Rollback();
throw new BusinessException(bex.Type, bex.Message);
}
catch (SqlException sex) //数据库异常
{
//事务回滚
//trans.Rollback();
//LogAdapter.WriteDatabaseException(sex);
throw new BusinessException("数据库异常", sex.Message);
}
catch (Exception ex) //其他异常
{
//事务回滚
//trans.Rollback();
//LogAdapter.WriteFeaturesException(ex);
throw new BusinessException("其它异常", ex.Message);
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
return(dtDept);
}
public void ModifyPwd(Oper opers)
{
try
{
conn = ConnectionPool.BorrowConnection();
trans = conn.BeginTransaction();
SqlHelper.ExecuteNonQuery(trans, CommandType.Text, "update tbOper set cnvcPwd = '" + opers.cnvcPwd + "' where cnvcOperName = '" + opers.cnvcOperName + "'");
trans.Commit();
}
catch (BusinessException bex) //业务异常
{
//LogAdapter.WriteBusinessException(bex);
trans.Rollback();
throw new BusinessException(bex.Type, bex.Message);
}
catch (SqlException sex) //数据库异常
{
//事务回滚
trans.Rollback();
//LogAdapter.WriteDatabaseException(sex);
throw new BusinessException("数据库异常", sex.Message);
}
catch (Exception ex) //其他异常
{
//事务回滚
trans.Rollback();
//LogAdapter.WriteFeaturesException(ex);
throw new BusinessException("其它异常", ex.Message);
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
public void UpdateCompany(MebCompanyPrepay company, BusiLog busiLog)
{
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
MebCompanyPrepayAccess.UpdateCompany(trans, company);
//FillFeeAccess.AddFee(trans,fee);
MemberAccess.UpdateMemberCompany(trans, company);
BusiLogAccess.AddBusiLog(trans, busiLog);
trans.Commit();
}
catch (SqlException sex)
{
trans.Rollback();
throw sex;
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
}
public void AddFee(FillFee fee, BusiLog busiLog)
{
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
SqlHelper.ExecuteNonQuery(trans, CommandType.Text, "update tbMebCompanyPrepay set cnnPrepayFee = cnnPrepayFee+" + fee.cnnFillFee.ToString() + " where cnvcCompanyID='" + fee.cnvcCompanyID.ToString() + "'");
FillFeeAccess.AddFee(trans, fee);
BusiLogAccess.AddBusiLog(trans, busiLog);
trans.Commit();
}
catch (SqlException sex)
{
trans.Rollback();
throw sex;
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
}
public void UpdateAssignLog(AssignDetail detail, OperLog operLog)
{
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
//
// AssignDetail detail = new AssignDetail();
// detail.cnnAssignSerialNo = detailLog.cnnAssignSerialNo;
// detail.cnnOrderSerialNo = detailLog.cnnOrderSerialNo;
// detail.cnvcProductCode = detailLog.cnvcProductCode;
AssignDetail detailOld = EntityMapping.Get(detail, trans) as AssignDetail;
if (detail.cnnCount != detailOld.cnnCount)
{
string strSysTime = SqlHelper.ExecuteScalar(trans, CommandType.Text, "select getdate()").ToString();
DateTime dtSysTime = DateTime.Parse(strSysTime);
OrderSerialNo serialNo = new OrderSerialNo();
serialNo.cnvcFill = "0";
serialNo.cnnSerialNo = Convert.ToDecimal(EntityMapping.Create(serialNo, trans));
detailOld.cnnCount = detail.cnnCount;
detailOld.cnnSum = Math.Round(detail.cnnCount * detailOld.cnnPrice, 2);
EntityMapping.Update(detailOld, trans);
AssignDetailLog detailLog = new AssignDetailLog(detailOld.ToTable());
detailLog.cnvcOperID = operLog.cnvcOperID;
detailLog.cndOperDate = dtSysTime;
detailLog.cnnSerialNo = serialNo.cnnSerialNo;
EntityMapping.Create(detailLog, trans);
operLog.cndOperDate = dtSysTime;
operLog.cnvcComments = "生产流水：" + detail.cnnAssignSerialNo.ToString() + "，日志流水：" + serialNo.cnnSerialNo.ToString();
EntityMapping.Create(operLog, trans);
}
trans.Commit();
}
catch (SqlException sex)
{
trans.Rollback();
LogAdapter.WriteDatabaseException(sex);
throw sex;
}
catch (Exception ex)
{
trans.Rollback();
LogAdapter.WriteFeaturesException(ex);
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
}
public static void LoadInitCode(System.Web.HttpApplicationState app)
{
SqlConnection conn = ConnectionPool.BorrowConnection();
//DataTable dtRet = null;
try
{
DataTable dtDept = SqlHelper.ExecuteDataTable(conn, CommandType.Text, "select * from tbDept");
app["tbDept"] = dtDept;
DataTable dtLogin = SqlHelper.ExecuteDataTable(conn, CommandType.Text, "select * from tbLogin");
app["tbLogin"] = dtLogin;
DataTable dtNameCode = SqlHelper.ExecuteDataTable(conn, CommandType.Text, "select * from tbNameCode");
app["tbNameCode"] = dtNameCode;
DataTable dtProductClass = SqlHelper.ExecuteDataTable(conn, CommandType.Text, "select * from tbProductClass");
app["tbProductClass"] = dtProductClass;
// DataTable dtProduct = SqlHelper.ExecuteDataTable(conn, CommandType.Text, "select * from vwProduct");
// app["vwProduct"] = dtProduct;
}
catch (Exception ex)
{
LogAdapter.WriteFeaturesException(ex);
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
public int AddOilPrice(OilPrice price, BusiLog busiLog)
{
//SqlConnection conn = ConnectionPool.BorrowConnection();
int iRet = 0;
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
BusiLogAccess.AddBusiLog(trans, busiLog);
iRet = (int)OilPriceAccess.AddOilPrice(trans, price);
trans.Commit();
}
catch (SqlException sex)
{
trans.Rollback();
throw sex;
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
return(iRet);
}
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);
}
public int GetOperID()
{
int iRet = 0;
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
iRet = OperIDAccess.GetOperID(trans);
trans.Commit();
}
catch (SqlException sex)
{
trans.Rollback();
throw sex;
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
return(iRet);
}
public string GetDeptID(string strParentDeptID)
{
SqlConnection conn = ConnectionPool.BorrowConnection();
string strDeptID = "";
try
{
string strLength = Convert.ToString(strParentDeptID.Length + 1);
string s = SqlHelper.ExecuteScalar(conn, CommandType.Text, "select max(cast(substring(cnvcDeptID," + strLength + ",2) as int)) from tbDept where cnvcParentDeptID='" + strParentDeptID + "'").ToString();
if (s == "")
{
s = "0";
}
int i = int.Parse(s);
if (i < 9)
{
strDeptID = strParentDeptID + "0" + Convert.ToString(i + 1);
}
else if (i >= 9 && i < 99)
{
strDeptID = strParentDeptID + Convert.ToString(i + 1);
}
else
{
throw new Exception("²¿ÃÅID³¬³ö·¶Î§£¡");
}
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
return(strDeptID);
}
public void AddDept(Dept dept, BusiLog busiLog)
{
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
DeptAccess.AddDept(trans, dept);
BusiLogAccess.AddBusiLog(trans, busiLog);
trans.Commit();
}
catch (SqlException sex)
{
trans.Rollback();
throw sex;
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
}
public int UpdatePwd(Oper oper, BusiLog busiLog)
{
//SqlConnection conn = ConnectionPool.BorrowConnection();
int iRet = 0;
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
iRet = OperAccess.UpdatePwd(trans, oper);
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);
}
public static DataTable Query(string strSql)
{
SqlConnection conn = ConnectionPool.BorrowConnection();
DataTable dtRet = null;
try
{
//conn.ConnectionTimeout = 300;
//SqlHelper.
dtRet = SqlHelper.ExecuteDataTable(conn, CommandType.Text, strSql);
}
catch (SqlException sex)
{
LogAdapter.WriteDatabaseException(sex);
throw sex;
}
catch (Exception ex)
{
LogAdapter.WriteFeaturesException(ex);
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
return(dtRet);
}
public void UpdateOrder(OrderBook order, OperLog operLog) //,BusiLog busiLog)
{
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
string strSysTime = SqlHelper.ExecuteScalar(trans, CommandType.Text, "select getdate()").ToString();
DateTime dtSysTime = DateTime.Parse(strSysTime);
OrderBook oldOrder = new OrderBook();
oldOrder.cnnOrderSerialNo = order.cnnOrderSerialNo;
oldOrder = EntityMapping.Get(oldOrder, trans) as OrderBook;
if (oldOrder == null)
{
throw new Exception("订单未找到");
}
oldOrder.cnvcOrderOperID = order.cnvcOrderOperID;
oldOrder.cnvcOrderType = order.cnvcOrderType;
oldOrder.cnvcProduceDeptID = order.cnvcProduceDeptID;
oldOrder.cnvcOrderDeptID = order.cnvcOrderDeptID;
if (oldOrder.cnvcOrderType == "WDO")
{
oldOrder.cndArrivedDate = order.cndArrivedDate;
oldOrder.cnvcLinkPhone = order.cnvcLinkPhone;
oldOrder.cnvcShipAddress = order.cnvcShipAddress;
oldOrder.cnvcCustomName = order.cnvcCustomName;
}
//order.cnnOrderSerialNo = decimal.Parse(txtOrderSerialNo.Text);
oldOrder.cndShipDate = order.cndShipDate;
EntityMapping.Update(oldOrder, trans);
operLog.cndOperDate = dtSysTime;
operLog.cnvcComments = "订单流水：" + oldOrder.cnnOrderSerialNo;
EntityMapping.Create(operLog, trans);
//EntityMapping.Create(busiLog, trans);
trans.Commit();
}
catch (SqlException sex)
{
trans.Rollback();
LogAdapter.WriteDatabaseException(sex);
throw sex;
}
catch (Exception ex)
{
trans.Rollback();
LogAdapter.WriteFeaturesException(ex);
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
}
public void AddOperFunc(OperFunc func)
{
try
{
conn = ConnectionPool.BorrowConnection();
trans = conn.BeginTransaction();
EntityMapping.Create(func, trans);
trans.Commit();
}
catch (BusinessException bex) //业务异常
{
//LogAdapter.WriteBusinessException(bex);
trans.Rollback();
throw new BusinessException(bex.Type, bex.Message);
}
catch (SqlException sex) //数据库异常
{
//事务回滚
trans.Rollback();
//LogAdapter.WriteDatabaseException(sex);
throw new BusinessException("数据库异常", sex.Message);
}
catch (Exception ex) //其他异常
{
//事务回滚
trans.Rollback();
//LogAdapter.WriteFeaturesException(ex);
throw new BusinessException("其它异常", ex.Message);
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
public void DragDept(Dept dept)
{
try
{
conn = ConnectionPool.BorrowConnection();
trans = conn.BeginTransaction();
SqlHelper.ExecuteNonQuery(trans, CommandType.Text, "update tbDept set cnnParentDeptID = " + dept.cnnParentDeptID + " where cnnDeptID = " + dept.cnnDeptID);
trans.Commit();
}
catch (BusinessException bex) //业务异常
{
//LogAdapter.WriteBusinessException(bex);
trans.Rollback();
throw new BusinessException(bex.Type, bex.Message);
}
catch (SqlException sex) //数据库异常
{
//事务回滚
trans.Rollback();
//LogAdapter.WriteDatabaseException(sex);
throw new BusinessException("数据库异常", sex.Message);
}
catch (Exception ex) //其他异常
{
//事务回滚
trans.Rollback();
//LogAdapter.WriteFeaturesException(ex);
throw new BusinessException("其它异常", ex.Message);
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
/// <summary>
/// 导入基本参数
/// </summary>
/// <param name="app"></param>
public static void LoadInitCode(System.Web.HttpApplicationState app)
{
SqlConnection conn = ConnectionPool.BorrowConnection();
//DataTable dtRet = null;
try
{
DataTable dtAreaCode = SqlHelper.ExecuteDataTable(conn, CommandType.Text, "select *,cnvcAreaCode as cnvcID,cnvcComments as cnvcName from tbAreaCode order by cnvcTopFlag");
app[ConstApp.A_AREACODE] = dtAreaCode;
DataTable dtOper = SqlHelper.ExecuteDataTable(conn, CommandType.Text, "select *,cnvcOperID as cnvcID,cnvcOperName as cnvcName from tbOper");
app[ConstApp.A_OPER] = dtOper;
DataTable dtFunc = SqlHelper.ExecuteDataTable(conn, CommandType.Text, "select * from tbFunc");
app[ConstApp.A_FUNC] = dtFunc;
DataTable dtOperFunc = SqlHelper.ExecuteDataTable(conn, CommandType.Text, "select * from tbOperFunc");
app[ConstApp.A_OPERFUNC] = dtOperFunc;
DataTable dtDept = SqlHelper.ExecuteDataTable(conn, CommandType.Text, "select *,cnvcDeptID as cnvcID,cnvcDeptName as cnvcName from tbDept");
app[ConstApp.A_DEPT] = dtDept;
DataTable dtNameCode = SqlHelper.ExecuteDataTable(conn, CommandType.Text, "select *,cnvcCode as cnvcID from tbNameCode order by cnnSeqNo");
app[ConstApp.A_NAMECODE] = dtNameCode;
}
catch (Exception ex)
{
LogAdapter.WriteFeaturesException(ex);
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
public void UpdateBook(Book book, OperLog operLog)
{
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
string strSysTime = SqlHelper.ExecuteScalar(trans, CommandType.Text, "select getdate()").ToString();
DateTime dtSysTime = DateTime.Parse(strSysTime);
Entity.Book oldbook = new Book();
oldbook.cnnSerialNo = book.cnnSerialNo;
oldbook = EntityMapping.Get(oldbook, trans) as Book;
if (oldbook == null)
{
throw new Exception("未找到留言内容！");
}
if (oldbook.cnvcState != "0")
{
throw new Exception("已确认的留言不能修改！");
}
oldbook.cnvcBook = book.cnvcBook;
oldbook.cmvcPublishID = book.cmvcPublishID;
oldbook.cnvcPublishName = book.cnvcPublishName;
oldbook.cndPublishDate = dtSysTime;
oldbook.cnvcCheckDept = book.cnvcCheckDept;
oldbook.cnvcCheckID = string.Empty;
oldbook.cnvcCheckName = string.Empty;
oldbook.cndcheckDate = DateTime.MinValue;
EntityMapping.Update(oldbook, trans);
operLog.cndOperDate = dtSysTime;
operLog.cnvcComments = "留言本流水号：" + oldbook.cnnSerialNo.ToString();
EntityMapping.Create(operLog, trans);
trans.Commit();
}
catch (SqlException sex)
{
trans.Rollback();
LogAdapter.WriteDatabaseException(sex);
throw sex;
}
catch (Exception ex)
{
trans.Rollback();
LogAdapter.WriteFeaturesException(ex);
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
}
public static void BatchCustInfo(DataTable dt, Oper oper)
{
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
string strSysTime = SqlHelper.ExecuteScalar(trans, CommandType.Text, "select getdate()").ToString();
DateTime dtSysTime = DateTime.Parse(strSysTime);
foreach (DataRow dr in dt.Rows)
{
Cust cu = new Cust(dr);
cu.cnvcOperID = oper.cnvcOperID;
cu.cndOperDate = dtSysTime;
//newOper.cndCreateDate = dtSysTime;
string strCount = SqlHelper.ExecuteScalar(trans, CommandType.Text, "select count(*) from tbCust where cnnCustID = " + cu.cnnCustID + " or cnvcName='" + cu.cnvcName + "'").ToString();
if (Convert.ToInt32(strCount) > 0)
{
throw new Exception(cu.cnvcName + "已存在");
}
EntityMapping.Create(cu, trans);
BusiLog busiLog = new BusiLog();
busiLog.cndOperDate = dtSysTime;
busiLog.cnnBusiSerialNo = Helper.GetSerialNo(trans);
busiLog.cnvcComments = cu.cnvcName;
busiLog.cnvcFuncCode = " 批量添加客户档案";
busiLog.cnvcOperID = oper.cnvcOperID;
busiLog.cnvcIPAddress = "";
EntityMapping.Create(busiLog, trans);
}
trans.Commit();
}
catch (SqlException sex)
{
trans.Rollback();
LogAdapter.WriteDatabaseException(sex);
throw sex;
}
catch (Exception ex)
{
trans.Rollback();
LogAdapter.WriteFeaturesException(ex);
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
}
public DataTable getAllOperNoSys(Oper opers)
{
DataTable dtOper = null;
try
{
conn = ConnectionPool.BorrowConnection();
if (opers.cnnDeptID == 0)
{
dtOper = SqlHelper.ExecuteDataTable(conn, CommandType.Text, "select * from tbOper where cnnDeptID <> 0");
}
else
{
DataTable dtManage = SqlHelper.ExecuteDataTable(conn, CommandType.Text, "select * from tbDept where cnvcManager = '" + opers.cnvcOperName + "'");
if (dtManage.Rows.Count != 1)
{
dtOper = SqlHelper.ExecuteDataTable(conn, CommandType.Text, "select * from tbOper where cnnDeptID = " + opers.cnnDeptID);
}
else
{
Dept dept = new Dept(dtManage);
dtOper = SqlHelper.ExecuteDataTable(conn, CommandType.Text, "select * from tbOper where cnnDeptID = " + dept.cnnDeptID.ToString());
}
}
//trans = conn.BeginTransaction();
//EntityMapping.Create(opers,trans);
//trans.Commit();
}
catch (BusinessException bex) //业务异常
{
//LogAdapter.WriteBusinessException(bex);
throw new BusinessException(bex.Type, bex.Message);
}
catch (SqlException sex) //数据库异常
{
//事务回滚
//trans.Rollback();
//LogAdapter.WriteDatabaseException(sex);
throw new BusinessException("数据库异常", sex.Message);
}
catch (Exception ex) //其他异常
{
//事务回滚
//trans.Rollback();
//LogAdapter.WriteFeaturesException(ex);
throw new BusinessException("其它异常", ex.Message);
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
return(dtOper);
}
public static void AddProject(Project project, Oper oper)
{
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
string strSysTime = SqlHelper.ExecuteScalar(trans, CommandType.Text, "select getdate()").ToString();
DateTime dtSysTime = DateTime.Parse(strSysTime);
project.cnvcOperID = oper.cnvcOperID;
project.cndOperDate = dtSysTime;
//project.cndCreateDate = dtSysTime;
project.cnnProjectID = Helper.GetSerialNo(trans);
project.cnvcIsSucess = "0";
if (project.cnvcMgr == oper.cnvcOperID || project.cnvcTradeMgr == oper.cnvcOperID)
{
project.cnvcProjectState = "P002";
}
else
{
project.cnvcProjectState = "P001";
}
EntityMapping.Create(project, trans);
BusiLog busiLog = new BusiLog();
busiLog.cndOperDate = dtSysTime;
busiLog.cnnBusiSerialNo = Helper.GetSerialNo(trans);
busiLog.cnvcComments = project.cnvcProjectName;
busiLog.cnvcFuncCode = " 添加商机";
busiLog.cnvcOperID = oper.cnvcOperID;
busiLog.cnvcIPAddress = "";
EntityMapping.Create(busiLog, trans);
trans.Commit();
}
catch (SqlException sex)
{
trans.Rollback();
LogAdapter.WriteDatabaseException(sex);
throw sex;
}
catch (Exception ex)
{
trans.Rollback();
LogAdapter.WriteFeaturesException(ex);
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
}
//减单
public void OrderReduce(string strOrderSerialNo, string strReduceType, string strAddComments, DataTable dtOrderReduce, OperLog operLog) //,BusiLog busiLog)
{
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
string strSysTime = SqlHelper.ExecuteScalar(trans, CommandType.Text, "select getdate()").ToString();
DateTime dtSysTime = DateTime.Parse(strSysTime);
OrderSerialNo serialNo = new OrderSerialNo();
serialNo.cnvcFill = "0";
serialNo.cnnSerialNo = Convert.ToDecimal(EntityMapping.Create(serialNo, trans));
foreach (DataRow drOrderReduce in dtOrderReduce.Rows)
{
OrderReduceLog orderReduce = new OrderReduceLog(drOrderReduce);
orderReduce.cnnOrderSerialNo = decimal.Parse(strOrderSerialNo);
orderReduce.cnnReduceSerialNo = serialNo.cnnSerialNo;
orderReduce.cnvcReduceType = strReduceType;
orderReduce.cnvcReduceComments = strAddComments;
orderReduce.cndOperDate = dtSysTime;
orderReduce.cnvcOperID = operLog.cnvcOperID;
orderReduce.cnvcReduceState = "0";
orderReduce.cnnReduceCount = decimal.Parse(drOrderReduce["cnnOrderCount"].ToString());
EntityMapping.Create(orderReduce, trans);
}
operLog.cndOperDate = dtSysTime;
operLog.cnvcComments = "订单流水：" + strOrderSerialNo;
EntityMapping.Create(operLog, trans);
trans.Commit();
}
catch (SqlException sex)
{
trans.Rollback();
LogAdapter.WriteDatabaseException(sex);
throw sex;
}
catch (Exception ex)
{
trans.Rollback();
LogAdapter.WriteFeaturesException(ex);
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
}
public void AddProductLostSerial(ArrayList alLostSerial, OperLog operLog) //,BusiLog busiLog)
{
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
string strSysTime = SqlHelper.ExecuteScalar(trans, CommandType.Text, "select getdate()").ToString();
DateTime dtSysTime = DateTime.Parse(strSysTime);
SerialNo serialNo = new SerialNo();
serialNo.cnvcFill = "0";
serialNo.cnnSerialNo = Convert.ToInt32(EntityMapping.Create(serialNo, trans));
for (int i = 0; i < alLostSerial.Count; i++)
{
LostSerial ls = (LostSerial)alLostSerial[i];
ls.cnvcLostType = "0";
ls.cndOperDate = dtSysTime;
ls.cnnLostSerialNo = serialNo.cnnSerialNo;
EntityMapping.Create(ls, trans);
// ProductLostSerialLog productLostSerialLog = new ProductLostSerialLog(productLostSerial.ToTable());
// //productSerialLog.cnnSerialNo = null;
// productLostSerialLog.cnnProductLostSerialNo = serialNo.cnnSerialNo;
// EntityMapping.Create(productLostSerialLog, trans);
}
operLog.cndOperDate = dtSysTime;
operLog.cnvcComments = "生产产品报损，报损流水：" + serialNo.cnnSerialNo.ToString();
EntityMapping.Create(operLog, trans);
trans.Commit();
}
catch (SqlException sex)
{
trans.Rollback();
LogAdapter.WriteDatabaseException(sex);
throw sex;
}
catch (Exception ex)
{
trans.Rollback();
LogAdapter.WriteFeaturesException(ex);
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
}
public void BatchUpdateProduceCheck(ArrayList alCheck, string strProduceSerialNo, OperLog operLog)
{
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
string strSysTime = SqlHelper.ExecuteScalar(trans, CommandType.Text, "select getdate()").ToString();
DateTime dtSysTime = DateTime.Parse(strSysTime);
for (int i = 0; i < alCheck.Count; i++)
{
ProduceCheckLog check = alCheck[i] as ProduceCheckLog;
ProduceCheckLog oldCheck = new ProduceCheckLog();
oldCheck.cnnProduceSerialNo = check.cnnProduceSerialNo;
oldCheck.cnvcCode = check.cnvcCode;
oldCheck = EntityMapping.Get(oldCheck, trans) as ProduceCheckLog;
if (oldCheck == null)
{
throw new Exception("未找到指定产品生产库存");
}
oldCheck.cnnCheckCount = check.cnnCheckCount;
oldCheck.cnvcOperID = check.cnvcOperID;
oldCheck.cndOperDate = dtSysTime;
EntityMapping.Update(oldCheck, trans);
}
operLog.cndOperDate = dtSysTime;
operLog.cnvcComments = "生产流水：" + strProduceSerialNo;
EntityMapping.Create(operLog, trans);
trans.Commit();
}
catch (SqlException sex)
{
trans.Rollback();
LogAdapter.WriteDatabaseException(sex);
throw sex;
}
catch (Exception ex)
{
trans.Rollback();
LogAdapter.WriteFeaturesException(ex);
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
}
public void AdjustProductLostSerial_Add(LostSerial ls, OperLog operLog) //,BusiLog busiLog)
{
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
string strSysTime = SqlHelper.ExecuteScalar(trans, CommandType.Text, "select getdate()").ToString();
DateTime dtSysTime = DateTime.Parse(strSysTime);
LostSerial oldls = EntityMapping.Get(ls, trans) as LostSerial;
if (oldls == null)
{
throw new Exception("未找到对应报损流水的产品！");
}
oldls.cnnAddCount = ls.cnnAddCount;
oldls.cnnReduceCount = ls.cnnReduceCount;
oldls.cnvcOperID = operLog.cnvcOperID;
oldls.cndOperDate = dtSysTime;
EntityMapping.Update(oldls, trans);
// ProductLostSerialLog productLostSerialLog = new ProductLostSerialLog(oldProductLostSerial.ToTable());
// productLostSerialLog.cnnProductLostSerialNo = oldProductLostSerial.cnnSerialNo;
// EntityMapping.Create(productLostSerialLog, trans);
operLog.cndOperDate = dtSysTime;
operLog.cnvcComments = "生产产品报损调整，报损流水：" + oldls.cnnLostSerialNo.ToString() + "，产品编码：" + ls.cnvcInvCode;
EntityMapping.Create(operLog, trans);
trans.Commit();
}
catch (SqlException sex)
{
trans.Rollback();
LogAdapter.WriteDatabaseException(sex);
throw sex;
}
catch (Exception ex)
{
trans.Rollback();
LogAdapter.WriteFeaturesException(ex);
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
}
public int UpdateWareHouse(OperLog operLog, Entity.Warehouse wh)
{
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
string strSysTime = SqlHelper.ExecuteScalar(trans, CommandType.Text, "select getdate()").ToString();
DateTime dtSysTime = DateTime.Parse(strSysTime);
Entity.Warehouse oldwh = new AMSApp.zhenghua.Entity.Warehouse();
oldwh.cnvcWhCode = wh.cnvcWhCode;
oldwh = EntityMapping.Get(oldwh, trans) as AMSApp.zhenghua.Entity.Warehouse;
oldwh.cnvcWhName = wh.cnvcWhName;
oldwh.cnvcDepCode = wh.cnvcDepCode;
oldwh.cnvcWhAddress = wh.cnvcWhAddress;
oldwh.cnvcWhPhone = wh.cnvcWhPhone;
oldwh.cnvcWhPerson = wh.cnvcWhPerson;
oldwh.cnvcWhValueStyle = wh.cnvcWhValueStyle;
oldwh.cnbFreeze = wh.cnbFreeze;
oldwh.cnnFrequency = wh.cnnFrequency;
oldwh.cnvcFrequency = wh.cnvcFrequency;
oldwh.cnvcWhProperty = wh.cnvcWhProperty;
oldwh.cnbShop = wh.cnbShop;
EntityMapping.Update(oldwh, trans);
operLog.cndOperDate = dtSysTime;
operLog.cnvcComments = "仓库编码：" + oldwh.cnvcWhCode;
EntityMapping.Create(operLog, trans);
trans.Commit();
}
catch (SqlException sex)
{
trans.Rollback();
LogAdapter.WriteDatabaseException(sex);
return(-1);
}
catch (Exception ex)
{
trans.Rollback();
LogAdapter.WriteFeaturesException(ex);
return(-1);
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
return(1);
}
}
public void AddOrder(OrderBook orderBook, DataTable dtOrderBookDetail, OperLog operLog) //,BusiLog busiLog)
{
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
string strSysTime = SqlHelper.ExecuteScalar(trans, CommandType.Text, "select getdate()").ToString();
DateTime dtSysTime = DateTime.Parse(strSysTime);
OrderSerialNo serialNo = new OrderSerialNo();
serialNo.cnvcFill = "0";
serialNo.cnnSerialNo = Convert.ToDecimal(EntityMapping.Create(serialNo, trans));
orderBook.cnnOrderSerialNo = serialNo.cnnSerialNo;
orderBook.cndOrderDate = dtSysTime;
orderBook.cnvcOrderOperID = operLog.cnvcOperID;
EntityMapping.Create(orderBook, trans);
foreach (DataRow drOrderBookDetail in dtOrderBookDetail.Rows)
{
OrderBookDetail detail = new OrderBookDetail(drOrderBookDetail);
detail.cnnOrderSerialNo = serialNo.cnnSerialNo;
detail.cndOperDate = dtSysTime;
detail.cnvcOperID = operLog.cnvcOperID;
EntityMapping.Create(detail, trans);
}
operLog.cndOperDate = dtSysTime;
operLog.cnvcComments = "订单流水：" + orderBook.cnnOrderSerialNo;
EntityMapping.Create(operLog, trans);
trans.Commit();
}
catch (SqlException sex)
{
trans.Rollback();
LogAdapter.WriteDatabaseException(sex);
throw sex;
}
catch (Exception ex)
{
trans.Rollback();
LogAdapter.WriteFeaturesException(ex);
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
}
public void AdjustCheckSerial_Delete(CheckSerial CheckSerial, OperLog operLog) //,BusiLog busiLog)
{
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
string strSysTime = SqlHelper.ExecuteScalar(trans, CommandType.Text, "select getdate()").ToString();
DateTime dtSysTime = DateTime.Parse(strSysTime);
CheckSerial oldCheckSerial = EntityMapping.Get(CheckSerial, trans) as CheckSerial;
if (oldCheckSerial == null)
{
throw new Exception("未找到对应盘点流水的产品！");
}
oldCheckSerial.cnnReduceCount = CheckSerial.cnnReduceCount;
oldCheckSerial.cnvcOperID = operLog.cnvcOperID;
oldCheckSerial.cndOperDate = dtSysTime;
EntityMapping.Delete(oldCheckSerial, trans);
CheckSerialLog checkSerialLog = new CheckSerialLog(oldCheckSerial.ToTable());
checkSerialLog.cnnCheckSerialNo = oldCheckSerial.cnnSerialNo;
EntityMapping.Create(checkSerialLog, trans);
operLog.cndOperDate = dtSysTime;
operLog.cnvcComments = "盘点删除，盘点流水：" + oldCheckSerial.cnnSerialNo.ToString() + "，产品编码：" + CheckSerial.cnvcCode;
EntityMapping.Create(operLog, trans);
trans.Commit();
}
catch (SqlException sex)
{
trans.Rollback();
LogAdapter.WriteDatabaseException(sex);
throw sex;
}
catch (Exception ex)
{
trans.Rollback();
LogAdapter.WriteFeaturesException(ex);
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
}
public static void UpdatePwd(Oper oper)
{
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
string strSysTime = SqlHelper.ExecuteScalar(trans, CommandType.Text, "select getdate()").ToString();
DateTime dtSysTime = DateTime.Parse(strSysTime);
Oper oldOper = new Oper();
oldOper.cnvcOperID = oper.cnvcOperID;
oldOper = EntityMapping.Get(oldOper, trans) as Oper;
if (null == oldOper)
{
throw new Exception("无此用户");
}
oldOper.cnvcOperPwd = oper.cnvcOperPwd; //DataSecurity.Encrypt(oper.cnvcOperPwd);
EntityMapping.Update(oldOper, trans);
BusiLog busiLog = new BusiLog();
busiLog.cndOperDate = dtSysTime;
busiLog.cnnBusiSerialNo = Helper.GetSerialNo(trans);
busiLog.cnvcComments = "修改密码";
busiLog.cnvcFuncCode = "修改密码";
busiLog.cnvcOperID = oper.cnvcOperID;
busiLog.cnvcIPAddress = "";
EntityMapping.Create(busiLog, trans);
trans.Commit();
}
catch (SqlException sex)
{
trans.Rollback();
LogAdapter.WriteDatabaseException(sex);
throw sex;
}
catch (Exception ex)
{
trans.Rollback();
LogAdapter.WriteFeaturesException(ex);
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
}
public void AddCard(Oper opers)
{
try
{
conn = ConnectionPool.BorrowConnection();
trans = conn.BeginTransaction();
DataTable dtOper = SqlHelper.ExecuteDataTable(trans, CommandType.Text, "select * from tbOper where cnvcCardNo is not null and cnvcCardNo = 'aaa" + opers.cnvcCardNo + "'");
if (dtOper.Rows.Count > 0)
{
throw new BusinessException("操作员管理", "操作员卡号已存在！");
}
CardM1 m1 = new CardM1();
string strReturn = m1.PutOutCard("aaa" + opers.cnvcCardNo);
if (strReturn.Equals("OPSUCCESS"))
{
SqlHelper.ExecuteNonQuery(trans, CommandType.Text, "update tbOper set cnvcCardNo = 'aaa" + opers.cnvcCardNo + "' where cnnOperID=" + opers.cnnOperID.ToString());
trans.Commit();
}
else
{
throw new BusinessException("卡操作异常", strReturn);
}
}
catch (BusinessException bex) //业务异常
{
//LogAdapter.WriteBusinessException(bex);
trans.Rollback();
throw new BusinessException(bex.Type, bex.Message);
}
catch (SqlException sex) //数据库异常
{
//事务回滚
trans.Rollback();
//LogAdapter.WriteDatabaseException(sex);
throw new BusinessException("数据库异常", sex.Message);
}
catch (Exception ex) //其他异常
{
//事务回滚
trans.Rollback();
//LogAdapter.WriteFeaturesException(ex);
throw new BusinessException("其它异常", ex.Message);
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}