///<summary> /// 输入条件返回结果查询 /// </summary> /// <param name="tableid">SQL查询条件</param> /// <returns>存放查询结果的DataTable</returns> public string GetBillName(string flag) { CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql); try { DataTable dtl = new DataTable(); string StrSQL = " select OrderName from BillAutoID where Flag='" + flag + "'"; dtl = pComm.ExeForDtl(StrSQL); pComm.Close(); if (dtl.Rows.Count > 0) { return(dtl.Rows[0]["OrderName"].ToString()); } else { return(""); } } 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> /// <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; } }
//------------------------------------------------------------------------ //调用存储过程,得到某个物料的在指定仓库中的数量 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="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> public bool Update() { StringBuilder strSql = new StringBuilder(); strSql.Append("update Supplier 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(" 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; } }
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; } }
/// <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; } }
/// <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="tableid">SQL查询条件</param> /// <returns>存放查询结果的DataTable</returns> public void SaveUserRightGroup(List <string> lstUser, List <string> lstgroup) { string StrSQL = ""; CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql); try { pComm.BeginTrans(); for (int i = 0; i < lstUser.Count; i++) { //先删除此用户原来属于的权限组 StrSQL = "delete from UserRightGroup where UserID='" + lstUser[i] + "'"; pComm.Execute(StrSQL); //再添加此用户的权限组 for (int j = 0; j < lstgroup.Count; j++) { StrSQL = " insert into UserRightGroup(UserID,GroupID) values('" + lstUser[i] + "','" + lstgroup [j] + "')"; pComm.Execute(StrSQL); } } pComm.CommitTrans(); pComm.Close(); } catch (Exception e) { pComm.RollbackTrans(); pComm.Close(); throw e; } }
///<summary> ///删除数据 /// </summary> /// <param name="pObj">信息集实体类</param> /// <returns>返回保存成功(true)或失败(false)</returns> public void DeleteBill(string ExcessOrderguid) { CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql); try { pComm.BeginTrans(); //保存单据主表数据 //先删除主表数据 string strDeleteSql = "Delete from ExcessOrder where ExcessOrderGuid='" + ExcessOrderguid + "'"; pComm.Execute(strDeleteSql); //删除明细表 strDeleteSql = "Delete from ExcessOrderDetail where ExcessOrderGuid='" + ExcessOrderguid + "'"; pComm.Execute(strDeleteSql); pComm.CommitTrans(); } catch (Exception e) { pComm.RollbackTrans(); pComm.Close(); throw e; } }
/// <summary> /// 删除 /// </summary> /// <returns></returns> public void DeleteRemoveBill(string RemoveBillGuid) { CommonInterface pObj_Comm = CommonFactory.CreateInstance(CommonData.sql); try { pObj_Comm.BeginTrans(); //删除主表 string ps_Sql = "delete from RemoveBill where RemoveBillGuid='" + RemoveBillGuid + "'"; pObj_Comm.Execute(ps_Sql); //删除明细表 ps_Sql = "delete from RemoveBillDetail where RemoveBillGuid='" + RemoveBillGuid + "'"; pObj_Comm.Execute(ps_Sql); pObj_Comm.CommitTrans(); pObj_Comm.Close(); } catch (Exception e) { pObj_Comm.RollbackTrans(); pObj_Comm.Close(); throw e; } }
/// <summary> /// 得到订单是否已审核或已结单 /// </summary> /// <param name="FatherMaterialGuid"></param> /// <returns></returns> public bool GetIsCheck(string InitialGoodsGuid) { string ps_Sql = ""; DataTable pDTMain = new DataTable(); CommonInterface pObj_Comm = CommonFactory.CreateInstance(CommonData.sql); try { ps_Sql = " select InitialGoodsGuid,CheckGuid from InitialGoods where InitialGoodsGuid='" + InitialGoodsGuid + "' "; 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; } }
private void button1_Click(object sender, EventArgs e) { string sDateFrom = dtpDateFrom.Value.ToString("yyyy-MM-dd"); string sDateTo = dtpDateTo.Value.ToString("yyyy-MM-dd"); string sDept = "%" + txtDeptName.Text.Trim() + "%"; string[] _Parameters = new string[4] { "as_datefrom", "as_dateto", "an_deptid", "aors" }; string[] _ParametersValue = new string[4] { sDateFrom, sDateTo, sDept, "" }; string[] _ParametersType = new string[4] { "Varchar2", "Varchar2", "Varchar2", "RefCursor" }; string[] _ParametersDirection = new string[4] { "Input", "Input", "Input", "Output" }; CommonInterface pObj_Comm = CommonFactory.CreateInstance(CommonData.Oracle); try { DataTable pDTMain = pObj_Comm.ExecuteSPSursor("CX_SALE.cur_fin_dept_capital", _Parameters, _ParametersValue, _ParametersType, _ParametersDirection).Tables[0]; gridControl1.DataSource = pDTMain; pObj_Comm.Close(); } catch (Exception ex) { pObj_Comm.Close(); throw ex; } }
/// <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; } }
/// <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; } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add() { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [Supplier]("); strSql.Append("Guid,Name,SimpName,LinkMan,Telephone,Fax,Address,Zip,Remark"); 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(")"); 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="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> 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; } }
/// <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="pObj">信息集实例</param> /// <returns>返回True或False</returns> public bool SaveStatus(Material pObj) { CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql); try { string pSql = ""; pSql = "SELECT MaterialGuid FROM Material " + "where MaterialGuid ='" + pObj.MaterialGuID + "'"; 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> /// <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> /// <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> /// <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> /// <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> /// <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; } }
//根据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 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> /// <param name="FatherMaterialGuid"></param> /// <returns></returns> public string GetMaterialByRejectOrderDetailGuid(string RejectOrderDetailGuid) { string ps_Sql = ""; DataTable pDTMain = new DataTable(); CommonInterface pObj_Comm = CommonFactory.CreateInstance(CommonData.sql); try { ps_Sql = "select MaterialGuid from RejectOrderDetail where RejectOrderDetailGuid='" + RejectOrderDetailGuid + "'"; 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> /// 得到生产领料计划单中的母件Guid /// </summary> /// <param name="FatherMaterialGuid"></param> /// <returns></returns> public string GetDrawPlanFatherMaterialGuid(string DrawPlanGuid) { string returnvalue = ""; string ps_Sql = ""; DataTable pDTMain = new DataTable(); CommonInterface pObj_Comm = CommonFactory.CreateInstance(CommonData.sql); try { ps_Sql = " select top 1 MaterialGuid from DrawPlanDetail where DrawPlanGuid='" + DrawPlanGuid + "'"; pDTMain = pObj_Comm.ExeForDtl(ps_Sql); pObj_Comm.Close(); if (pDTMain.Rows.Count > 0) { returnvalue = pDTMain.Rows[0]["MaterialGuid"].ToString().Trim(); } else { returnvalue = ""; } return(returnvalue); } catch (Exception e) { pObj_Comm.Close(); throw e; } }