// GET api/<controller>/5
public string Get(string id)
{
//chkDtModel cDModel = new chkDtModel();
//DataTable headDt = new DataTable();
//cDModel.dt1 = cc1.QueryDataTable(string.Format("select * from (chkList as cl inner join ChkItem as ci on cl.sno=ci.sno and cl.hand_order=ci.hand_order and cl.coordsID=ci.coordsID) inner join ChkPointCoords as cc on cl.sno=cc.sno and cl.coordsID=cc.coordsID where cl.chk_date=convert([date],GETDATE(),0) and cl.sno='{0}';", id));
//cDModel.dt1 = headDt;
//DataTable listDt = new DataTable();
//cDModel.dt2 = cc1.QueryDataTable(string.Format("select distinct cl.sno,cl.coordsID from (chkList as cl inner join ChkItem as ci on cl.sno=ci.sno and cl.hand_order=ci.hand_order and cl.coordsID=ci.coordsID) inner join ChkPointCoords as cc on cl.sno=cc.sno and cl.coordsID=cc.coordsID where cl.chk_date=convert([date],GETDATE(),0) and cl.sno='{0}';", id));
//cDModel.dt2 = listDt;
List <string> ls = new List <string>();
//ls.Add(string.Format("select distinct cl.sno,cl.coordsID,SubImg,coords from (chkList as cl inner join ChkItem as ci on cl.sno=ci.sno and cl.hand_order=ci.hand_order and cl.coordsID=ci.coordsID) inner join ChkPointCoords as cc on cl.sno=cc.sno and cl.coordsID=cc.coordsID where cl.chk_date=convert([date],GETDATE(),0) and cl.sno='{0}';", id));
//ls.Add(string.Format("select * from (chkList as cl inner join ChkItem as ci on cl.sno=ci.sno and cl.hand_order=ci.hand_order and cl.coordsID=ci.coordsID) inner join ChkPointCoords as cc on cl.sno=cc.sno and cl.coordsID=cc.coordsID where cl.chk_date=convert([date],GETDATE(),0) and cl.sno='{0}';", id));
//ls.Add(string.Format("select distinct mach_map from chkList as cl inner join ChkMachInfo as cio on cl.sno=cio.sno where cl.chk_date=convert([date],GETDATE(),0) and cl.sno='{0}'", id));
ls.Add(string.Format("select distinct cl.sno,cl.coordsID,SubImg,coords from (chkList as cl inner join ChkItem as ci on cl.sno=ci.sno and cl.hand_order=ci.hand_order and cl.coordsID=ci.coordsID) inner join ChkPointCoords as cc on cl.sno=cc.sno and cl.coordsID=cc.coordsID where cl.sno='{0}';", id));
ls.Add(string.Format("select * from (chkList as cl inner join ChkItem as ci on cl.sno=ci.sno and cl.hand_order=ci.hand_order and cl.coordsID=ci.coordsID) inner join ChkPointCoords as cc on cl.sno=cc.sno and cl.coordsID=cc.coordsID where cl.sno='{0}';", id));
ls.Add(string.Format("select distinct mach_map from chkList as cl inner join ChkMachInfo as cio on cl.sno=cio.sno where cl.sno='{0}'", id));
string[] dsName = { "A", "B", "C" };
DataSet x = cc1.InsertSDA(ls.ToArray(), dsName);
JsonSerializerSettings settings = new JsonSerializerSettings();
settings.Converters.Add(new CustomDataSetConverter());
settings.Formatting = Formatting.Indented;
string json = JsonConvert.SerializeObject(x, settings);
Console.WriteLine(json);
return(json);
}
