public Ledgers.DAILYCLOSINGDataTable GetSPCP(DateTime d1,int spcp,bool useconstr,string newconstr) { var ta = new LedgersTableAdapters.DAILYCLOSINGTableAdapter { Connection = { ConnectionString = useconstr ? newconstr : _constr } }; var ds = new Ledgers().DAILYCLOSING; if (spcp == 1) ta.FillBySPCP(ds, d1, 2); else if (spcp == 2) ta.FillBySPCP(ds, d1, 3); return ds; }
public Ledgers.DAILYCLOSINGDataTable GetDailyClosing() { var ta = new LedgersTableAdapters.DAILYCLOSINGTableAdapter {Connection = {ConnectionString = _constr}}; var ds = new Ledgers().DAILYCLOSING; ta.FillByCompany(ds, Utils.Company); return ds; }
public Ledgers.DAILYCLOSINGDataTable GetLastClosing(DateTime d1, bool isdate) { var ta = new LedgersTableAdapters.DAILYCLOSINGTableAdapter {Connection = {ConnectionString = _constr}}; var ds = new Ledgers().DAILYCLOSING; if (isdate) ta.FillByMaxdateToDate(ds, Utils.Company,d1); else ta.FillByMaxdate(ds, Utils.Company); return ds; }
public int DoSave(int ctype, string ctext, decimal cvalue, DateTime dt,bool isbeg) { var ta = new LedgersTableAdapters.DAILYCLOSINGTableAdapter {Connection = {ConnectionString = _constr}}; var cn = new SqlConnection(_constr); var cmd = new SqlCommand(); cn.Open(); //"yyyy-MM-dd HH:mm:ss" var fg = isbeg ? 1 : 0; cmd.Connection = cn; string scmd = " INSERT INTO DAILYCLOSING (CTYPE, CNAME, CVALUE, CDATE, USERID, COMPANY, ISBEG) "; scmd += " VALUES (" + ctype + ",'" + ctext + "'," + cvalue + ",'" + dt.ToString("yyyy-MM-dd HH:mm:ss") + "', " + Utils.Userid + ",'" + Utils.Company + "'," + fg + ") "; cmd.CommandText = scmd; return cmd.ExecuteNonQuery(); //return ta.Insert(ctype, ctext, cvalue, dt, Utils.Userid, Utils.Company,isbeg); }