public Form2(ClsKeys Key) { InitializeComponent(); this.Load += new EventHandler(Form2_Load); this.Btn_Save.Click += new EventHandler(Btn_Save_Click); this.Employee = new DataObjects.Employee(null); this.Employee.Load(Key); }
/// <summary> /// (Overrided) Loads the List with the supplied Key /// </summary> /// <param name="Keys"> /// Key object to use /// </param> public override void Load(ClsKeys Keys = null) { if (Keys == null) { this.New(); } else { ClsQueryCondition Qc = this.mDa.CreateQueryCondition(); foreach (string KeyName in Keys.pName) { Qc.Add(KeyName, Keys[KeyName].ToString(), typeof(Int64).ToString(), "0"); } if (this.mQc_LoadCondition != null) { foreach (DataObjects_Framework.Objects.ClsQueryCondition.Str_QueryCondition Str_Qc in this.mQc_LoadCondition.pList) { Qc.pList.Add(Str_Qc); } } this.Load(Qc); } }
public static bool CheckSeriesDuplicate( string TableName , string SeriesField , ClsKeys Keys , string SeriesNo) { bool Rv = false; DataTable Dt; System.Text.StringBuilder Sb_Query_Key = new StringBuilder(); string Query_Key = ""; string Query_And = ""; foreach (string Inner_Key in Keys.pName) { Sb_Query_Key.Append(Query_And + " " + Inner_Key + " = " + Keys[Inner_Key]); Query_And = " And "; } Query_Key = " 1 = 1 "; if (Sb_Query_Key.ToString() != "") { Query_Key = "(Not (" + Sb_Query_Key.ToString() + "))"; } Dt = new ClsBase().pDa.GetQuery( "[" + TableName + "]" , "Count(1) As [Ct]" , Query_Key + " And " + SeriesField + " = '" + SeriesNo + "'"); if (Dt.Rows.Count > 0) { if ((Int32)Dt.Rows[0][0] > 0) { Rv = true; } } //True means duplicates have been found return Rv; }
public void Load(Interface_DataAccess Da, ClsKeys Keys) { this.mDr = Da.Load_RowDetails(this.mViewName, Keys, this.mOtherLoadCondition, this.mList_ForeignKey); }
//[-] /// <summary> /// (Overridable) Loads the Data Object with the supplied Key, /// when loading table details, the framework assumes the foreign key field of the table detail is the same the parent table /// if not supplied by an explicit foreign key definition /// </summary> /// <param name="Keys"> /// Key object to use /// </param> public virtual void Load(ClsKeys Keys = null) { try { this.mDa.Connect(); //[-] this.mHeader_Dr = this.mDa.Load(this.mHeader_ViewName, this.mHeader_Key, Keys); //[-] if (this.mBase_TableDetail != null) { foreach (ClsBaseTableDetail Inner_Obj in this.mBase_TableDetail) { Inner_Obj.Load(this.mDa, Keys); } } //[-] if (this.mBase_RowDetail != null) { foreach (ClsBaseRowDetail Inner_Obj in this.mBase_RowDetail) { Inner_Obj.Load(this.mDa, Keys); } } //[-] this.AddRequired(); } catch (Exception Ex) { throw Ex; } finally { this.mDa.Close(); } }
/// <summary> /// Gets the Keys of the supplier datarow using the supplier Key Definition /// </summary> /// <param name="Dr"> /// Source datarow /// </param> /// <param name="KeyNames"> /// Key definition /// </param> /// <returns></returns> public ClsKeys GetKeys(DataRow Dr, List<string> KeyNames) { bool IsFound = false; ClsKeys Key = new ClsKeys(); foreach (string Inner_Key in KeyNames) { if (!Information.IsDBNull(Dr[Inner_Key])) { Key.Add(Inner_Key, Do_Methods.Convert_Int64(Dr[Inner_Key], 0)); } else { IsFound = true; break; } } if (IsFound) { Key = null; } return Key; }
/// <summary> /// Gets the Keys of the supplied row using the Key Definition of the Data Object /// </summary> /// <param name="Dr"> /// Source datarow, mostly the same definition as from Me.List() /// </param> /// <returns></returns> public ClsKeys GetKeys(DataRow Dr) { ClsKeys Obj = new ClsKeys(); foreach (string Key in this.mHeader_Key) { Int64 ID = Do_Methods.Convert_Int64(Dr[Key]); Obj.Add(Key, ID); } return Obj; }