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