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 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);
}
