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