protected void btnAdd_ServerClick(object sender, EventArgs e) { PartDef item = new PartDef(); IList<PartDef> partLst = new List<PartDef>(); string PartNo = this.dPartNo.Text; string nodeType = this.drpMaintainPartType.InnerDropDownList.SelectedValue.ToString(); string desc = this.drpTypeDesc.InnerDropDownList.SelectedValue.ToString(); bool autoDL = this.checkAutoDL.Checked; item.partNo = PartNo; item.partType = this.dPartType.Text; item.bomNodeType = nodeType; item.descr = desc; item.remark = this.dRemark.Text; item.custPartNo = this.dCustPn.Text; item.flag = 1; if (autoDL) { item.autoDL = "Y"; } else { item.autoDL = "N"; } item.editor = this.HiddenUserName.Value; item.cdt = DateTime.Now; item.udt = DateTime.Now; try { iPart.addPart(item); } catch (FisException ex) { showErrorMessage(ex.mErrmsg); return; } catch (Exception ex) { //show error showErrorMessage(ex.Message); return; } showListPartByPartType(nodeType); this.updatePanel2.Update(); this.updatePanel3.Update(); ScriptManager.RegisterStartupScript(this.updatePanelAll, typeof(System.Object), "saveUpdate", "AddUpdateComplete('" + this.dPartNo.Text + "');", true); }
public void SavePartEx(PartDef newPart, string oldPartNo) { try { partRepositoryEx.SavePartEx(newPart, oldPartNo); } catch (FisException e) { logger.Error(e.mErrmsg); throw e; } catch (Exception e) { logger.Error(e.Message); throw; } }
public IList<string> GetPartNoList() { IList<string> ret = new List<string>(); IMiscRepository iMiscRepository = RepositoryFactory.GetInstance().GetRepository<IMiscRepository>(); try { PartDef condition = new PartDef(); condition.bomNodeType="SB"; IList<PartDef> temp = iMiscRepository.GetData<IMES.Infrastructure.Repository._Metas.Part_NEW, PartDef>(condition); temp = temp.OrderBy(x => x.partNo).ToList(); foreach (PartDef item in temp) { ret.Add(item.partNo); } } catch (FisException e) { logger.Error(e.mErrmsg); throw e; } catch (Exception e) { logger.Error(e.Message); throw; } return ret; }
public string SaveAs(string code, string newCode, string editor, Boolean isNeedCheck) { try { IModelBOMRepository itemRepository = RepositoryFactory.GetInstance().GetRepository<IModelBOMRepository, BOMNodeData>(); IModelRepository iModelRepository = RepositoryFactory.GetInstance().GetRepository<IModelRepository>(); IPartRepository iPartRepository = RepositoryFactory.GetInstance().GetRepository<IPartRepository>(); IMiscRepository iMiscRepository = RepositoryFactory.GetInstance().GetRepository<IMiscRepository>(); if (isNeedCheck == true) { bool isModel = false; #region check is Model or Part Model model = iModelRepository.Find(code); IPart part = iPartRepository.GetPartByPartNo(code); if (model == null && part == null) { List<string> erpara = new List<string>(); FisException ex; ex = new FisException("Input Error"); throw ex; } if (model != null) { isModel = true; } #endregion IUnitOfWork uow = new UnitOfWork(); if (isModel) { #region model Model newmodel = iModelRepository.Find(newCode); if (newmodel == null) { iModelRepository.CopyModelDefered(uow, code, newCode, 0, editor); } else { List<string> erpara = new List<string>(); erpara.Add(newCode); FisException ex; ex = new FisException("CHK1252", erpara); throw ex; } #endregion } else { #region part PartDef condition = new PartDef(); condition.partNo = newCode; IList<PartDef> newpartlist = iMiscRepository.GetData<IMES.Infrastructure.Repository._Metas.Part_NEW, PartDef>(condition); if (newpartlist.Count == 0) { iPartRepository.CopyPartlDefered(uow, code, newCode, 0, editor); } else { List<string> erpara = new List<string>(); erpara.Add(newCode); FisException ex; ex = new FisException("CHK1251", erpara); throw ex; } #endregion } DataTable result = itemRepository.GetMaterialById(newCode); if (result.Rows.Count > 0) { List<string> erpara = new List<string>(); FisException ex; ex = new FisException("DMT012", erpara); throw ex; } itemRepository.SaveModelBOMAsDefered(uow, code, newCode, editor); uow.Commit(); } } catch (Exception) { throw; } return newCode; }
public IList<PartDef> GetPartListByPartType(string partType, int rowCount) { try { IList<PartDef> ret = new List<PartDef>(); string SQLStatement = @"select top {1} PartNo, BomNodeType,Descr, PartType, CustPartNo, AutoDL, Remark, Flag, Editor, Cdt, Udt from Part with(NOLOCK) where PartType = '{0}' order by PartNo"; SQLStatement = string.Format(SQLStatement, partType, rowCount.ToString()); using (DataTable dt = _Schema.SqlHelper.ExecuteDataFill(_Schema.SqlHelper.ConnectionString_GetData, CommandType.Text, SQLStatement)) { if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { PartDef part = new PartDef(); part.partNo = ObjToString(dr["PartNo"]); part.bomNodeType = ObjToString(dr["BomNodeType"]); part.partType = ObjToString(dr["PartType"]); part.custPartNo = ObjToString(dr["CustPartNo"]); part.descr = ObjToString(dr["Descr"]); part.remark = ObjToString(dr["Remark"]); part.autoDL = ObjToString(dr["AutoDL"]); part.editor = ObjToString(dr["Editor"]); part.cdt = DateTime.Parse(dr["Cdt"].ToString()); part.udt = DateTime.Parse(dr["Udt"].ToString()); ret.Add(part); } } } return ret; } catch (Exception) { throw; } }
public void SavePartExDefered(IUnitOfWork uow, PartDef newPart, string oldPartNo) { Action deferAction = () => { SavePartEx(newPart, oldPartNo); }; AddOneInvokeBody(uow, deferAction); }
public void SavePartEx(PartDef newPart, string oldPartNo) { try { _Schema.SQLContext sqlCtx = null; lock (MethodBase.GetCurrentMethod()) { if (!_Schema.Func.PeerTheSQL(MethodBase.GetCurrentMethod().MetadataToken, out sqlCtx)) { sqlCtx = new _Schema.SQLContext(); sqlCtx.Sentence = @" UPDATE Part SET [Descr] = @Descr ,[BomNodeType] = @BomNodeType ,[PartType] =@PartType ,[CustPartNo] = @CustPartNo ,[AutoDL] = @AutoDL ,[Remark] = @Remark ,[Editor] = @Editor ,[Udt] = @Udt WHERE PartNo=@oldPartNo "; sqlCtx.Params.Add("Descr", new SqlParameter("@Descr", SqlDbType.VarChar)); sqlCtx.Params.Add("BomNodeType", new SqlParameter("@BomNodeType", SqlDbType.VarChar)); sqlCtx.Params.Add("PartType", new SqlParameter("@PartType", SqlDbType.VarChar)); sqlCtx.Params.Add("CustPartNo", new SqlParameter("@CustPartNo", SqlDbType.VarChar)); sqlCtx.Params.Add("AutoDL", new SqlParameter("@AutoDL", SqlDbType.VarChar)); sqlCtx.Params.Add("Remark", new SqlParameter("@Remark", SqlDbType.VarChar)); sqlCtx.Params.Add("Editor", new SqlParameter("@Editor", SqlDbType.VarChar)); sqlCtx.Params.Add("Udt", new SqlParameter("@Udt", SqlDbType.DateTime)); sqlCtx.Params.Add("oldPartNo", new SqlParameter("@oldPartNo", SqlDbType.VarChar)); _Schema.Func.InsertIntoCache(MethodBase.GetCurrentMethod().MetadataToken, sqlCtx); } } sqlCtx.Params["Descr"].Value = newPart.descr; sqlCtx.Params["BomNodeType"].Value = newPart.bomNodeType; sqlCtx.Params["PartType"].Value = newPart.partType; sqlCtx.Params["CustPartNo"].Value = newPart.custPartNo; sqlCtx.Params["AutoDL"].Value = newPart.autoDL; sqlCtx.Params["Remark"].Value = newPart.remark; sqlCtx.Params["Editor"].Value = newPart.editor; sqlCtx.Params["Udt"].Value = newPart.udt; sqlCtx.Params["oldPartNo"].Value = oldPartNo; _Schema.SqlHelper.ExecuteNonQuery(_Schema.SqlHelper.ConnectionString_GetData, CommandType.Text, sqlCtx.Sentence, sqlCtx.Params.Values.ToArray<SqlParameter>()); } catch (Exception) { throw; } InsertCacheUpdate(CacheTypeEnum.Part, oldPartNo); }
/// <summary> /// 添加一条part记录 /// </summary> /// <param name="obj"></param> public void addPart(PartDef obj) { IList<PartDef> pdLst = new List<PartDef>(); pdLst = partRepository.GetLstByPartNo(obj.partNo); try { if (pdLst != null && pdLst.Count > 0) { PartDef pd = new PartDef(); if (pd.flag == 0) { pd = pdLst.First(); partRepository.UpdatePartByPartNo(pd, pd.partNo); } else { //已经存在具有相同part的记录 List<string> erpara = new List<string>(); FisException ex; ex = new FisException("DMT097", erpara); throw ex; } } partRepository.AddPart(obj); } catch (Exception e) { logger.Error(e.Message); throw; } }
/// <summary> /// 修改part数据 /// </summary> /// <param name="obj"></param> /// <param name="partNo"></param> public void updatePart(PartDef obj, string partNo) { try { partRepository.UpdatePartByPartNo(obj, partNo); } catch (FisException e) { logger.Error(e.mErrmsg); throw e; } catch (Exception e) { logger.Error(e.Message); throw; } }
protected void btnSave_ServerClick(object sender, EventArgs e) { string oldPartNo = this.hidPartNo.Value.ToString().Trim(); string partType = this.CmbMaintainPartTypeAll.SelectedValue; string nodeType = this.drpMaintainPartNodeType.InnerDropDownList.SelectedValue.ToString(); string desc = this.CmbMiantainDesc.SelectedValue; string partNo = this.dPartNo.Text.Trim(); bool autoDL = this.checkAutoDL.Checked; if (!oldPartNo.Equals(partNo)) { showErrorMessage(this.GetLocalResourceObject(Pre + "_ErrSaveNewPart").ToString()); return; } PartDef item = new PartDef(); item.partNo = partNo; item.bomNodeType = nodeType; item.descr = desc; item.remark = this.dRemark.Text; item.custPartNo = this.dCustPn.Text; item.partType = partType; // item.bomNodeType = this.drpMaintainPartType.InnerDropDownList.SelectedValue.ToString(); if (autoDL) { item.autoDL = "Y"; } else { item.autoDL = "N"; } item.editor = this.HiddenUserName.Value; item.udt = DateTime.Now; try { iPart.updatePart(item, oldPartNo); iPartEx.SavePartEx(item,oldPartNo); } catch (FisException ex) { showErrorMessage(ex.mErrmsg); return; } catch (Exception ex) { showErrorMessage(ex.Message); return; } // showListPartByPartType(partType); FindPart(partNo); this.updatePanel2.Update(); this.updatePanel3.Update(); ScriptManager.RegisterStartupScript(this.updatePanelAll, typeof(System.Object), "saveUpdate", "AddUpdateComplete('" + this.dPartNo.Text.Trim() + "');", true); }