public IActionResult PrintProductionDalilyReport2(string fromdate, string todate, string[] itemprocess)
{
string result = string.Join(",", itemprocess);
var MachineCode = 13;
var S_TransDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
var E_TransDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
var list = new List <VW_MFC_ProductionDailyReport2>();
string fcode = "";
string model = "";
string ProcessCode = "";
//var jsonresult = dttable;
//var result = JsonConvert.DeserializeObject(jsonresult);
DataTable dt = new DataTable();
//JArray CleanJsonObject = JArray.Parse(jsonresult);
//dynamic data = JObject.Parse(CleanJsonObject[0].ToString());
var msgj = "";
try
{
using (var cmd = _context.Database.GetDbConnection().CreateCommand())
{
cmd.Parameters.Clear();
cmd.CommandText = "m_sp_ProductionDailyReport2";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@S_TransDate", SqlDbType.NVarChar)
{
Value = fromdate
});
cmd.Parameters.Add(new SqlParameter("@E_TransDate ", SqlDbType.NVarChar)
{
Value = todate
});
cmd.Parameters.Add(new SqlParameter("@IdProcess", SqlDbType.NVarChar)
{
Value = result
});
if (cmd.Connection.State != ConnectionState.Open)
{
cmd.Connection.Open();
}
var DbReader = cmd.ExecuteReader();
if (DbReader.HasRows)
{
dt.Load(DbReader);
if (dt.Columns.Count > 1)
{
//dt.Columns.Add("SqlStatus", typeof(System.String));
//dt.Columns.Add("SqlErrtext", typeof(System.String));
//foreach (DataRow dr in dt.Select())
//{
// dr["SqlStatus"] = "Success";
// dr["SqlErrtext"] = "";
//}
//list = (from DataRow dr in dt.Rows
// select new VW_MFC_ProductionDailyReport2()
// {
// FCode = (string)dr["FCode"],
// Model = (string)dr["Model"],
// ProcessCode = (string)dr["ProcessCode"],
// MC1 = (int)dr["MC1"],
// MC2 = (int)dr["MC2"],
// MC3 = (int)dr["MC3"],
// MC4 = (int)dr["MC4"],
// MC5 = (int)dr["MC5"],
// MC6 = (int)dr["MC6"],
// MC7 = (int)dr["MC7"],
// MC8 = (int)dr["MC8"],
// MC9 = (int)dr["MC9"],
// MC10 = (int)dr["MC10"],
// MC11 = (int)dr["MC11"],
// MC12 = (int)dr["MC12"],
// MC13 = (int)dr["MC13"],
// MC14 = (int)dr["MC14"],
// MC15 = (int)dr["MC15"],
// MC16 = (int)dr["MC16"],
// MC17 = (int)dr["MC17"],
// MC18 = (int)dr["MC18"],
// MC19 = (int)dr["MC19"],
// MC20 = (int)dr["MC20"],
// }).ToList();
//for (int i = 0; i < dt.Rows.Count; i++)
foreach (DataRow dr in dt.Select())
{
//var dr = dt.Rows[i];
if (dr["FCode"] != System.DBNull.Value)
{
fcode = (string)dr["FCode"];
}
if (dr["Model"] != System.DBNull.Value)
{
model = (string)dr["Model"];
}
if (dr["ProcessCode"] != System.DBNull.Value)
{
ProcessCode = (string)dr["ProcessCode"];
}
pdr2 = new VW_MFC_ProductionDailyReport2
{
FCode = fcode,
Model = model,
ProcessCode = ProcessCode
};
}
//list.Add(pdr2);
//}
//dt.Columns.Add("SqlStatus", typeof(System.String));
//dt.Columns.Add("SqlErrtext", typeof(System.String));
//foreach (DataRow dr in dt.Select())
//{
// dr["SqlStatus"] = "Success";
// dr["SqlErrtext"] = "";
//}
}
else
{
//dt.Columns.Add("SqlStatus", typeof(System.String));
//dt.Columns.Add("SqlErrtext", typeof(System.String));
//foreach (DataRow dr in dt.Select())
//{
// dr["SqlStatus"] = "ErrorSelectLot";
// dr["SqlErrtext"] = "";
//}
}
}
cmd.Connection.Close();
}
}
catch (SqlException ex)
{
//msgj = ex.Message;
//dt.Columns.Add("SqlStatus", typeof(System.String));
//dt.Columns.Add("SqlErrtext", typeof(System.String));
//foreach (DataRow dr in dt.Select())
//{
// dr["SqlStatus"] = "Error";
// dr["SqlErrtext"] = msgj;
//}
}
//return JsonConvert.SerializeObject(dt, Formatting.Indented);
//return Json(list);
// Response.Redirect("http://localhost:64789/PDR2/Index");
//return Redirect("http://localhost:64789/PDR2/Index");
return(RedirectToAction("Index", "PDR2", new { pdr2 }));
}
public async Task <ActionResult> Index(string fromdate, string todate, string[] itemprocess)
{
IPHostEntry heserver = Dns.GetHostEntry(Dns.GetHostName());
var ip = heserver.AddressList[1].ToString();
string token = Request.HttpContext.Session.Id.ToString();
string username = Request.HttpContext.User.Claims.FirstOrDefault().Value.ToString();
var Log_Select_Print = _context.Log_Select_Print.Where(w => w.opt == "PrintProductionDailyReport2" && w.username == username);
var PrintProductionDailyReport2 = Log_Select_Print.ToList();//เอาชุดข้อมูลของ RowNumber ที่เลือกไปมาwhere contain
var selectfcode = PrintProductionDailyReport2[0].name.ToString();
//int[] array_fcode = selectfcode.Split(',').Select(n => Convert.ToInt32(n)).ToArray();
var p = _context.s_GlobalPams.SingleOrDefault(x => x.parm_key == "DateFormat");
ViewBag.GlobalDtFormat = p.param_value; // "dd-MM-YYYY";
//string split_fcode = string.Join(",", array_fcode);
string split_process = string.Join(",", itemprocess);
ViewBag.fromdate = fromdate;
ViewBag.todate = todate;
var list = new List <VW_MFC_ProductionDailyReport2>();
string fcode = "";
string model = "";
string ProcessCode = "";
int MC1 = 0;
int MC2 = 0;
int MC3 = 0;
int MC4 = 0;
int MC5 = 0;
int MC6 = 0;
int MC7 = 0;
int MC8 = 0;
int MC9 = 0;
int MC10 = 0;
int MC11 = 0;
int MC12 = 0;
int MC13 = 0;
int MC14 = 0;
int MC15 = 0;
int MC16 = 0;
int MC17 = 0;
int MC18 = 0;
int MC19 = 0;
int MC20 = 0;
//var jsonresult = dttable;
//var result = JsonConvert.DeserializeObject(jsonresult);
DataTable dt = new DataTable();
//JArray CleanJsonObject = JArray.Parse(jsonresult);
//dynamic data = JObject.Parse(CleanJsonObject[0].ToString());
var msgj = "";
DataTable schema = null;
try
{
using (var cmd = _context.Database.GetDbConnection().CreateCommand())
{
cmd.Parameters.Clear();
cmd.CommandText = "m_sp_ProductionDailyReport2_Print";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@S_TransDate", SqlDbType.NVarChar)
{
Value = fromdate
});
cmd.Parameters.Add(new SqlParameter("@E_TransDate ", SqlDbType.NVarChar)
{
Value = todate
});
cmd.Parameters.Add(new SqlParameter("@IdProcess", SqlDbType.NVarChar)
{
Value = split_process
});
cmd.Parameters.Add(new SqlParameter("@FCode", SqlDbType.NVarChar)
{
Value = selectfcode
});
if (cmd.Connection.State != ConnectionState.Open)
{
cmd.Connection.Open();
}
var DbReader = cmd.ExecuteReader();
schema = DbReader.GetSchemaTable();
if (DbReader.HasRows)
{
dt.Load(DbReader);
var columnMC = (from dc in dt.Columns.Cast <DataColumn>()
where dc.ColumnName.Contains("MC") == true
orderby Convert.ToInt32(dc.ColumnName.ToString().Substring(2))
select dc.ColumnName).ToArray();
//if (dt.Columns.Count > 1)
//{
//dt.Columns.Add("SqlStatus", typeof(System.String));
//dt.Columns.Add("SqlErrtext", typeof(System.String));
//foreach (DataRow dr in dt.Select())
//{
// dr["SqlStatus"] = "Success";
// dr["SqlErrtext"] = "";
//}
//list = (from DataRow dr in dt.Rows
// select new VW_MFC_ProductionDailyReport2()
// {
// FCode = (string)dr["FCode"],
// Model = (string)dr["Model"],
// ProcessCode = (string)dr["ProcessCode"],
// MC1 = (int)dr["MC1"],
// MC2 = (int)dr["MC2"],
// MC3 = (int)dr["MC3"],
// MC4 = (int)dr["MC4"],
// MC5 = (int)dr["MC5"],
// MC6 = (int)dr["MC6"],
// MC7 = (int)dr["MC7"],
// MC8 = (int)dr["MC8"],
// MC9 = (int)dr["MC9"],
// MC10 = (int)dr["MC10"],
// MC11 = (int)dr["MC11"],
// MC12 = (int)dr["MC12"],
// MC13 = (int)dr["MC13"],
// MC14 = (int)dr["MC14"],
// MC15 = (int)dr["MC15"],
// MC16 = (int)dr["MC16"],
// MC17 = (int)dr["MC17"],
// MC18 = (int)dr["MC18"],
// MC19 = (int)dr["MC19"],
// MC20 = (int)dr["MC20"],
// }).ToList();
//for (int i = 0; i < dt.Rows.Count; i++)
foreach (DataRow dr in dt.Select())
{
//var dr = dt.Rows[i];
if (dr["FCode"] != System.DBNull.Value)
{
fcode = (string)dr["FCode"];
}
if (dr["Model"] != System.DBNull.Value)
{
model = (string)dr["Model"];
}
if (dr["ProcessCode"] != System.DBNull.Value)
{
ProcessCode = (string)dr["ProcessCode"];
}
//for(var x =0;x< columnMC.Length; x++)
//{
// if (columnMC[x].ToString() == "MC1")
// {
// MC1 = Convert.ToInt32(dr["MC1"]);
// }
// if (columnMC[x].ToString() == "MC2")
// {
// MC2 = Convert.ToInt32(dr["MC2"]);
// }
// if (columnMC[x].ToString() == "MC3")
// {
// MC3 = Convert.ToInt32(dr["MC3"]);
// }
// if (columnMC[x].ToString() == "MC4")
// {
// MC4 = Convert.ToInt32(dr["MC4"]);
// }
// if (columnMC[x].ToString() == "MC5")
// {
// MC5 = Convert.ToInt32(dr["MC5"]);
// }
// if (columnMC[x].ToString() == "MC6")
// {
// MC6 = Convert.ToInt32(dr["MC6"]);
// }
//}
if (dr.Table.Columns.Contains("MC1"))
{
if (dr["MC1"] != System.DBNull.Value)
{
MC1 = Convert.ToInt32(dr["MC1"]);
}
}
if (dr.Table.Columns.Contains("MC2"))
{
if (dr["MC2"] != System.DBNull.Value)
{
MC2 = Convert.ToInt32(dr["MC2"]);
}
}
if (dr.Table.Columns.Contains("MC3"))
{
if (dr["MC3"] != System.DBNull.Value)
{
MC3 = Convert.ToInt32(dr["MC3"]);
}
}
if (dr.Table.Columns.Contains("MC4"))
{
if (dr["MC4"] != System.DBNull.Value)
{
MC4 = Convert.ToInt32(dr["MC4"]);
}
}
if (dr.Table.Columns.Contains("MC5"))
{
if (dr["MC5"] != System.DBNull.Value)
{
MC5 = Convert.ToInt32(dr["MC5"]);
}
}
if (dr.Table.Columns.Contains("MC6"))
{
if (dr["MC6"] != System.DBNull.Value)
{
MC6 = Convert.ToInt32(dr["MC6"]);
}
}
if (dr.Table.Columns.Contains("MC7"))
{
if (dr["MC7"] != System.DBNull.Value)
{
MC7 = Convert.ToInt32(dr["MC7"]);
}
}
if (dr.Table.Columns.Contains("MC8"))
{
if (dr["MC8"] != System.DBNull.Value)
{
MC8 = Convert.ToInt32(dr["MC8"]);
}
}
if (dr.Table.Columns.Contains("MC9"))
{
if (dr["MC9"] != System.DBNull.Value)
{
MC9 = Convert.ToInt32(dr["MC9"]);
}
}
if (dr.Table.Columns.Contains("MC10"))
{
if (dr["MC10"] != System.DBNull.Value)
{
MC10 = Convert.ToInt32(dr["MC10"]);
}
}
if (dr.Table.Columns.Contains("MC11"))
{
if (dr["MC11"] != System.DBNull.Value)
{
MC11 = Convert.ToInt32(dr["MC11"]);
}
}
if (dr.Table.Columns.Contains("MC12"))
{
if (dr["MC12"] != System.DBNull.Value)
{
MC12 = Convert.ToInt32(dr["MC12"]);
}
}
if (dr.Table.Columns.Contains("MC13"))
{
if (dr["MC13"] != System.DBNull.Value)
{
MC13 = Convert.ToInt32(dr["MC13"]);
}
}
if (dr.Table.Columns.Contains("MC14"))
{
if (dr["MC14"] != System.DBNull.Value)
{
MC14 = Convert.ToInt32(dr["MC14"]);
}
}
if (dr.Table.Columns.Contains("MC15"))
{
if (dr["MC15"] != System.DBNull.Value)
{
MC15 = Convert.ToInt32(dr["MC15"]);
}
}
if (dr.Table.Columns.Contains("MC16"))
{
if (dr["MC16"] != System.DBNull.Value)
{
MC16 = Convert.ToInt32(dr["MC16"]);
}
}
if (dr.Table.Columns.Contains("MC17"))
{
if (dr["MC17"] != System.DBNull.Value)
{
MC17 = Convert.ToInt32(dr["MC17"]);
}
}
if (dr.Table.Columns.Contains("MC18"))
{
if (dr["MC18"] != System.DBNull.Value)
{
MC18 = Convert.ToInt32(dr["MC18"]);
}
}
if (dr.Table.Columns.Contains("MC19"))
{
if (dr["MC19"] != System.DBNull.Value)
{
MC19 = Convert.ToInt32(dr["MC19"]);
}
}
if (dr.Table.Columns.Contains("MC20"))
{
if (dr["MC20"] != System.DBNull.Value)
{
MC20 = Convert.ToInt32(dr["MC20"]);
}
}
pdr2 = new VW_MFC_ProductionDailyReport2
{
FCode = fcode,
Model = model,
ProcessCode = ProcessCode,
MC1 = MC1,
MC2 = MC2,
MC3 = MC3,
MC4 = MC4,
MC5 = MC5,
MC6 = MC6,
MC7 = MC7,
MC8 = MC8,
MC9 = MC9,
MC10 = MC10,
MC11 = MC11,
MC12 = MC12,
MC13 = MC13,
MC14 = MC14,
MC15 = MC15,
MC16 = MC16,
MC17 = MC17,
MC18 = MC18,
MC19 = MC19,
MC20 = MC20
};
//for (var i = 0; i < columnMC.Length; i++)
// {
// if (dr[columnMC[i]] != System.DBNull.Value)
// {
// foreach(var property in pdr2.GetType().GetProperties())
// {
// if(property.Name == columnMC[i])
// {
// pdr2 = new VW_MFC_ProductionDailyReport2
// {};
// }
// }
// }
// }
list.Add(pdr2);
}
ViewBag.columnMC = columnMC;
}
cmd.Connection.Close();
}
}
catch (SqlException ex)
{
//msgj = ex.Message;
//dt.Columns.Add("SqlStatus", typeof(System.String));
//dt.Columns.Add("SqlErrtext", typeof(System.String));
//foreach (DataRow dr in dt.Select())
//{
// dr["SqlStatus"] = "Error";
// dr["SqlErrtext"] = msgj;
//}
}
ViewBag.columnProcess = itemprocess;
return(View(list));
}
public IActionResult Index(string fromdate, string todate, string[] itemprocess, string[] FCode)
{
var p = _context.s_GlobalPams.SingleOrDefault(x => x.parm_key == "DateFormat");
ViewBag.GlobalDtFormat = p.param_value; // "dd-MM-YYYY";
string split_fcode = string.Join(",", FCode);
string split_process = string.Join(",", itemprocess);
var MachineCode = 13;
var S_TransDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
var E_TransDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
ViewBag.fromdate = fromdate;
ViewBag.todate = todate;
var list = new List <VW_MFC_ProductionDailyReport2>();
string fcode = "";
string model = "";
string ProcessCode = "";
int MC1 = 0;
int MC2 = 0;
int MC3 = 0;
int MC4 = 0;
int MC5 = 0;
int MC6 = 0;
int MC7 = 0;
int MC8 = 0;
int MC9 = 0;
int MC10 = 0;
int MC11 = 0;
int MC12 = 0;
int MC13 = 0;
int MC14 = 0;
int MC15 = 0;
int MC16 = 0;
int MC17 = 0;
int MC18 = 0;
int MC19 = 0;
int MC20 = 0;
//var jsonresult = dttable;
//var result = JsonConvert.DeserializeObject(jsonresult);
DataTable dt = new DataTable();
//JArray CleanJsonObject = JArray.Parse(jsonresult);
//dynamic data = JObject.Parse(CleanJsonObject[0].ToString());
var msgj = "";
DataTable schema = null;
try
{
using (var cmd = _context.Database.GetDbConnection().CreateCommand())
{
cmd.Parameters.Clear();
cmd.CommandText = "m_sp_ProductionDailyReport2_Print";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@S_TransDate", SqlDbType.NVarChar)
{
Value = fromdate
});
cmd.Parameters.Add(new SqlParameter("@E_TransDate ", SqlDbType.NVarChar)
{
Value = todate
});
cmd.Parameters.Add(new SqlParameter("@IdProcess", SqlDbType.NVarChar)
{
Value = split_process
});
cmd.Parameters.Add(new SqlParameter("@FCode", SqlDbType.NVarChar)
{
Value = split_fcode
});
if (cmd.Connection.State != ConnectionState.Open)
{
cmd.Connection.Open();
}
var DbReader = cmd.ExecuteReader();
schema = DbReader.GetSchemaTable();
if (DbReader.HasRows)
{
dt.Load(DbReader);
var columnMC = (from dc in dt.Columns.Cast <DataColumn>()
where dc.ColumnName.Contains("MC") == true
orderby Convert.ToInt32(dc.ColumnName.ToString().Substring(2))
select dc.ColumnName).ToArray();
//if (dt.Columns.Count > 1)
//{
//dt.Columns.Add("SqlStatus", typeof(System.String));
//dt.Columns.Add("SqlErrtext", typeof(System.String));
//foreach (DataRow dr in dt.Select())
//{
// dr["SqlStatus"] = "Success";
// dr["SqlErrtext"] = "";
//}
//list = (from DataRow dr in dt.Rows
// select new VW_MFC_ProductionDailyReport2()
// {
// FCode = (string)dr["FCode"],
// Model = (string)dr["Model"],
// ProcessCode = (string)dr["ProcessCode"],
// MC1 = (int)dr["MC1"],
// MC2 = (int)dr["MC2"],
// MC3 = (int)dr["MC3"],
// MC4 = (int)dr["MC4"],
// MC5 = (int)dr["MC5"],
// MC6 = (int)dr["MC6"],
// MC7 = (int)dr["MC7"],
// MC8 = (int)dr["MC8"],
// MC9 = (int)dr["MC9"],
// MC10 = (int)dr["MC10"],
// MC11 = (int)dr["MC11"],
// MC12 = (int)dr["MC12"],
// MC13 = (int)dr["MC13"],
// MC14 = (int)dr["MC14"],
// MC15 = (int)dr["MC15"],
// MC16 = (int)dr["MC16"],
// MC17 = (int)dr["MC17"],
// MC18 = (int)dr["MC18"],
// MC19 = (int)dr["MC19"],
// MC20 = (int)dr["MC20"],
// }).ToList();
//for (int i = 0; i < dt.Rows.Count; i++)
foreach (DataRow dr in dt.Select())
{
//var dr = dt.Rows[i];
if (dr["FCode"] != System.DBNull.Value)
{
fcode = (string)dr["FCode"];
}
if (dr["Model"] != System.DBNull.Value)
{
model = (string)dr["Model"];
}
if (dr["ProcessCode"] != System.DBNull.Value)
{
ProcessCode = (string)dr["ProcessCode"];
}
//for(var x =0;x< columnMC.Length; x++)
//{
// if (columnMC[x].ToString() == "MC1")
// {
// MC1 = Convert.ToInt32(dr["MC1"]);
// }
// if (columnMC[x].ToString() == "MC2")
// {
// MC2 = Convert.ToInt32(dr["MC2"]);
// }
// if (columnMC[x].ToString() == "MC3")
// {
// MC3 = Convert.ToInt32(dr["MC3"]);
// }
// if (columnMC[x].ToString() == "MC4")
// {
// MC4 = Convert.ToInt32(dr["MC4"]);
// }
// if (columnMC[x].ToString() == "MC5")
// {
// MC5 = Convert.ToInt32(dr["MC5"]);
// }
// if (columnMC[x].ToString() == "MC6")
// {
// MC6 = Convert.ToInt32(dr["MC6"]);
// }
//}
if (dr.Table.Columns.Contains("MC1"))
{
if (dr["MC1"] != System.DBNull.Value)
{
MC1 = Convert.ToInt32(dr["MC1"]);
}
}
if (dr.Table.Columns.Contains("MC2"))
{
if (dr["MC2"] != System.DBNull.Value)
{
MC2 = Convert.ToInt32(dr["MC2"]);
}
}
if (dr.Table.Columns.Contains("MC3"))
{
if (dr["MC3"] != System.DBNull.Value)
{
MC3 = Convert.ToInt32(dr["MC3"]);
}
}
if (dr.Table.Columns.Contains("MC4"))
{
if (dr["MC4"] != System.DBNull.Value)
{
MC4 = Convert.ToInt32(dr["MC4"]);
}
}
if (dr.Table.Columns.Contains("MC5"))
{
if (dr["MC5"] != System.DBNull.Value)
{
MC5 = Convert.ToInt32(dr["MC5"]);
}
}
if (dr.Table.Columns.Contains("MC6"))
{
if (dr["MC6"] != System.DBNull.Value)
{
MC6 = Convert.ToInt32(dr["MC6"]);
}
}
if (dr.Table.Columns.Contains("MC7"))
{
if (dr["MC7"] != System.DBNull.Value)
{
MC7 = Convert.ToInt32(dr["MC7"]);
}
}
if (dr.Table.Columns.Contains("MC8"))
{
if (dr["MC8"] != System.DBNull.Value)
{
MC8 = Convert.ToInt32(dr["MC8"]);
}
}
if (dr.Table.Columns.Contains("MC9"))
{
if (dr["MC9"] != System.DBNull.Value)
{
MC9 = Convert.ToInt32(dr["MC9"]);
}
}
if (dr.Table.Columns.Contains("MC10"))
{
if (dr["MC10"] != System.DBNull.Value)
{
MC10 = Convert.ToInt32(dr["MC10"]);
}
}
if (dr.Table.Columns.Contains("MC11"))
{
if (dr["MC11"] != System.DBNull.Value)
{
MC11 = Convert.ToInt32(dr["MC11"]);
}
}
if (dr.Table.Columns.Contains("MC12"))
{
if (dr["MC12"] != System.DBNull.Value)
{
MC12 = Convert.ToInt32(dr["MC12"]);
}
}
if (dr.Table.Columns.Contains("MC13"))
{
if (dr["MC13"] != System.DBNull.Value)
{
MC13 = Convert.ToInt32(dr["MC13"]);
}
}
if (dr.Table.Columns.Contains("MC14"))
{
if (dr["MC14"] != System.DBNull.Value)
{
MC14 = Convert.ToInt32(dr["MC14"]);
}
}
if (dr.Table.Columns.Contains("MC15"))
{
if (dr["MC15"] != System.DBNull.Value)
{
MC15 = Convert.ToInt32(dr["MC15"]);
}
}
if (dr.Table.Columns.Contains("MC16"))
{
if (dr["MC16"] != System.DBNull.Value)
{
MC16 = Convert.ToInt32(dr["MC16"]);
}
}
if (dr.Table.Columns.Contains("MC17"))
{
if (dr["MC17"] != System.DBNull.Value)
{
MC17 = Convert.ToInt32(dr["MC17"]);
}
}
if (dr.Table.Columns.Contains("MC18"))
{
if (dr["MC18"] != System.DBNull.Value)
{
MC18 = Convert.ToInt32(dr["MC18"]);
}
}
if (dr.Table.Columns.Contains("MC19"))
{
if (dr["MC19"] != System.DBNull.Value)
{
MC19 = Convert.ToInt32(dr["MC19"]);
}
}
if (dr.Table.Columns.Contains("MC20"))
{
if (dr["MC20"] != System.DBNull.Value)
{
MC20 = Convert.ToInt32(dr["MC20"]);
}
}
pdr2 = new VW_MFC_ProductionDailyReport2
{
FCode = fcode,
Model = model,
ProcessCode = ProcessCode,
MC1 = MC1,
MC2 = MC2,
MC3 = MC3,
MC4 = MC4,
MC5 = MC5,
MC6 = MC6,
MC7 = MC7,
MC8 = MC8,
MC9 = MC9,
MC10 = MC10,
MC11 = MC11,
MC12 = MC12,
MC13 = MC13,
MC14 = MC14,
MC15 = MC15,
MC16 = MC16,
MC17 = MC17,
MC18 = MC18,
MC19 = MC19,
MC20 = MC20
};
//for (var i = 0; i < columnMC.Length; i++)
// {
// if (dr[columnMC[i]] != System.DBNull.Value)
// {
// foreach(var property in pdr2.GetType().GetProperties())
// {
// if(property.Name == columnMC[i])
// {
// pdr2 = new VW_MFC_ProductionDailyReport2
// {};
// }
// }
// }
// }
list.Add(pdr2);
}
//foreach (DataRow col in dt.Rows)
//{
//ViewBag.column = col;
//foreach (DataColumn column in dt.Columns)
//{
// ViewBag.column = column.ColumnName;
//}
//}
//}
//dt.Columns.Add("SqlStatus", typeof(System.String));
//dt.Columns.Add("SqlErrtext", typeof(System.String));
//foreach (DataRow dr in dt.Select())
//{
// dr["SqlStatus"] = "Success";
// dr["SqlErrtext"] = "";
//}
//}
//else
//{
//dt.Columns.Add("SqlStatus", typeof(System.String));
//dt.Columns.Add("SqlErrtext", typeof(System.String));
//foreach (DataRow dr in dt.Select())
//{
// dr["SqlStatus"] = "ErrorSelectLot";
// dr["SqlErrtext"] = "";
//}
//}
ViewBag.columnMC = columnMC;
}
cmd.Connection.Close();
}
}
catch (SqlException ex)
{
//msgj = ex.Message;
//dt.Columns.Add("SqlStatus", typeof(System.String));
//dt.Columns.Add("SqlErrtext", typeof(System.String));
//foreach (DataRow dr in dt.Select())
//{
// dr["SqlStatus"] = "Error";
// dr["SqlErrtext"] = msgj;
//}
}
ViewBag.columnProcess = itemprocess;
//var data = new
//{
// items = list.Select(item => new
// {
// FCode = item.FCode,
// Model = item.Model,
// ProcessCode = item.ProcessCode
// })
//};
return(View(list));
//return View(Json(dt));
}
