public HttpResponseMessage postPrintTag(PrintTagView model)
{
try
{
tagSvc.PringTag(model);
return(Request.CreateResponse(HttpStatusCode.OK, "ส่งข้อมูลไปยังเครื่องพิมพ์เรียบร้อยแล้ว"));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message.ToString()));
}
}
public PrintTagView AddTag(PrintTagSearchView model)
{
using (var ctx = new ConXContext())
{
var ventity = model.entity;
var vreq_date = model.req_date;
var vwc_code = model.wc_code;
var vmc_code = model.mc_code;
var vspring_grp = model.spring_grp;
var vsize_desc = model.size_desc;
var vqty = model.qty;
var vuser_id = model.user_id;
var vprinter = model.printer;
//int vprocess_tag_no = 0;
PrintTagView view = new ModelViews.PrintTagView()
{
datas = new List <ModelViews.RawMatitemView>()
};
//string sqlp = "select a.prnt_point_name from whmobileprnt_ctl where grp_type='SPRING' and series_no=:p_printer";\
string sqlp = "select a.prnt_point_name printer_name from whmobileprnt_ctl a , whmobileprnt_default b where a.series_no = b.series_no and b.mc_code= :p_mc_code";
string printer_name = ctx.Database.SqlQuery <string>(sqlp, new OracleParameter("p_mc_code", vmc_code)).FirstOrDefault();
string sqls = "select pdsize_tname from pdsize_mast where pdsize_code=:p_size_code";
string vsize_name = ctx.Database.SqlQuery <string>(sqls, new OracleParameter("p_size_code", vsize_desc)).FirstOrDefault();
string sql = "select nvl(max(process_tag_no),0) process_tag_no , max(to_char(req_date,'dd/mm/yyyy')) req_date , max(mc_code) , max(to_char(fin_date,'dd/mm/yyyy')) fin_date";
sql += " from mps_det_in_process_tag";
sql += " where entity = :p_entity";
sql += " and req_date = to_date(:p_req_date,'dd/mm/yyyy')";
sql += " and mc_code = :p_mc_code";
// sql += " and rownum = 1";
sql += " order by process_tag_no";
PrintTagView tag = ctx.Database.SqlQuery <PrintTagView>(sql, new OracleParameter("p_entity", ventity), new OracleParameter("p_req_date", vreq_date), new OracleParameter("p_mc_code", vmc_code)).SingleOrDefault();
if (tag.process_tag_no == 0)
{
view.entity = ventity;
view.process_tag_no = 1;
view.req_date = vreq_date;
view.wc_code = vwc_code;
view.mc_code = vmc_code;
view.spring_grp = vspring_grp;
view.size_desc = vsize_name;
view.qty = vqty;
view.fin_date = DateTime.Now.ToShortDateString();
view.printer = printer_name;
}
else
{
view.entity = ventity;
view.process_tag_no = tag.process_tag_no + 1;
view.req_date = tag.req_date;
view.wc_code = tag.wc_code;
view.mc_code = vmc_code;
view.spring_grp = vspring_grp;
view.size_desc = vsize_name;
view.qty = vqty;
view.fin_date = tag.fin_date;
view.printer = printer_name;
}
//return data to contoller
return(view);
}
}
public PrintTagView searchProcessTagNo(ProcessTagNoSearch model)
{
using (var ctx = new ConXContext())
{
var ventity = model.entity;
var vreq_date = model.req_date;
var vwc_code = model.wc_code;
var vmc_code = model.mc_code;
var vspring_grp = model.spring_grp;
var vsize_desc = model.size_desc;
var vqty = model.qty;
//var vuser_id = model.user_id;
var vprinter = model.printer;
int vprocess_tag_no = model.process_tag_no;
PrintTagView view = new ModelViews.PrintTagView()
{
datas = new List <ModelViews.RawMatitemView>()
};
string sqlp = "select prnt_point_name from whmobileprnt_ctl where grp_type='SPRING' and series_no=:p_printer";
string vprinter_name = ctx.Database.SqlQuery <string>(sqlp, new OracleParameter("p_printer", vprinter)).FirstOrDefault();
string sqls = "select pdsize_tname from pdsize_mast where pdsize_code=:p_size_code";
string vsize_name = ctx.Database.SqlQuery <string>(sqls, new OracleParameter("p_size_code", vsize_desc)).FirstOrDefault();
//string sql = "select max(process_tag_no) process_tag_no , max(to_char(req_date,'dd/mm/yyyy')) req_date , max(mc_code) , max(to_char(fin_date,'dd/mm/yyyy')) fin_date";
string sql = "select process_tag_no , to_char(req_date,'dd/mm/yyyy') req_date , mc_code , to_char(fin_date,'dd/mm/yyyy') fin_date";
sql += " from mps_det_in_process_tag";
sql += " where entity = :p_entity";
sql += " and req_date = to_date(:p_req_date,'dd/mm/yyyy')";
sql += " and mc_code = :p_mc_code";
sql += " and process_tag_no = :p_process_tag_no";
sql += " and rownum = 1";
sql += " order by process_tag_no desc";
PrintTagView tag = ctx.Database.SqlQuery <PrintTagView>(sql, new OracleParameter("p_entity", ventity), new OracleParameter("p_req_date", vreq_date), new OracleParameter("p_mc_code", vmc_code), new OracleParameter("p_process_tag_no", vprocess_tag_no)).SingleOrDefault();
if (tag == null)
{
vprocess_tag_no = 1;
view.entity = ventity;
view.process_tag_no = vprocess_tag_no;
view.req_date = vreq_date;
view.wc_code = vwc_code;
view.mc_code = vmc_code;
view.spring_grp = vspring_grp;
view.size_desc = vsize_name;
view.qty = vqty;
view.fin_date = DateTime.Now.ToShortDateString();
view.printer = vprinter_name;
}
else
{
//vprocess_tag_no = tag.process_tag_no;
view.entity = ventity;
view.process_tag_no = tag.process_tag_no;
view.req_date = tag.req_date;
view.wc_code = tag.wc_code;
view.mc_code = vmc_code;
view.spring_grp = vspring_grp;
view.size_desc = vsize_name;
view.qty = vqty;
view.fin_date = tag.fin_date;
view.printer = vprinter_name;
}
string sqlr = "select process_tag_no , ref_doc_no doc_no , prod_code , prod_tname prod_name";
sqlr += " from mps_det_in_process_tag";
sqlr += " where entity = :p_entity";
sqlr += " and req_date = to_date(:p_req_date,'dd/mm/yyyy')";
sqlr += " and mc_code = :p_mc_code";
//sqlr += " and process_tag_no = :p_process_tag_no";
sqlr += " order by seq_no";
List <RawMatitemView> scan = ctx.Database.SqlQuery <RawMatitemView>(sqlr, new OracleParameter("p_entity", ventity), new OracleParameter("p_req_date", vreq_date), new OracleParameter("p_mc_code", vmc_code)).ToList();
foreach (var i in scan)
{
view.datas.Add(new ModelViews.RawMatitemView()
{
process_tag_no = i.process_tag_no,
doc_no = i.doc_no,
prod_code = i.prod_code,
prod_name = i.prod_name
});
}
//return data to contoller
return(view);
}
}
public void PringTag(PrintTagView model)
{
System.Diagnostics.Process.Start("net.exe", @"use L: / delete");
System.Diagnostics.Process.Start("net.exe", @"use L: \\192.168.8.14\Data TOP@007* /USER:192.168.8.14\webadmin").WaitForExit();
using (var ctx = new ConXContext())
{
var ventity = model.entity;
var vprocess_tag_no = model.process_tag_no;
//var vreq_date = model.req_date;
var vmc_code = model.mc_code;
var vqty = model.qty;
var vprinter = model.printer;
var vfin_date = DateTime.Now.ToShortDateString();
var vspring_grp = model.spring_grp;
var vsize_desc = model.size_desc;
var vuser_id = model.user_id;
DateTime vreq_date = Convert.ToDateTime(model.req_date);
//int vitem = 1;
string sqls = "select pdsize_tname from pdsize_mast where pdsize_code=:p_size_code";
string vsize_name = ctx.Database.SqlQuery <string>(sqls, new OracleParameter("p_size_code", vsize_desc)).FirstOrDefault();
string sqli = "select nvl(max(seq_no),0)+1 from mps_det_in_process_tag where entity=:p_entity and req_date = to_date(:p_req_date,'dd/mm/yyyy') and mc_code = :p_mc_code";
int item = ctx.Database.SqlQuery <int>(sqli, new OracleParameter("p_entity", ventity), new OracleParameter("p_req_date", model.req_date), new OracleParameter("p_mc_code", vmc_code)).SingleOrDefault();
string sql = "select prod_code from mps_det_in_process_tag where entity=:p_entity and req_date = to_date(:p_req_date,'dd/mm/yyyy') and mc_code = :p_mc_code and process_tag_no = :p_process_tag_no and rownum = 1";
string chk_tag = ctx.Database.SqlQuery <string>(sql, new OracleParameter("p_entity", ventity), new OracleParameter("p_req_date", model.req_date), new OracleParameter("p_mc_code", vmc_code), new OracleParameter("p_process_tag_no", vprocess_tag_no)).SingleOrDefault();
if (chk_tag == null)
{
using (TransactionScope scope = new TransactionScope())
{
//mps_det_in_process_tag tag = ctx.mps_tag
//.Where(z => z.ENTITY == ventity
// && System.Data.Entity.DbFunctions.TruncateTime(z.REQ_DATE) == System.Data.Entity.DbFunctions.TruncateTime(vreq_date)
// && z.MC_CODE == vmc_code && z.PROCESS_TAG_NO == vprocess_tag_no).SingleOrDefault();
string sqlt = "select prod_code from mps_det_in_process_tag where entity=:p_entity and req_date = to_date(:p_req_date,'dd/mm/yyyy') and mc_code = :p_mc_code and process_tag_no = :p_process_tag_no and rownum = 1";
string tag = ctx.Database.SqlQuery <string>(sqlt, new OracleParameter("p_entity", ventity), new OracleParameter("p_req_date", model.req_date), new OracleParameter("p_mc_code", vmc_code), new OracleParameter("p_process_tag_no", vprocess_tag_no)).SingleOrDefault();
if (tag == null)
{
string strConn = ConfigurationManager.ConnectionStrings["OracleDbContext"].ConnectionString;
var dataConn = new OracleConnectionStringBuilder(strConn);
OracleConnection conn = new OracleConnection(dataConn.ToString());
conn.Open();
foreach (var i in model.datas)
{
if (i.process_tag_no == vprocess_tag_no)
{
//mps_det_in_process_tag newObj = new mps_det_in_process_tag()
//{
// ENTITY = ventity,
// REQ_DATE = vreq_date,
// FIN_DATE = DateTime.Now,
// MC_CODE = vmc_code,
// PROCESS_TAG_NO = vprocess_tag_no,
// PROCESS_TAG_QR = "",
// SEQ_NO = item,
// REF_DOC_NO = i.doc_no,
// PROD_CODE = i.prod_code,
// PROD_TNAME = i.prod_name,
// UPD_BY = vuser_id,
// UPD_DATE = DateTime.Now
//};
//item++;
//ctx.mps_tag.Add(newObj);
//ctx.SaveChanges();
////scope.Complete();
OracleCommand oraCommand = conn.CreateCommand();
OracleParameter[] param = new OracleParameter[]
{
new OracleParameter("p_entity", ventity),
new OracleParameter("p_req_date", vreq_date),
//new OracleParameter("p_fin_date",DateTime.Now),
new OracleParameter("p_mc_code", vmc_code),
new OracleParameter("p_process_tag_no", vprocess_tag_no),
new OracleParameter("p_process_tag_qr", ""),
new OracleParameter("p_seq_no", item),
new OracleParameter("p_doc_no", i.doc_no),
new OracleParameter("p_prod_code", i.prod_code),
new OracleParameter("p_prod_name", i.prod_name),
new OracleParameter("p_upd_by", vuser_id),
//new OracleParameter("p_upd_date", DateTime.Now),
};
oraCommand.BindByName = true;
oraCommand.Parameters.AddRange(param);
oraCommand.CommandText = "insert into mps_det_in_process_tag (entity , req_date , mc_code , seq_no , fin_date , process_tag_no , process_tag_qr , ref_doc_no , prod_code ,prod_tname , upd_by , upd_date) values (:p_entity , :p_req_date , :p_mc_code , :p_seq_no , SYSDATE , :p_process_tag_no , :p_process_tag_qr , :p_doc_no , :p_prod_code , :p_prod_name , :p_upd_by , SYSDATE)";
oraCommand.ExecuteNonQuery();
item++;
}
}
conn.Close();
scope.Complete();
}
}
}
var vdoc_no = "";
var vprod_code = "";
string[] tag_sticker;
tag_sticker = new string[vqty];
string sqlp = "select a.prnt_point_name printer_name , filepath_data , filepath_txt from whmobileprnt_ctl a , whmobileprnt_default b where a.series_no = b.series_no and b.mc_code= :p_mc_code";
PrinterDataView printer = ctx.Database.SqlQuery <PrinterDataView>(sqlp, new OracleParameter("p_mc_code", vmc_code)).SingleOrDefault();
string sqlf = "select form_no from doc_mast where systemid='PD' and doc_code='SP'";
string vform_no = ctx.Database.SqlQuery <string>(sqlf).FirstOrDefault();
//string sqlp = "select filepath_txt from whmobileprnt_ctl where series_no =:p_printer";
//string docPath = ctx.Database.SqlQuery<string>(sqlp, new OracleParameter("p_printer", vprinter)).SingleOrDefault();
//string docPath = "d:\\data\\trigger.txt";
//string docPath = "L:\\PRINT_POINT7\\trigger.txt";
//Map Drive
//System.Diagnostics.Process.Start("net.exe", @"use L: \\192.168.8.14\Data").WaitForExit();
//string txtPath = @"L:\PRINT_POINT7\trigger.txt";
//string dataPath = @"L:\PRINT_POINT7\barcfmic.txt";
string txtPath = @printer.filepath_txt;
string dataPath = @printer.filepath_data;
Console.WriteLine("Data File", printer.filepath_data);
Console.WriteLine("Data File", printer.filepath_txt);
//Write Text File
foreach (var k in model.datas)
{
if (k.process_tag_no == vprocess_tag_no)
{
vdoc_no = vdoc_no + "," + k.doc_no;
vprod_code = vprod_code + "," + k.prod_code;
}
}
string all_txt = "";
string txt = vspring_grp + "@" + vsize_desc + "@" + vsize_name + "@" + vdoc_no.Trim(',') + "@" + vprod_code.Trim(',') + "@" + model.req_date + "@" + vfin_date + "@" + vspring_grp + "|" + vsize_desc + "|" + "" + vsize_name + "|" + vdoc_no.Trim(',') + "|" + vprod_code.Trim(',') + "|" + model.req_date + '@' + vform_no;
for (int j = 0; j < vqty; j++)
{
//tag_sticker[j] = txt;
if (j == 0)
{
all_txt = txt + Environment.NewLine;;
}
else
{
all_txt = all_txt + txt + Environment.NewLine;
}
}
//File.WriteAllText(Path.Combine(dataPath), all_txt);
//File.WriteAllText(Path.Combine(txtPath), "");
File.WriteAllText(dataPath, all_txt);
File.WriteAllText(txtPath, "");
//System.Diagnostics.Process.Start("net.exe", @"use L: / delete");
}
}