/// <summary> /// 收发存汇总表 /// </summary> /// <param name="strsql"></param> /// <returns></returns> public DataTable sp_GetInOutStorageSum(string strbegindate, string strenddate, string MaterialGuid, string StorageID, string MaterialTypeGuid, string SupplierGuid) { CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql); try { DataSet dset = new DataSet(); string[,] par; par = new string[6, 2]; par[0, 0] = "@BeginDate"; par[0, 1] = strbegindate; par[1, 0] = "@EndDate"; par[1, 1] = strenddate; par[2, 0] = "@MaterialGuid"; par[2, 1] = MaterialGuid; par[3, 0] = "@StorageID"; par[3, 1] = StorageID; par[4, 0] = "@MaterialTypeGuid"; par[4, 1] = MaterialTypeGuid; par[5, 0] = "@Supplier"; par[5, 1] = SupplierGuid; dset = pComm.ExcuteSp("sp_GetInOutStorageSum", par); pComm.Close(); return(dset.Tables[0]); } catch (Exception e) { pComm.Close(); throw e; } }
/// <summary> /// 得到员工所在部门 /// </summary> /// <param name="EmpGuid"></param> public string GetEmpGuIDByEmpName(string EmpName) { CommonInterface pObj_Comm = CommonFactory.CreateInstance(CommonData.sql); try { string ps_Sql = "select EmpGuid from Employee where EmpName='" + EmpName + "'"; DataTable dtl = new DataTable(); dtl = pObj_Comm.ExeForDtl(ps_Sql); pObj_Comm.Close(); if (dtl.Rows.Count > 0) { return(dtl.Rows[0]["EmpGuid"].ToString()); } else { return(""); } } catch (Exception e) { pObj_Comm.Close(); throw e; } }
/// <summary> /// 更新审核状态度 /// </summary> /// <returns></returns> public void ChcekCheckBill(string CheckBillGuid, int pass) { CommonInterface pObj_Comm = CommonFactory.CreateInstance(CommonData.sql); try { string ps_Sql = ""; //删除主表 if (pass == 1) { //通过 ps_Sql = "update CheckBill set CheckPerson='" + SysParams.UserName + "',CheckDate='" + DateTime.Now.ToString() + "' where CheckBillGuid='" + CheckBillGuid + "'"; } else { //不通过 ps_Sql = "update CheckBill set CheckPerson='',CheckDate=null where CheckBillGuid='" + CheckBillGuid + "'"; } pObj_Comm.Execute(ps_Sql); pObj_Comm.Close(); } catch (Exception e) { pObj_Comm.Close(); throw e; } }
/// <summary> /// 得到采购订单主表数据 /// </summary> /// <param name="FatherMaterialGuid"></param> /// <returns></returns> public string GetMaterialByStockOrderDetailGuid(string StockOrderDetailGuid) { string ps_Sql = ""; DataTable pDTMain = new DataTable(); CommonInterface pObj_Comm = CommonFactory.CreateInstance(CommonData.sql); try { ps_Sql = "select MaterialGuid from StockOrderDetail where StockOrderDetailGuid='" + StockOrderDetailGuid + "'"; pDTMain = pObj_Comm.ExeForDtl(ps_Sql); pObj_Comm.Close(); if (pDTMain.Rows.Count > 0) { return(pDTMain.Rows[0]["MaterialGuid"].ToString().Trim()); } else { return(""); } } catch (Exception e) { pObj_Comm.Close(); throw e; } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add() { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [Client]("); strSql.Append("Guid,Name,SimpName,LinkMan,Telephone,Fax,Address,Zip,Remark,ProductName,SellType,IsEnable"); strSql.Append(")"); strSql.Append(" values ("); strSql.Append("'" + Guid + "',"); strSql.Append("'" + Name + "',"); strSql.Append("'" + SimpName + "',"); strSql.Append("'" + LinkMan + "',"); strSql.Append("'" + Telephone + "',"); strSql.Append("'" + Fax + "',"); strSql.Append("'" + Address + "',"); strSql.Append("'" + Zip + "',"); strSql.Append("'" + Remark + "',"); strSql.Append("'" + ProductName + "',"); strSql.Append("'" + SellType + "',"); strSql.Append("" + IsEnable.ToString() + ""); strSql.Append(")"); CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql); try { pComm.Execute(strSql.ToString());//执行Sql语句无返回值 pComm.Close(); return(true); } catch (System.Exception e) { pComm.Close(); throw e; } }
/// <summary> /// 更新审核状态度-二级审核 /// </summary> /// <returns></returns> public void CheckBill2(string RejectOrderGuid, int pass) { CommonInterface pObj_Comm = CommonFactory.CreateInstance(CommonData.sql); try { string ps_Sql = ""; //删除主表 if (pass == 1) { //通过 ps_Sql = "update RejectOrder set CheckGuid2='" + SysParams.UserID + "',CheckDate2='" + DateTime.Now.ToString() + "' where RejectOrderGuid='" + RejectOrderGuid + "'"; } else { //不通过 ps_Sql = "update RejectOrder set CheckGuid2='',CheckDate2=null where RejectOrderGuid='" + RejectOrderGuid + "'"; } pObj_Comm.Execute(ps_Sql); pObj_Comm.Close(); } catch (Exception e) { pObj_Comm.Close(); throw e; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update() { StringBuilder strSql = new StringBuilder(); strSql.Append("update Material set "); strSql.Append("UpperLimit=" + UpperLimit + ","); strSql.Append("LowerLimit=" + LowerLimit + ","); strSql.Append("IConsultPrice=" + IConsultPrice + ","); strSql.Append("EConsultPrice=" + EConsultPrice + ","); strSql.Append("CalculateMethod='" + CalculateMethod + "',"); strSql.Append("Remark='" + Remark + "',"); strSql.Append("MaterialId='" + MaterialId + "',"); strSql.Append("MaterialName='" + MaterialName + "',"); strSql.Append("ClassId='" + ClassId + "',"); strSql.Append("Spec='" + Spec + "',"); strSql.Append("Unit='" + Unit + "',"); strSql.Append("BarNo='" + BarNo + "',"); strSql.Append("Place='" + Place + "',"); strSql.Append("Encapsulation='" + Encapsulation + "'"); strSql.Append(" where MaterialGuid='" + MaterialGuid + "' "); CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql); try { pComm.Execute(strSql.ToString());//执行Sql语句无返回值 pComm.Close(); return(true); } catch (System.Exception e) { pComm.Close(); throw e; } }
/// <summary> /// 判断此货品是否已被使用 /// </summary> /// <returns></returns> public bool IsUseMaterial(string MaterialGuid) { CommonInterface pObj_Comm = CommonFactory.CreateInstance(CommonData.sql); string strSql = " select MaterialGuid from ( select MaterialGuid from BillDetail " + " union select MaterialGuid from CheckBillDetail " + " union " + " select MaterialGuid from RemoveBillDetail) M where M.MaterialGuid='" + MaterialGuid + "'"; try { DataTable dt = pObj_Comm.ExeForDtl(strSql); pObj_Comm.Close(); if (dt.Rows.Count > 0) { return(true); } else { return(false); } } catch (Exception e) { pObj_Comm.Close(); throw e; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update() { StringBuilder strSql = new StringBuilder(); strSql.Append("update Dept set "); strSql.Append("DeptName='" + DeptName + "',"); strSql.Append("DeptPerson='" + DeptPerson + "',"); strSql.Append("Telephone='" + Telephone + "',"); strSql.Append("Fax='" + Fax + "',"); strSql.Append("Address='" + Address + "'"); strSql.Append(" where DeptGuid='" + DeptGuid + "' "); CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql); try { pComm.Execute(strSql.ToString());//执行Sql语句无返回值 pComm.Close(); return(true); } catch (System.Exception e) { pComm.Close(); throw e; } }
/// <summary> /// 得到所有产品类另信息 /// </summary> /// <returns>pDTMain 字段信息集</returns> public DataTable GetMaterialDataByClassID(string classid) { string ps_Sql = ""; DataTable pDTMain = new DataTable(); CommonInterface pObj_Comm = CommonFactory.CreateInstance(CommonData.sql); try { if (classid != "") { ps_Sql = "select MaterialGuid,(select InterName from StorageClass where InterId=ClassId) as 货品分类,MaterialId as 货号,MaterialName as 品名,Spec as 规格,BarNo as 助查码," + "Unit as 单位,CalculateMethod as 成本核算法,remark as 备注 from Material where ClassId='" + classid + "' order by MaterialId"; } else { ps_Sql = "select MaterialGuid,(select InterName from StorageClass where InterId=ClassId) as 货品分类,MaterialId as 货号,MaterialName as 品名,Spec as 规格,BarNo as 助查码," + "Unit as 单位,CalculateMethod as 成本核算法,remark as 备注 from Material order by MaterialId"; } pDTMain = pObj_Comm.ExeForDtl(ps_Sql); pObj_Comm.Close(); return(pDTMain); } catch (Exception e) { pObj_Comm.Close(); throw e; } }
/// <summary> /// 是否已经存在相同的货品 /// </summary> /// <returns></returns> public bool IsExistMaterial(string Classid, string MaterialName, string MaterialID, string BarNo, string Spec, string Place, string Unit) { CommonInterface pObj_Comm = CommonFactory.CreateInstance(CommonData.sql); string strSql = " select MaterialGuid from Material where ClassId='" + Classid + "' and MaterialName='" + MaterialName + "' " + " and MaterialID='" + MaterialID + "' and BarNo='" + BarNo + "' and Spec='" + Spec + "' and Place='" + Place + "' and Unit='" + Unit + "'"; try { DataTable dt = pObj_Comm.ExeForDtl(strSql); pObj_Comm.Close(); if (dt.Rows.Count > 0) { return(true); } else { return(false); } } catch (Exception e) { pObj_Comm.Close(); throw e; } }
/// <summary> /// 采购入库单是否已开票报表(已勾结,未勾结) /// </summary> /// <param name="strsql"></param> /// <returns></returns> public DataTable sp_GetStockInOrderStatus_Report(string StockInOrderID, string strbegindate, string strenddate, string SupplierGuid, string IsInvoice) { CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql); try { DataSet dset = new DataSet(); string[,] par; par = new string[5, 2]; par[0, 0] = "@StockInOrderID"; par[0, 1] = StockInOrderID; par[1, 0] = "@BeginDate"; par[1, 1] = strbegindate; par[2, 0] = "@EndDate"; par[2, 1] = strenddate; par[3, 0] = "@SupplierGuid"; par[3, 1] = SupplierGuid; par[4, 0] = "@IsInvoice"; par[4, 1] = IsInvoice; dset = pComm.ExcuteSp("sp_GetStockInOrderStatus", par); pComm.Close(); return(dset.Tables[0]); } catch (Exception e) { pComm.Close(); throw e; } }
/// <summary> /// 采购付款单报表 /// </summary> /// <param name="strsql"></param> /// <returns></returns> public DataTable sp_Payment_Report(string strbegindate, string strenddate) { CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql); try { DataSet dset = new DataSet(); string[,] par; par = new string[2, 2]; par[0, 0] = "@BeginDate"; par[0, 1] = strbegindate; par[1, 0] = "@EndDate"; par[1, 1] = strenddate; dset = pComm.ExcuteSp("sp_Payment_Report", par); pComm.Close(); return(dset.Tables[0]); } catch (Exception e) { pComm.Close(); throw e; } }
/// <summary> /// 库存报表 /// </summary> /// <param name="MaterialGuid"></param> /// <param name="StorageID"></param> /// <param name="MaterialTypeGuid"></param> /// <param name="EndDate"></param> /// <returns></returns> public DataTable StockReport(string MaterialGuid, string StorageID, string MaterialTypeGuid, string EndDate) { CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql); try { DataSet dset = new DataSet(); string[,] par; par = new string[4, 2]; par[0, 0] = "@MaterialGuid"; par[0, 1] = MaterialGuid; par[1, 0] = "@StorageID"; par[1, 1] = StorageID; par[2, 0] = "@MaterialTypeGuid"; par[2, 1] = MaterialTypeGuid; par[3, 0] = "@EndDate"; par[3, 1] = EndDate; dset = pComm.ExcuteSp("sp_GetStorageReport", par); pComm.Close(); return(dset.Tables[0]); } catch (Exception e) { pComm.Close(); throw e; } }
//判断规格是否已经存在 public bool IsExistUnit(string flag, string strValue) { CommonInterface pObj_Comm = CommonFactory.CreateInstance(CommonData.sql); try { string ps_Sql = "select UnitName from BasicData where Flag=" + flag + " and UnitName='" + strValue + "'"; DataTable pDTMain = pObj_Comm.ExeForDtl(ps_Sql); pObj_Comm.Close(); if (pDTMain.Rows.Count > 0) { return(true); } else { return(false); } } catch (Exception e) { pObj_Comm.Close(); throw e; } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add() { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [Dept]("); strSql.Append("DeptGuid,DeptName,DeptPerson,Telephone,Fax,Address"); strSql.Append(")"); strSql.Append(" values ("); strSql.Append("'" + DeptGuid + "',"); strSql.Append("'" + DeptName + "',"); strSql.Append("'" + DeptPerson + "',"); strSql.Append("'" + Telephone + "',"); strSql.Append("'" + Fax + "',"); strSql.Append("'" + Address + "'"); strSql.Append(")"); CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql); try { pComm.Execute(strSql.ToString());//执行Sql语句无返回值 pComm.Close(); return(true); } catch (System.Exception e) { pComm.Close(); throw e; } }
//根据ID得到基础数据的名称 public string GetBasicDataNameByUnitID(string strID) { CommonInterface pObj_Comm = CommonFactory.CreateInstance(CommonData.sql); try { string ps_Sql = "select top 1 UnitName from BasicData where IsDelete=0 and UnitID=" + strID; DataTable pDTMain = pObj_Comm.ExeForDtl(ps_Sql); pObj_Comm.Close(); if (pDTMain.Rows.Count > 0) { return(pDTMain.Rows[0]["UnitName"].ToString()); } else { return(""); } } catch (Exception e) { pObj_Comm.Close(); throw e; } }
/// <summary> /// 得到一个对象实体 /// </summary> public bool IsOperateRight(string UserID, string ModuleID) { string strsql = " select " + ModuleID + " from UserRight where userid='" + UserID + "'"; CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql); try { DataTable dtl = new DataTable(); dtl = pComm.ExeForDtl(strsql.ToString()); pComm.Close(); if (dtl.Rows[0][ModuleID].ToString() == "1") { return(true); } else { return(false); } } catch (Exception e) { pComm.Close(); throw e; } }
public string OperData(string StoredProcedureName, string[] Parameters, string[] ParametersValue, string[] ParametersType, string[] ParametersDirection) { /*string[] _Parameters = new string[4] { "as_datefrom", "as_dateto", "an_deptid", "aors" }; * string[] _ParametersValue = new string[4] { sDateFrom, sDateTo, "24", "" }; * string[] _ParametersType = new string[4] { "Varchar2", "Varchar2", "Varchar2", "RefCursor" }; * string[] _ParametersDirection = new string[4] { "Input", "Input", "Input", "Output" }; */ string iResult; CommonInterface pObj_Comm = CommonFactory.CreateInstance(CommonData.Oracle); try { iResult = pObj_Comm.ExecuteSP(StoredProcedureName, Parameters, ParametersValue, ParametersType, ParametersDirection); pObj_Comm.Close(); return(iResult); } catch (Exception ex) { pObj_Comm.Close(); throw ex; } }
public DataTable GetMaterial(string MaterialGuid) { CommonInterface pObj_Comm = CommonFactory.CreateInstance(CommonData.sql); StringBuilder strSql = new StringBuilder(); strSql.Append("select MaterialGuid ,MaterialId,MaterialName, ClassId," + " (select InterName from StorageClass where InterId=ClassId) as ClassInterName,Unit," + " (select UnitName from BasicData where UnitID=Unit ) as UnitInterName,Spec," + " (select UnitName from BasicData where UnitID=Spec ) as SpecInterName," + " SafeStockSum ,CalculateMethod,Price,PicID,ClientID,SupplierGuid," + " (select Name from Supplier where Guid=SupplierGuid) as SupplierName, " + " (select UnitName from BasicData where UnitID=CalculateMethod ) as CalculateMethodInterName, " + " Place ,IsEnable,Remark "); //strSql.Append("[MaterialGuid],[MaterialId],[MaterialName],[ClassId],[Unit],[Spec],[SafeStockSum],[CalculateMethod],[Place],[IsEnable],[Remark] "); strSql.Append(" from Material "); strSql.Append(" where MaterialGuid='" + MaterialGuid + "'"); try { Material Material = new Material(); DataTable dt = pObj_Comm.ExeForDtl(strSql.ToString()); pObj_Comm.Close(); return(dt); } catch (Exception e) { pObj_Comm.Close(); throw e; } }
private void DataLoad() { string SqlOraStr = "SELECT * FROM T_DELIVERY_ROUTES WHERE DEPTID = 2 AND NVL(VALIDATED,0) =1 "; CommonInterface pObj_Comm = CommonFactory.CreateInstance(CommonData.Oracle); try { pDTMain = pObj_Comm.ExeForDtl(SqlOraStr); pObj_Comm.Close(); if (pDTMain.Rows.Count != 0) //&&(myDs.Tables[0] !=null) { LoadParentTree(pDTMain); } else { MessageBox.Show("没有菜单!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Hand, MessageBoxDefaultButton.Button1); } } catch (Exception ex) { pObj_Comm.Close(); throw ex; } }
//------------------------------------------------------------------------ //调用存储过程,得到某个物料的在指定仓库中的数量 public DataTable sp_GetOneStorageSumData(string StorageID, string Materialguid) { CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql); try { DataSet dset = new DataSet(); string[,] par; par = new string[2, 2]; par[0, 0] = "@StorageID"; par[0, 1] = StorageID; par[1, 0] = "@MaterialGuid"; par[1, 1] = Materialguid; dset = pComm.ExcuteSp("sp_GetOneStorageSumData", par); pComm.Close(); return(dset.Tables[0]); } catch (Exception e) { pComm.Close(); throw e; } }
/// <summary> /// 得到订单是否已审核或已结单 /// </summary> /// <param name="FatherMaterialGuid"></param> /// <returns></returns> public bool GetIsCheck(string HalfGoodsGuid) { string ps_Sql = ""; DataTable pDTMain = new DataTable(); CommonInterface pObj_Comm = CommonFactory.CreateInstance(CommonData.sql); try { ps_Sql = " select HalfGoodsGuid,CheckGuid from HalfGoods where HalfGoodsGuid='" + HalfGoodsGuid + "' "; pDTMain = pObj_Comm.ExeForDtl(ps_Sql); pObj_Comm.Close(); if (pDTMain.Rows.Count > 0) { if (pDTMain.Rows[0]["CheckGuid"].ToString().Trim() != "") { return(true); } return(false); } else { return(true); } } catch (Exception e) { pObj_Comm.Close(); throw e; } }
///<summary> /// 是否执行出库数量预警 /// </summary> /// <param name="pObj">信息集实例</param> /// <returns>返回True或False</returns> public bool OverNumStorage(string StorageID) { CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql); try { string pSql = ""; pSql = "SELECT OverNumStorage FROM YJ "; DataTable pDT = pComm.ExeForDtl(pSql); pComm.Close(); if (pDT.Rows.Count > 0) { //判断当前传入仓库是否开启了预警,OverNumStorage值为 25:26:27:37:38:69:343,中间的数字就是仓库的编号 if (pDT.Rows[0]["OverNumStorage"].ToString().IndexOf(StorageID) >= 0) { return(true); } else { return(false); } } else { return(true); } } catch (Exception e) { pComm.Close(); return(true); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update() { StringBuilder strSql = new StringBuilder(); strSql.Append("update Client set "); strSql.Append("Name='" + Name + "',"); strSql.Append("SimpName='" + SimpName + "',"); strSql.Append("LinkMan='" + LinkMan + "',"); strSql.Append("Telephone='" + Telephone + "',"); strSql.Append("Fax='" + Fax + "',"); strSql.Append("Address='" + Address + "',"); strSql.Append("Zip='" + Zip + "',"); strSql.Append("Remark='" + Remark + "',"); strSql.Append("SellType='" + SellType + "',"); strSql.Append("ProductName='" + ProductName + "',"); strSql.Append("IsEnable=" + IsEnable.ToString() + ""); strSql.Append(" where Guid='" + Guid + "' "); CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql); try { pComm.Execute(strSql.ToString());//执行Sql语句无返回值 pComm.Close(); return(true); } catch (System.Exception e) { pComm.Close(); throw e; } }
///<summary> /// 判断是否开启了单据删除时如有别的单据使用此单据的提醒 /// </summary> /// <param name="pObj">信息集实例</param> /// <returns>返回True或False</returns> public bool OrderDeleteAlert() { CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql); try { string pSql = ""; pSql = "SELECT OrderDeleteAlert FROM YJ "; DataTable pDT = pComm.ExeForDtl(pSql); pComm.Close(); if (pDT.Rows.Count > 0) { //判断是否开启了单据删除时如有别的单据使用此单据的提醒 if (pDT.Rows[0]["OrderDeleteAlert"].ToString() == "1") { return(true); } else { return(false); } } else { return(true); } } catch (Exception e) { pComm.Close(); return(true); } }
/// <summary> /// 删除 /// </summary> /// <returns></returns> public void DeleteCheckBill(string CheckBillGuid) { CommonInterface pObj_Comm = CommonFactory.CreateInstance(CommonData.sql); try { pObj_Comm.BeginTrans(); //删除主表 string ps_Sql = "delete from CheckBill where CheckBillGuid='" + CheckBillGuid + "'"; pObj_Comm.Execute(ps_Sql); //删除明细表 ps_Sql = "delete from CheckBillDetail where CheckBillGuid='" + CheckBillGuid + "'"; pObj_Comm.Execute(ps_Sql); pObj_Comm.CommitTrans(); pObj_Comm.Close(); } catch (Exception e) { pObj_Comm.RollbackTrans(); pObj_Comm.Close(); throw e; } }
/// <summary> /// 得到所有产品类另信息 /// </summary> /// <returns>pDTMain 字段信息集</returns> public DataTable GetMaterialData_CN(string strsql) { string ps_Sql = ""; DataTable pDTMain = new DataTable(); CommonInterface pObj_Comm = CommonFactory.CreateInstance(CommonData.sql); try { ps_Sql = " select 'False' as selectvalue,MaterialGuid ,MaterialId as 物料编号,MaterialName 物料名称, " + " (select InterName from StorageClass where InterId=ClassId) as 分类," + " (select UnitName from BasicData where UnitID=Unit ) as 单位," + " (select UnitName from BasicData where UnitID=Spec ) as 规格型号," + " Price as 单价, " + "case when IsEnable=1 then '停用' else '正常' end as 状态,PicID as 图号,ClientID as 客户编号," + " (select Name from Supplier where Guid=SupplierGuid) as 供应商, " + " Remark as 备注 from Material " + strsql + " order by MaterialId"; //ps_Sql = "select MaterialGuid,(select InterName from StorageClass where InterId=ClassId) as 货品分类,MaterialId as 货号,MaterialName as 品名,Spec as 规格,BarNo as 助查码," // + "Unit as 单位,CalculateMethod as 成本核算法,remark as 备注 from Material " + strsql + " order by MaterialId"; pDTMain = pObj_Comm.ExeForDtl(ps_Sql); pObj_Comm.Close(); return(pDTMain); } catch (Exception e) { pObj_Comm.Close(); throw e; } }
///<summary> /// 得到当前是新增状态还是修改状态 /// </summary> /// <param name="pObj">信息集实例</param> /// <returns>返回True或False</returns> public bool SaveStatus(Client pObj) { CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql); try { string pSql = ""; pSql = "SELECT Guid FROM Client " + "where Guid ='" + pObj.Guid + "'"; DataTable pDT = pComm.ExeForDtl(pSql); pComm.Close(); if (pDT.Rows.Count > 0) { return(true); } else { return(false); } } catch (Exception e) { pComm.Close(); throw e; } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add() { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into LOGINUSER("); strSql.Append("USERID,USERNAME,EMAIL,PASSWORD,IsEnable"); strSql.Append(")"); strSql.Append(" values ("); strSql.Append("'" + USERID + "',"); strSql.Append("'" + USERNAME + "',"); strSql.Append("'" + EMAIL + "',"); strSql.Append("'" + PASSWORD + "',"); strSql.Append("" + IsEnable.ToString() + ""); strSql.Append(")"); CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql); try { pComm.Execute(strSql.ToString());//执行Sql语句无返回值 pComm.Close(); return(true); } catch (System.Exception e) { pComm.Close(); throw e; } }