using System; using System.Collections.Generic; using System.Text; using System.Data; namespace DAL { public class ClsSc_PPBomChange_K3:DBUtility.ClsXt_BaseBill { public Model.ClsSc_PPBomChangeMain_K3 omodel = new Model.ClsSc_PPBomChangeMain_K3(); public List DetailColl = new List(); public ClsSc_PPBomChange_K3() { base.MvarItemKeySub = "PPBomChangeEntry"; base.MvarItemKeySub2 = ""; base.MvarItemKeySub3 = ""; base.MvarItemKeySub4 = ""; base.MvarItemKey="PPBomChange"; base.MvarReportTitle="生产投料变更单"; base.BillType = "1002502"; } #region 固定代码 ~ClsSc_PPBomChange_K3() { DetailColl = null; } #endregion 自定义方法 //修改单据 public override bool ModifyBill(Int64 lngBillKey, ref string sReturn) { try { //得到用户ID DataSet DsBiller; DsBiller = oK3Cn.RunProcReturn("select top 1 fuserid from t_User where fname='" + DBUtility.ClsPub.CurUserName + "'", "t_User"); if (DsBiller.Tables[0].Rows.Count != 0) { omodel.FBillerID = DBUtility.ClsPub.isLong(DsBiller.Tables[0].Rows[0][0]); } else { omodel.FBillerID = 16394; } omodel.HBillType = this.BillType; // //DataSet Ds1; oCnK3.BeginTran(); omodel.HInterID = lngBillKey; //删除主表 DeleteBill(lngBillKey, ref sReturn); //oCnK3.RunProc("Delete From PPBomChange where FInterID=" + lngBillKey.ToString()); // //插入子表 foreach (Model.ClsSc_PPBomChangeSub_K3 oSub in DetailColl) { oCnK3.RunProc("INSERT INTO PPBomChangeEntry (" + "FID,FIndex,FICMOInterID,FICMOInterBN,FProductItemID" + ",FUnitID,FAuxQty,FPPBomBillNo,FPPBomEntryID,FChangeFlag" + ",FChangeReason,FItemID,FBomInterID,FMaterielType,FAuxQtyScrap" + ",FItemUnitID,FBOMInPutAuxQTY,FScrap,FAuxQtyLoss,FAuxQtyPick" + ",FAuxQtyMust,FSendItemDate,FStockID,FSPID,FBatchNo,FBackFlush" + ",FOperSN,FOperID,FMachinePos,FAuxStockQty,FPPBOMInterID" + ",FDiscardAuxQty,FLockFlag,FAuxQtySupply,FChangerID,FChangeDate" + ",FMark,FQty,FQtyScrap,FBOMInPutQTY,FQtyLoss,FQtyPick" + ",FQtyMust,FStockQty,FDiscardQty,FQtySupply,FClassID_SRC" + ",FPositionNo,FItemSize,FItemSuite,FNote1,FNote2,FNote3,FPlanMode" + //",FMTONo,FOrderEntryID,FIsRepItem,FICSubsID"+ //",FICSubsEntryID,FIsKeyItem,FPriorityID"+ ") Values (" + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + "," + oSub.FICMOInterID.ToString() + ",'" + oSub.FICMOInterBN + "'," + oSub.FProductItemID.ToString() + "," + oSub.FProductUnitID.ToString() + "," + oSub.FAuxQty.ToString() + ",'" + oSub.FPPBomBillNo.ToString() + "'," + oSub.FPPBomEntryID.ToString() + ",'" + oSub.FChangeFlag.ToString() + "',''," + oSub.FItemID.ToString() + "," + oSub.FBomInterID.ToString() + ",'" + oSub.FMaterielType.ToString() + "'," + oSub.FQtyScrap.ToString() + "," + oSub.FUnitID.ToString() + "," + oSub.FBOMInPutAuxQTY.ToString() + ",0,0," + oSub.FAuxQtyPick.ToString() + "," + oSub.FAuxQtyMust.ToString() + ",'" + oSub.FSendItemDate.ToShortDateString() + "'," + oSub.FStockID.ToString() + ",0,'" + oSub.FBatchNo + "',1059" + ",0,0,''," + oSub.FAuxStockQty.ToString() + "," + oSub.FPPBomInterID.ToString() + "," + oSub.FDisCardAuxQty.ToString() + ",'0',0,0,null" + ",''," + oSub.FAuxQty.ToString() + "," + oSub.FQtyScrap.ToString() + "," + oSub.FBOMInPutAuxQTY.ToString() + ",0," + oSub.FAuxQtyPick.ToString() + "," + oSub.FAuxQtyMust.ToString() + "," + oSub.FAuxStockQty.ToString() + "," + oSub.FDisCardAuxQty.ToString() + ",0,-88" + ",'','','','','','',14036" + ")"); //oCnK3.RunProc("update ICMO set FcommitQty=FcommitQty+" + oSub.Fauxqty + ",FAuxcommitQty=FAuxcommitQty+" + oSub.Fauxqty + " where Finterid=" + oSub.FICMOInterID); } //主表 oCnK3.RunProc("INSERT INTO PPBomChange(" + "FID,FClassTypeID,FDate,FBillNo,FBillerID" + ",FCheckDate,FCheckFlag,FCheckerID,FBillType,FCheckDateLong" + ") Values (" + omodel.HInterID.ToString() + "," + omodel.HBillType + ",'" + omodel.HDate.ToShortDateString() + "','" + omodel.HBillNo + "'," + omodel.FBillerID.ToString() + ",null,'0',0,1059,null" + ")"); //更新关联数量 //更新K3关联数量 //oCnK3.RunProc("EXEC p_UpdateBillRelateData " + this.BillType + "," + omodel.HInterID.ToString() + ",'PPBomChange','PPBomChangeEntry'"); //oCnK3.RunProc("EXEC h_p_K3_UpdateBillRelateData_ProdIn_New " + omodel.HInterID.ToString() + "," + omodel.HBillerID.ToString()); sReturn = "修改单据成功！"; oCnK3.Commit(); return true; } catch (Exception e) { sReturn = e.Message; oCnK3.RollBack(); throw (e); } } //新增单据 public override bool AddBill(ref string sReturn) { try { //得到用户ID DataSet DsBiller; //string HSourceBillType = ""; DsBiller = oK3Cn.RunProcReturn("select top 1 fuserid from t_User where fname='" + DBUtility.ClsPub.CurUserName + "'", "t_User"); if (DsBiller.Tables[0].Rows.Count != 0) { omodel.FBillerID = DBUtility.ClsPub.isLong(DsBiller.Tables[0].Rows[0][0]); } else { omodel.FBillerID = 16394; } omodel.HBillType = this.BillType; // DataSet Ds1; //得到mainid Ds1 = oCnK3.RunProcReturn("declare @InterID int set @InterID=0 exec GetICMaxNumOld 'PPBomChange',@InterID output select ltrim(@InterID)", "xt_xtgnb"); if (Ds1.Tables[0].Rows.Count != 0) { omodel.HInterID = DBUtility.ClsPub.isLong(Ds1.Tables[0].Rows[0][0]); } //若MAINDI重复则重新获取 oCnK3.BeginTran(); //插入子表 foreach (Model.ClsSc_PPBomChangeSub_K3 oSub in DetailColl) { oCnK3.RunProc("INSERT INTO PPBomChangeEntry (" + "FID,FIndex,FICMOInterID,FICMOInterBN,FProductItemID" + ",FUnitID,FAuxQty,FPPBomBillNo,FPPBomEntryID,FChangeFlag" + ",FChangeReason,FItemID,FBomInterID,FMaterielType,FAuxQtyScrap" + ",FItemUnitID,FBOMInPutAuxQTY,FScrap,FAuxQtyLoss,FAuxQtyPick" + ",FAuxQtyMust,FSendItemDate,FStockID,FSPID,FBatchNo,FBackFlush" + ",FOperSN,FOperID,FMachinePos,FAuxStockQty,FPPBOMInterID"+ ",FDiscardAuxQty,FLockFlag,FAuxQtySupply,FChangerID,FChangeDate" + ",FMark,FQty,FQtyScrap,FBOMInPutQTY,FQtyLoss,FQtyPick" + ",FQtyMust,FStockQty,FDiscardQty,FQtySupply,FClassID_SRC" + ",FPositionNo,FItemSize,FItemSuite,FNote1,FNote2,FNote3,FPlanMode"+ //",FMTONo,FOrderEntryID,FIsRepItem,FICSubsID"+ //",FICSubsEntryID,FIsKeyItem,FPriorityID"+ ") Values (" + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + "," + oSub.FICMOInterID.ToString() + ",'" + oSub.FICMOInterBN + "'," + oSub.FProductItemID.ToString() + "," + oSub.FProductUnitID.ToString() + "," + oSub.FAuxQty.ToString() + ",'" + oSub.FPPBomBillNo.ToString() + "'," + oSub.FPPBomEntryID.ToString() + ",'" + oSub.FChangeFlag.ToString() + "',''," + oSub.FItemID.ToString() + "," + oSub.FBomInterID.ToString() + ",'" + oSub.FMaterielType.ToString() + "'," + oSub.FQtyScrap.ToString() + "," + oSub.FUnitID.ToString() + "," + oSub.FBOMInPutAuxQTY.ToString() + ",0,0," + oSub.FAuxQtyPick.ToString() + "," + oSub.FAuxQtyMust.ToString() + ",'" + oSub.FSendItemDate.ToShortDateString() + "'," + oSub.FStockID.ToString() +",0,'"+ oSub.FBatchNo+"',1059"+ ",0,0,''," + oSub.FAuxStockQty.ToString() + "," + oSub.FPPBomInterID.ToString() + "," + oSub.FDisCardAuxQty.ToString() +",'0',0,0,null"+ ",''," + oSub.FAuxQty.ToString() + "," + oSub.FQtyScrap.ToString() + "," + oSub.FBOMInPutAuxQTY.ToString() + ",0," + oSub.FAuxQtyPick.ToString() + "," + oSub.FAuxQtyMust.ToString() + "," + oSub.FAuxStockQty.ToString() + "," + oSub.FDisCardAuxQty.ToString() + ",0,-88" + ",'','','','','','',14036" + ")"); //oCnK3.RunProc("update ICMO set FcommitQty=FcommitQty+" + oSub.Fauxqty + ",FAuxcommitQty=FAuxcommitQty+" + oSub.Fauxqty + " where Finterid=" + oSub.FICMOInterID); } //主表 oCnK3.RunProc("INSERT INTO PPBomChange(" + "FID,FClassTypeID,FDate,FBillNo,FBillerID" + ",FCheckDate,FCheckFlag,FCheckerID,FBillType,FCheckDateLong" + ") Values (" + omodel.HInterID.ToString() + "," + omodel.HBillType + ",'" + omodel.HDate.ToShortDateString() + "','" + omodel.HBillNo + "'," + omodel.FBillerID.ToString() + ",null,'0',0,1059,null" + ")"); ////插入子表 //foreach (Model.ClsKf_ProductInBillSub_K3 oSub in DetailColl) //{ // oSub.HInterID = omodel.HInterID; // oCnK3.RunProc(K3_BaseFun.Fun_GetAddBillSubSQL_ProdIn(oSub, DBUtility.ClsPub.VersionNum)); // HSourceBillType = oSub.HSourceBillType; //} ////更新主表 //oCnK3.RunProc(K3_BaseFun.Fun_GetAddBillMainSQL_ProdIn(omodel, DBUtility.ClsPub.VersionNum)); //更新K3关联数量 //oCnK3.RunProc("EXEC p_UpdateBillRelateData " + this.BillType + "," + omodel.HInterID.ToString() + ",'PPBomChange','PPBomChangeEntry'"); //oCnK3.RunProc("EXEC h_p_K3_UpdateBillRelateData_ProdIn_New " + omodel.HInterID.ToString() + "," + omodel.HBillerID.ToString()); // // sReturn = "新增单据成功！"; oCnK3.Commit(); return true; } catch (Exception e) { sReturn = e.Message; oCnK3.RollBack(); throw (e); } } //显示单据 public override bool ShowBill(Int64 lngBillKey, ref string sReturn) { try { //查询主表 DataSet Ds ; SQLHelper.ClsCNK3 oCn = new SQLHelper.ClsCNK3(); Ds = oCn.RunProcReturn("Select * from PPBomChange Where FID=" + lngBillKey.ToString(), "PPBomChange"); if(Ds.Tables[0].Rows.Count==0) { sReturn = "单据未找到！"; return false; } //赋值 //omodel.FICMOInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["FICMOInterID"]); //omodel.FOrderBillNo = Ds.Tables[0].Rows[0]["FOrderBillNo"].ToString().Trim(); omodel.FBillNo = Ds.Tables[0].Rows[0]["FBillNo"].ToString().Trim(); omodel.FDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["FDate"]); //omodel.FItemID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["FItemID"]); //omodel.FWorkShop = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["FWorkShop"]); //omodel.FUnitID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["FUnitID"]); //omodel.FAuxQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["FAuxQty"]); //================= omodel.FBillerID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["FBillerID"]); omodel.FCheckerID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["FCheckerID"]); omodel.FCheckDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["FCheckDate"]); // //循环 DataSet DsSub; DsSub = oCn.RunProcReturn("Select * from PPBomChangeEntry Where FID=" + lngBillKey.ToString() + " order by HEntryID ", "PPBomChangeEntry"); DetailColl.Clear();//清空 for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++) { Model.ClsSc_PPBomChangeSub_K3 oSub = new Model.ClsSc_PPBomChangeSub_K3(); oSub.HInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["FID"].ToString()); oSub.HEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["FIndex"].ToString()); oSub.FICMOInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["FICMOInterID"].ToString()); oSub.FICMOInterBN = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["FICMOInterBN"].ToString()); oSub.FProductItemID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["FProductItemID"].ToString()); oSub.FProductUnitID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["FUnitID"].ToString()); oSub.FAuxQty = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["FAuxQty"].ToString()); oSub.FPPBomBillNo = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["FPPBomBillNo"].ToString()); oSub.FPPBomInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["FPPBomInterID"].ToString()); oSub.FPPBomEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["FPPBomEntryID"].ToString()); oSub.FChangeFlag = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["FChangeFlag"].ToString()); // oSub.FItemID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["FItemID"].ToString()); oSub.FMaterielType = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["FMaterielType"].ToString()); oSub.FQtyScrap = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["FQtyScrap"].ToString()); oSub.FUnitID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["FUnitID"].ToString()); oSub.FBOMInPutAuxQTY = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["FBOMInPutAuxQTY"].ToString()); oSub.FScrap = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["FScrap"].ToString()); oSub.FAuxQtyLoss = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["FAuxQtyLoss"].ToString()); //oSub.FRealScrap = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["FRealScrap"].ToString()); oSub.FAuxQtyPick = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["FAuxQtyPick"].ToString()); oSub.FAuxQtyMust = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["FAuxQtyMust"].ToString()); oSub.FAuxStockQty = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["FAuxStockQty"].ToString()); oSub.FDisCardAuxQty = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["FDisCardAuxQty"].ToString()); oSub.FSendItemDate = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[i]["FSendItemDate"].ToString()); oSub.FStockID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["FStockID"].ToString()); oSub.FSPID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["FSPID"].ToString()); oSub.FBatchNo = DsSub.Tables[0].Rows[i]["FBatchNo"].ToString().Trim(); oSub.FBackFlush = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["FBackFlush"].ToString()); oSub.FOPerID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["FOPerID"].ToString()); oSub.FMachinePos = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["FMachinePos"].ToString()); //oSub.FNote = DsSub.Tables[0].Rows[i]["FNote1"].ToString().Trim(); oSub.FAuxQtySupply = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["FAuxQtySupply"].ToString()); oSub.FOperSN = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["FOperSN"].ToString()); oSub.FBomInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["FBomInterID"].ToString()); oSub.FPositionNo = DsSub.Tables[0].Rows[i]["FPositionNo"].ToString().Trim(); oSub.FItemSize = DsSub.Tables[0].Rows[i]["FItemSize"].ToString().Trim(); oSub.FItemSuite = DsSub.Tables[0].Rows[i]["FItemSuite"].ToString().Trim(); DetailColl.Add(oSub); } sReturn = "显示单据成功！"; return true; } catch (Exception e) { sReturn = e.Message; throw (e); } } //审核单据 public bool CheckBill_K3(Int64 lngBillKey, ref string sReturn) { try { //得到用户ID DataSet DsBiller; DsBiller = oK3Cn.RunProcReturn("select top 1 fuserid from t_User where fname='" + DBUtility.ClsPub.CurUserName + "'", "t_User"); if (DsBiller.Tables[0].Rows.Count != 0) { omodel.FBillerID = DBUtility.ClsPub.isLong(DsBiller.Tables[0].Rows[0][0]); } else { omodel.FBillerID = 16394; } omodel.HBillType = this.BillType; omodel.HCheckDate = DateTime.Today.ToShortDateString(); string date = DateTime.Today.ToString(); // //DataSet Ds1; //主表 oCnK3.BeginTran(); oCnK3.RunProc("update PPBomChange set FCheckDate='" + omodel.HCheckDate + "',FCheckDateLong='"+date +"',FCheckerID="+ omodel.FBillerID.ToString() +",FCheckFlag='1' where FID=" +lngBillKey.ToString()); sReturn = "审核单据成功！"; oCnK3.Commit(); return true; } catch (Exception e) { sReturn = e.Message; oCnK3.RollBack(); throw (e); } } //反审单据 public bool AbandonCheck_K3(Int64 lngBillKey, ref string sReturn) { try { //得到用户ID DataSet DsBiller; DsBiller = oK3Cn.RunProcReturn("select top 1 FID from PPBomChangeEntry where FChangeFlag='1' and FID=" + lngBillKey.ToString() , "PPBomChangeEntry"); if (DsBiller.Tables[0].Rows.Count >= 1) { sReturn = "单据已变更,反审核单据失败！"; return false; } else { // //DataSet Ds1; //主表PPBomChange oCnK3.BeginTran(); oCnK3.RunProc("update PPBomChange set FCheckDate=null,FCheckerID=0,FCheckFlag='0' where FID=" + lngBillKey.ToString()); sReturn = "反审核单据成功！"; oCnK3.Commit(); return true; } } catch (Exception e) { sReturn = e.Message; oCnK3.RollBack(); throw (e); } } //变更 public bool ChangeBill_K3(Int64 lngBillKey, ref string sReturn) { try { //得到用户ID DataSet DsBiller; DsBiller = oK3Cn.RunProcReturn("select top 1 fuserid from t_User where fname='" + DBUtility.ClsPub.CurUserName + "'", "t_User"); DataSet Ds; Ds = oK3Cn.RunProcReturn("select top 1 FID from PPBomChangeEntry where FChangeFlag='1' and FID=" + lngBillKey.ToString(), "PPBomChangeEntry"); if (Ds.Tables[0].Rows.Count >= 1) { sReturn = "单据已变更,变更失败！"; return false; } else if (DsBiller.Tables[0].Rows.Count != 0) { omodel.FBillerID = DBUtility.ClsPub.isLong(DsBiller.Tables[0].Rows[0][0]); } else { omodel.FBillerID = 16394; } omodel.HBillType = this.BillType; omodel.HCheckDate = DateTime.Today.ToShortDateString(); // //DataSet Ds1; //主表 oCnK3.BeginTran(); oCnK3.RunProc("exec PPBomChangeEntry_update " + lngBillKey.ToString()); oCnK3.RunProc("update PPBomChangeEntry set FChangeDate='" + omodel.HCheckDate + "',FChangerID=" + omodel.FBillerID.ToString() + ",FChangeFlag='1' where FID=" + lngBillKey.ToString()); sReturn = "变更成功！"; oCnK3.Commit(); return true; } catch (Exception e) { sReturn = e.Message; oCnK3.RollBack(); throw (e); } } //删除单据 public virtual bool DeleteBill(Int64 lngBillKey, ref string sReturn) { try { DataSet Ds; oCnK3.BeginTran(); // //Ds = oCnK3.RunProcReturn("select FSourceInterID from ICStockBillEntry where finterid=" + lngBillKey, "ICStockBillEntry"); //删除关联 //删除明细表 oCnK3.RunProc("Delete From PPBomChangeEntry where FID=" + lngBillKey.ToString()); //删除主表 //DeleteBillMain(lngBillKey); oCnK3.RunProc("Delete From PPBomChange where FID=" + lngBillKey.ToString()); //删除关联 sReturn = "删除单据成功！"; oCnK3.Commit(); return true; } catch (Exception e) { sReturn = e.Message; oCnK3.RollBack(); throw (e); } } //单据号是否重复 public virtual bool IsExistBillNo(ref string sReturn, string sBillNo, DBUtility.ClsPub.Enum_BillStatus oBillStatus, Int64 lngBillKey) { try { string sSql = ""; if (oBillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew) { sSql = "Select FInterID from PPBomChange where FClassTypeID='" + MvarItemKey + "' and FBillNo ='" + sBillNo + "'"; } else { sSql = "Select FInterID from PPBomChange where FClassTypeID='" + MvarItemKey + "' and FBillNo ='" + sBillNo + "' and FID<>" + lngBillKey.ToString(); } DataSet Ds; Ds = oCnK3.RunProcReturn(sSql, "PPBomChange"); if (Ds.Tables[0].Rows.Count != 0) { sReturn = "单号重复"; return true; } sReturn = "单号未重复"; return false; } catch (Exception e) { sReturn = e.Message; return false; } } } }