public DataSet ViewRunChart(Keyfile p) { DAclass db = new DAclass(); DataSet ds = new DataSet(); SqlParameter objpara1 = new SqlParameter("@fromdate", p.Fromdate); db.parameters.Add(objpara1); SqlParameter objpara2 = new SqlParameter("@todate", p.ToDate); db.parameters.Add(objpara2); SqlParameter objpara3 = new SqlParameter("@data", p.Data); db.parameters.Add(objpara3); SqlParameter objpara4 = new SqlParameter("@shift", p.Shift); db.parameters.Add(objpara4); SqlParameter objpara5 = new SqlParameter("@unit", p.Unit); db.parameters.Add(objpara5); SqlParameter objpara6 = new SqlParameter("@mach", p.Machine); db.parameters.Add(objpara6); SqlParameter objpara7 = new SqlParameter("@DynValueid", p.Dynvalueid); db.parameters.Add(objpara7); ds = db.ExecuteDataset("viewrunchart"); return(ds); }
public DataSet bindins() { DAclass db = new DAclass(); DataSet ds = new DataSet(); ds = db.ExecuteDataset("bindins"); return(ds); }
public void InsertIns(Keyfile p) { DAclass db = new DAclass(); SqlParameter objpara1 = new SqlParameter("@Date", p.Date); db.parameters.Add(objpara1); foreach (SqlParameter a in db.parameters) { a.Direction = ParameterDirection.Input; } db.ExecuteNonQuery("InsertIns"); }
public DataSet DeleteIns(Keyfile p) { DAclass db = new DAclass(); DataSet ds = new DataSet(); //SqlParameter objpara1 = new SqlParameter("@Date", p.Date); //db.parameters.Add(objpara1); foreach (SqlParameter a in db.parameters) { a.Direction = ParameterDirection.Input; } ds = db.ExecuteDataset("DeleteIns"); return(ds); }