///<summary></summary> public static long Insert(Dunning dun) { if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) { dun.DunningNum=Meth.GetLong(MethodBase.GetCurrentMethod(),dun); return dun.DunningNum; } return Crud.DunningCrud.Insert(dun); }
///<summary></summary> public static void Update(Dunning dun){ if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) { Meth.GetVoid(MethodBase.GetCurrentMethod(),dun); return; } Crud.DunningCrud.Update(dun); }
///<summary></summary> public FormDunningEdit(Dunning dunningCur) { // // Required for Windows Form Designer support // DunningCur=dunningCur.Copy(); InitializeComponent(); Lan.F(this); }
///<summary></summary> public static void Delete(Dunning dun){ if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) { Meth.GetVoid(MethodBase.GetCurrentMethod(),dun); return; } string command="DELETE FROM dunning" +" WHERE DunningNum = "+POut.Long(dun.DunningNum); Db.NonQ(command); }
///<summary></summary> public static void Update(Dunning dun) { if (RemotingClient.RemotingRole == RemotingRole.ClientWeb) { Meth.GetVoid(MethodBase.GetCurrentMethod(), dun); return; } Crud.DunningCrud.Update(dun); }
///<summary></summary> public static long Insert(Dunning dun) { if (RemotingClient.RemotingRole == RemotingRole.ClientWeb) { dun.DunningNum = Meth.GetLong(MethodBase.GetCurrentMethod(), dun); return(dun.DunningNum); } return(Crud.DunningCrud.Insert(dun)); }
///<summary>Returns a copy of this Dunning.</summary> public Dunning Copy() { Dunning d = new Dunning(); d.DunningNum = DunningNum; d.DunMessage = DunMessage; d.BillingType = BillingType; d.AgeAccount = AgeAccount; d.InsIsPending = InsIsPending; return(d); }
///<summary></summary> public static void Delete(Dunning dun) { if (RemotingClient.RemotingRole == RemotingRole.ClientWeb) { Meth.GetVoid(MethodBase.GetCurrentMethod(), dun); return; } string command = "DELETE FROM dunning" + " WHERE DunningNum = " + POut.Long(dun.DunningNum); Db.NonQ(command); }
///<summary>Will return null if no dunning matches the given criteria.</summary> public static Dunning GetDunning(Dunning[] dunList,long billingType,int ageAccount,YN insIsPending) { //No need to check RemotingRole; no call to db. //loop backwards through Dunning list and find the first dunning that matches criteria. for(int i=dunList.Length-1;i>=0;i--){ if(dunList[i].BillingType!=0//0 in the list matches all && dunList[i].BillingType!=billingType){ continue; } if(ageAccount < dunList[i].AgeAccount){//match if age is >= item in list continue; } if(dunList[i].InsIsPending!=YN.Unknown//unknown in the list matches all && dunList[i].InsIsPending!=insIsPending){ continue; } return dunList[i]; } return null; }
///<summary>Gets a list of all dunnings.</summary> public static Dunning[] Refresh() { if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) { return Meth.GetObject<Dunning[]>(MethodBase.GetCurrentMethod()); } string command="SELECT * FROM dunning " +"ORDER BY BillingType,AgeAccount,InsIsPending"; DataTable table=Db.GetTable(command); Dunning[] List=new Dunning[table.Rows.Count]; for(int i=0;i<table.Rows.Count;i++) { List[i]=new Dunning(); List[i].DunningNum = PIn.Long(table.Rows[i][0].ToString()); List[i].DunMessage = PIn.String(table.Rows[i][1].ToString()); List[i].BillingType = PIn.Long(table.Rows[i][2].ToString()); List[i].AgeAccount = PIn.Byte(table.Rows[i][3].ToString()); List[i].InsIsPending = (YN)PIn.Long(table.Rows[i][4].ToString()); List[i].MessageBold = PIn.String(table.Rows[i][5].ToString()); } return List; }
///<summary>Gets a list of all dunnings.</summary> public static Dunning[] Refresh() { if (RemotingClient.RemotingRole == RemotingRole.ClientWeb) { return(Meth.GetObject <Dunning[]>(MethodBase.GetCurrentMethod())); } string command = "SELECT * FROM dunning " + "ORDER BY BillingType,AgeAccount,InsIsPending"; DataTable table = Db.GetTable(command); Dunning[] List = new Dunning[table.Rows.Count]; for (int i = 0; i < table.Rows.Count; i++) { List[i] = new Dunning(); List[i].DunningNum = PIn.Long(table.Rows[i][0].ToString()); List[i].DunMessage = PIn.String(table.Rows[i][1].ToString()); List[i].BillingType = PIn.Long(table.Rows[i][2].ToString()); List[i].AgeAccount = PIn.Byte(table.Rows[i][3].ToString()); List[i].InsIsPending = (YN)PIn.Long(table.Rows[i][4].ToString()); List[i].MessageBold = PIn.String(table.Rows[i][5].ToString()); } return(List); }
private void butAdd_Click(object sender, System.EventArgs e) { Dunning dun=new Dunning(); FormDunningEdit FormD=new FormDunningEdit(dun); FormD.IsNew=true; FormD.ShowDialog(); if(FormD.DialogResult==DialogResult.Cancel){ return; } FillDunning(); }