public void InsertAttributeTemplate(tsysattrtplate template, List<tsysattrtplatedtl> lstAttribute) { try { dbInstance.BeginTransaction(); //Insert header localDal.DoInsert<tsysattrtplate>(template); //Insert detail for (int i = 0; i < lstAttribute.Count; i++) { localDal.DoInsert<tsysattrtplatedtl>(lstAttribute[i]); } dbInstance.Commit(); } catch (Exception ex) { dbInstance.Rollback(); throw ex; } finally { dbInstance.CloseConnection(); } }
/// <summary> /// Create a new tsysattrtplate object. /// </summary> /// <param name="attrtplatid">Initial value of the attrtplatid property.</param> /// <param name="attrtplatname">Initial value of the attrtplatname property.</param> /// <param name="lastmodifieduser">Initial value of the lastmodifieduser property.</param> /// <param name="lastmodifiedtime">Initial value of the lastmodifiedtime property.</param> public static tsysattrtplate Createtsysattrtplate(global::System.String attrtplatid, global::System.String attrtplatname, global::System.String lastmodifieduser, global::System.DateTime lastmodifiedtime) { tsysattrtplate tsysattrtplate = new tsysattrtplate(); tsysattrtplate.attrtplatid = attrtplatid; tsysattrtplate.attrtplatname = attrtplatname; tsysattrtplate.lastmodifieduser = lastmodifieduser; tsysattrtplate.lastmodifiedtime = lastmodifiedtime; return tsysattrtplate; }
/// <summary> /// Deprecated Method for adding a new object to the tsysattrtplate EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddTotsysattrtplate(tsysattrtplate tsysattrtplate) { base.AddObject("tsysattrtplate", tsysattrtplate); }
public void UpdateAttributeTemplate(tsysattrtplate template, List<tsysattrtplatedtl> lstAttribute) { try { dbInstance.BeginTransaction(); List<MESParameterInfo> lstParameters = new List<MESParameterInfo>() { new MESParameterInfo(){ ParamName="attrtplatid", ParamValue=template.attrtplatid, ParamType="string" } }; //delete detail first localDal.DoDelete<tsysattrtplatedtl>(lstParameters); //Insert header localDal.DoUpdate<tsysattrtplate>(template); //Insert detail for (int i = 0; i < lstAttribute.Count; i++) { localDal.DoInsert<tsysattrtplatedtl>(lstAttribute[i]); } dbInstance.Commit(); } catch (Exception ex) { dbInstance.Rollback(); throw ex; } finally { dbInstance.CloseConnection(); } }
public void UpdateAttributeTemplate(ContextInfo contextInfo,tsysattrtplate template,List<tsysattrtplatedtl> lstAttribute) { contextInfo.Action = MES_ActionType.Update; AttributeTemplateBll bll = new AttributeTemplateBll(contextInfo); bll.CallAccessControl(); bll.UpdateAttributeTemplate(template, lstAttribute); GC.Collect(); }