public List <EmailNeedSend> GetEmailNeedSends(string reportName)
{
List <EmailNeedSend> listEmailsend = new List <EmailNeedSend>();
try
{
DataTable dt = new DataTable();
StringBuilder sqllistmail = new StringBuilder();
sqllistmail.Append("select emailaddress, deptcode, status, usingfunction from m_email where status = 'YES' and usingfunction = '" + reportName + "'");
sqlCON tf = new sqlCON();
tf.sqlDataAdapterFillDatatable(sqllistmail.ToString(), ref dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
EmailNeedSend item = new EmailNeedSend();
item.EmailReceive = dt.Rows[i]["emailaddress"].ToString();
item.DepartmentCode = dt.Rows[i]["deptcode"].ToString();
item.Status = dt.Rows[i]["status"].ToString();
item.Function = dt.Rows[i]["usingfunction"].ToString();
listEmailsend.Add(item);
}
dt = null;
}
catch (Exception ex)
{
Logfile.Output(StatusLog.Error, "Load list email send fail ", ex.Message);
}
return(listEmailsend);
}
private void cmb_process_SelectedIndexChanged(object sender, EventArgs e)
{
cmb_ip.Items.Clear();
sqlCON data = new sqlCON();
data.getComboBoxData("select distinct IPPLC from m_ipPLC where process = '" + cmb_process.Text + "' ", ref cmb_ip);
}
private void Adruino_Load(object sender, EventArgs e)
{
string sql = "select distinct machine from t_andruino order by machine";
sqlCON conERP = new sqlCON();
conERP.getComboBoxData(sql, ref cmb_machine);
}
private void AddERPConfigMail_Load(object sender, EventArgs e)
{
sqlCON dept = new sqlCON();
string sqldept = "select distinct deptcode from m_dept order by deptcode";
dept.getComboBoxData(sqldept, ref cmb_deptcode);
sqlCON function = new sqlCON();
string sqlfunction = "select distinct usingfunction from m_email order by usingfunction";
function.getComboBoxData(sqlfunction, ref cmb_usingfunction);
cmb_defaultstatus.Items.Add("YES");
cmb_defaultstatus.Items.Add("NO");
if (Class.valiballecommon.GetStorage().value1 != null)
{
cmb_deptcode.Text = Class.valiballecommon.GetStorage().value1;
txt_emailaddress.Text = Class.valiballecommon.GetStorage().value2;
cmb_usingfunction.Text = Class.valiballecommon.GetStorage().value3;
cmb_defaultstatus.Text = Class.valiballecommon.GetStorage().value4;
txt_emailaddress.Enabled = false;
Class.valiballecommon va = Class.valiballecommon.GetStorage();
va.value1 = null;
va.value2 = null;
va.value3 = null;
va.value4 = null;
addupdate = 0;
}
else
{
addupdate = 1;
}
}
void Inspect_Tree(string model)
{
if (model != "")
{
DataTable dt = new DataTable();
model = cmb_modelcode.Text;
sqlCON connect = new sqlCON();
connect.sqlDataAdapterFillDatatable("select distinct item from m_pqmdata where model = '" + model + "' and process = '" + cmb_processcode.Text + "'", ref dt);
//dgvData.DataSource = dt;
string str = "";
TreeNode root = new TreeNode()
{
Text = model
};
tv_model.Nodes.Add(root);
for (int i = 0; i < dt.Rows.Count; i++)
{
str = dt.Rows[i]["item"].ToString();
TreeNode nodes = new TreeNode()
{
Text = str
};
root.Nodes.Add(nodes);
}
}
}
public NGItemsMapping GetNGMapping(string Dept, string process, string NGPLC)
{
List <NGItemsMapping> nGItemsMappings = new List <NGItemsMapping>();
StringBuilder sql = new StringBuilder();
sql.Append("select distinct modelcode, processcode, processname, itemcode, itemname ");
sql.Append("from m_process ");
sql.Append("where 1=1 ");
sql.Append("and modelcode = '" + Dept + "' ");
sql.Append("and processcode = '" + NGPLC + "' ");
sql.Append("and processname = '" + process + "' ");
sqlCON sql12 = new sqlCON();
DataTable dt = new DataTable();
sql12.sqlDataAdapterFillDatatable(sql.ToString(), ref dt);
nGItemsMappings = (from DataRow dr in dt.Rows
select new NGItemsMapping()
{
Department = dr["modelcode"].ToString(),
NGCode_Process = dr["processcode"].ToString(),
NGCodeName_Process = dr["processname"].ToString(),
NGCode_SFT = dr["itemcode"].ToString(),
NGCodeName_SFT = dr["itemname"].ToString()
}).ToList();
if (nGItemsMappings != null && nGItemsMappings.Count > 0)
{
return(nGItemsMappings[0]);
}
else
{
return(null);
}
}
public List <SettingBOM> LoadingSettingBOMsFilter(string ProductNo)
{
List <SettingBOM> settingBOMs = new List <SettingBOM>();
try
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(" select productName, productNo,QTyinBox, QtyTool from t_settingBOM ");
stringBuilder.Append(" where productName like '%" + ProductNo + "%'");
sqlCON sqlCON = new sqlCON();
DataTable dt = new DataTable();
sqlCON.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt);
settingBOMs = (from DataRow dr in dt.Rows
select new SettingBOM()
{
ProductName = (dr["ProductName"] != null) ? dr["ProductName"].ToString().Trim() : "",
ProductNo = (dr["productNo"] != null) ? dr["productNo"].ToString().Trim() : "",
QtyInBox = (dr["QTyinBox"].ToString() != null) ? int.Parse(dr["QTyinBox"].ToString().Trim()) : 0,
QtyTool = (dr["QtyTool"].ToString() != null) ? int.Parse(dr["QtyTool"].ToString().Trim()) : 0
}).ToList();
}
catch (Exception)
{
return(null);
}
return(settingBOMs);
}
private void ProcessForm_Load(object sender, EventArgs e)
{
sqlCON connect = new sqlCON();
string sql = "select distinct modelcode from m_model order by modelcode";
connect.getComboBoxData(sql, ref cmb_modelcode);
}
public bool InsertERPOutPQC(WMS.Model.PQCOutStock pQCOutStock)
{
try
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(" insert into t_ERP_OutPQCQR (KeyID,KeyNo,STT,ProductOrder ,Product, Quantity, LotNo, Warehouse, dateCreate, TL111, SubQR) values (");
stringBuilder.Append(" '" + pQCOutStock.KeyID + "', ");
stringBuilder.Append(" '" + pQCOutStock.KeyNo + "', ");
stringBuilder.Append(" '" + pQCOutStock.STT + "', ");
stringBuilder.Append(" '" + pQCOutStock.ProductOrder + "', ");
stringBuilder.Append(" '" + pQCOutStock.Product + "', ");
stringBuilder.Append(" '" + pQCOutStock.Quantity + "', ");
stringBuilder.Append(" '" + pQCOutStock.LotNo + "', ");
stringBuilder.Append(" '" + pQCOutStock.Warehouse + "', ");
stringBuilder.Append(" " + "GETDATE()" + ", ");
stringBuilder.Append(" '" + Class.valiballecommon.GetStorage().DBERP + "', ");
stringBuilder.Append(" '" + pQCOutStock.QRcodeGenarate + "') ");
sqlCON sqlCON = new sqlCON();
return(sqlCON.sqlExecuteNonQuery(stringBuilder.ToString(), false));
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "InsertERPOutPQC(WMS.Model.PQCOutStock pQCOutStock)", ex.Message);
}
return(false);
}
private void Tabcontrol_SelectedIndexChanged(object sender, EventArgs e)
{
switch ((sender as TabControl).SelectedIndex)
{
case 0:
string sqlQuerry = "select FunctionGroup,FunctionName,TiengViet,English,Chinese from t_language ";
sqlCON sqlcon = new sqlCON();
DataTable dt = new DataTable();
sqlcon.sqlDataAdapterFillDatatable(sqlQuerry, ref dt);
dtgv_SettingLanguage.DataSource = null;
dtgv_SettingLanguage.DataSource = dt;
// Do nothing here (let's suppose that TabPage index 0 is the address information which is already loaded.
break;
case 1:
break;
case 2:
break;
}
}
private void Btn_delete_Click(object sender, EventArgs e)
{
try
{
LanguageClass language = new LanguageClass();
language.functionGroup = txt_functionGroup.Text;
language.functionName = txt_functionName.Text;
language.Tiengviet = txt_tiengViet.Text;
language.English = txt_english.Text;
language.Chinese = txt_Chinese.Text;
LanguageSetting languageSetting = new LanguageSetting();
languageSetting.DeleteRowofLanguageSetting(language);
string sqlQuerry = "select FunctionGroup,FunctionName,TiengViet,English,Chinese from t_language ";
sqlCON sqlcon = new sqlCON();
DataTable dt = new DataTable();
sqlcon.sqlDataAdapterFillDatatable(sqlQuerry, ref dt);
dtgv_SettingLanguage.DataSource = null;
dtgv_SettingLanguage.DataSource = dt;
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "delete row", ex.Message);
}
}
void datashow()
{
dtshow = new DataTable();
DateTime dateto = dtp_todate.Value;
DateTime datefrom = dtp_from.Value;
StringBuilder sql = new StringBuilder();
sql.Append(@"select
CONVERT(date,t_octcs.TC01) as Create_Date,
t_octcs.TC02 + '-'+ t_octcs.TC03 as code ,
t_octcs.TC05 as Clients,
avg(CAST(t_octcs.TC32 as float)) as Shipping_Percent ,
max(CONVERT(date,t_octcs.TC17)) as Delivery_Date ,
max(CONVERT(date,t_octcs.TC12)) as Client_Request_Date
from t_OCTC t_octcs
left join t_OCTB t_octbs on t_octcs.TC02 = t_octbs.TB02 and t_octcs.TC03 = t_octbs.TB03
where 1=1
");
sql.Append(" and CONVERT(date,t_octcs.TC01) >= '" + datefrom + "' ");
sql.Append(" and CONVERT(date,t_octcs.TC01) <= '" + dateto + "' ");
sql.Append(@" group by t_octcs.TC01, t_octcs.TC02 + '-'+ t_octcs.TC03, t_octcs.TC05");
sql.Append(" order by t_octcs.TC02 + '-'+ t_octcs.TC03 ");
sqlCON con = new sqlCON();
con.sqlDataAdapterFillDatatable(sql.ToString(), ref dtshow);
}
void datashow()
{
dtshow = new DataTable();
DateTime dateto = dtp_to.Value;
DateTime datefrom = dtp_from.Value;
string strChooseDeptoFilter = ChooseDeptoSQLcommand(trv_department);
StringBuilder sql = new StringBuilder();
sql.Append(@"select
CONVERT(date,t_octcs.TC01) as Create_Date,
t_octcs.TC02 as Code_Type,
t_octcs.TC03 as Code_No,
t_octcs.TC05 as Clients,
t_octcs.TC06 as Clients_Order_Code,
t_octcs.TC07 as Product_Code,
t_octcs.TC08 as Product_Name,
avg(CAST(t_octcs.TC32 as float)) as Shipping_Percent ,
max(CONVERT(date,t_octcs.TC17)) as Delivery_Date ,
max(CONVERT(date,t_octcs.TC12)) as Client_Request_Date,
t_octbs.TB13 as FinishedGoods,
t_octbs.TB14 as NGQuantity,
t_octbs.TB15 as OKQuantity,
t_octbs.TB32 as Good_product_ratio,
t_octbs.TB34 as Production_Rate,
t_octms.TM10 as Production_Status
from t_OCTM t_octms
left join t_OCTC t_octcs on t_octcs.TC02 = t_octms.TM02 and t_octcs.TC03 = t_octms.TM03
left join t_OCTB t_octbs on t_octcs.TC02 = t_octbs.TB02 and t_octcs.TC03 = t_octbs.TB03
");
sql.Append(" where 1=1 ");
if (cmd_COPTC_TC001.Text != "" && cmd_COPTC_TC002.Text != "")
{
sql.Append(" and t_octcs.TC02 = '" + cmd_COPTC_TC001.Text + "'");
sql.Append(" and t_octcs.TC03 = '" + cmd_COPTC_TC002.Text + "'");
}
else
{
if (ChooseDeptoSQLcommand(trv_department) != "")
{
sql.Append(ChooseDeptoSQLcommand(trv_department));
}
else
{
MessageBox.Show("Please choose departments which you want to search data ! ", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
sql.Append(" and CONVERT(date,t_octcs.TC01) >= '" + datefrom + "' ");
sql.Append(" and CONVERT(date,t_octcs.TC01) <= '" + dateto + "' ");
}
sql.Append(@" group by t_octcs.TC01, t_octcs.TC03 , t_octcs.TC02, t_octcs.TC05, t_octcs.TC06, t_octcs.TC07, t_octcs.TC08,t_octbs.TB13,t_octbs.TB14,t_octbs.TB15,t_octbs.TB32,t_octbs.TB34,t_octms.TM10");
sql.Append(" order by t_octcs.TC02, t_octcs.TC03");
sqlCON con = new sqlCON();
con.sqlDataAdapterFillDatatable(sql.ToString(), ref dtshow);
}
public bool UpdateBuyerInfor(DataTable dtRowUpdate)
{
try
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(" update t_TL_BuyerInfo ");
stringBuilder.Append(" set Buyer_ERP = '" + dtRowUpdate.Rows[0]["Buyer_ERP"] + "' , ");
stringBuilder.Append(" Buyer_Infor = '" + dtRowUpdate.Rows[0]["Buyer_Infor"] + "' , ");
stringBuilder.Append(" Buyer_Consignee = '" + dtRowUpdate.Rows[0]["Buyer_Consignee"] + "', ");
stringBuilder.Append(" Date_Update = '" + DateTime.Now.ToString("yyyyMMdd HH:mm:ss") + "' ");
stringBuilder.Append(" where BuyerCode = '" + dtRowUpdate.Rows[0]["BuyerCode"] + "' ");
sqlCON sqlCON = new sqlCON();
var update = sqlCON.sqlExecuteNonQuery(stringBuilder.ToString(), false);
if (update == false)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "UpdateBuyerInfor(DataTable dtRowUpdate)", "false");
return(false);
}
return(true);
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "UpdateBuyerInfor(DataTable dtRowUpdate)", ex.Message);
return(false);
}
}
private void btn_add_Click(object sender, EventArgs e)
{
if (cmb_modelcode.Text == "" || tv_line.Nodes[0].Nodes.Count < 1)
{
return;
}
string sqldelete = "delete from m_model_line where modelcode = '" + cmb_modelcode.Text + "'";
sqlCON connect = new sqlCON();
connect.sqlExecuteNonQuery(sqldelete, false); //false không xuất hiện thông báo
for (int i = 0; i < tv_line.Nodes[0].Nodes.Count; i++)
{
//if (tv_line.Nodes[0].Nodes[i].Checked)
//{
// MessageBox.Show(tv_line.Nodes[0].Nodes[i].Text);
//}
string sqladd = @"insert into m_model_line(modelcode, linecode, status, datetimeRST) values ('"
+ cmb_modelcode.Text + "','" + tv_line.Nodes[0].Nodes[i].Text + "','"
+ tv_line.Nodes[0].Nodes[i].Checked.ToString() + "',GETDATE())";
connect.sqlExecuteNonQuery(sqladd, false);
}
infomesge infor = new infomesge();
infor.WarningMesger("Update is Ok", "INFO", this);
getdgvfull(cmb_modelcode.Text);
}
public DataTable GetDataTableImportSummary(DateTime dtFrom, DateTime dtTo, bool rd_importdate)
{
DataTable dt = new DataTable();
try
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(" select * from t_ERP_OutPQCQR where 1=1 ");
if (rd_importdate == false)
{
stringBuilder.Append(" and dateCreate >= '" + dtFrom.ToString("yyyyMMdd") + "' ");
stringBuilder.Append(" and dateCreate <= '" + dtTo.AddDays(1).ToString("yyyyMMdd") + "' ");
}
else
{
stringBuilder.Append(" and dateImport >= '" + dtFrom.ToString("yyyyMMdd") + "' ");
stringBuilder.Append(" and dateImport <= '" + dtTo.AddDays(1).ToString("yyyyMMdd") + "' ");
}
stringBuilder.Append(" and TL111 = '" + Class.valiballecommon.GetStorage().DBERP + "' ");
sqlCON sqlCON = new sqlCON();
sqlCON.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt);
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, " GetDataTableImportSummary(DateTime dtFrom, DateTime dtTo)", ex.Message);
}
return(dt);
}
public bool InsertToMQCMES_Realtime(string QRMES, string QRID, string line, string item, string data, string Remark)
{
try
{
string datetimeserno = DateTime.Now.ToString("yyyyMMdd_HHmmss");
string serno = QRMES;
string site = "B01";
string factory = "TECHLINK";
string process = "MQC";
string status = "";
string date_ = DateTime.Now.ToString("yyyy-MM-dd");
string time_ = DateTime.Now.ToString("HH:mm:ss");
string sqlQuerry = "";
// string model = GetModelFromLot(lot,setting);
QRMQC_MES qRMQC_MES = QRSpilittoClass.QRstring2MQCFormat(QRMES);
QRIDMES qRIDMES = QRSpilittoClass.QRstring2IDFormat(QRID);
sqlQuerry += "insert into m_ERPMQC_REALTIME (serno, lot, model, site, factory, line, process,item,inspectdate,inspecttime, data, judge,status,remark ) values( '";
sqlQuerry += serno + "', '" + qRMQC_MES.PO + "', '" + qRMQC_MES.Product + "', '" + site + "', '" + factory + "', '" + line +
"', '" + process + "', '" + item + "', '" + date_ + "', '" + time_ + "', '" + data + "', '" + qRIDMES.ID + "', '" + status + "', '" + Remark + "' )";
sqlCON localPLC = new sqlCON();
return(localPLC.sqlExecuteNonQuery(sqlQuerry, false));
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "InsertToMQC_Realtime(string lot, string line, string item, string data, string Remark, int judge)", ex.Message);
return(false);
}
}
public bool UpdateImportWarehouse(DataTable dtOutPQC, string ERPCode)
{
try
{
for (int i = 0; i < dtOutPQC.Rows.Count; i++)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(" update t_ERP_OutPQCQR ");
stringBuilder.Append(" set ImportFlag = '" + "Y" + "', ");
stringBuilder.Append(" TL112 = '" + Class.valiballecommon.GetStorage().DBERP + "', ");
stringBuilder.Append(" TL113 = '" + ERPCode + "', ");
stringBuilder.Append(" dateImport = '" + DateTime.Now.ToString("yyyyMMdd HH:mm:ss") + "' ");
stringBuilder.Append(" where KeyID ='" + dtOutPQC.Rows[i]["KeyID"].ToString() + "' ");
stringBuilder.Append(" and KeyNo ='" + dtOutPQC.Rows[i]["KeyNo"].ToString() + "' ");
stringBuilder.Append(" and STT ='" + dtOutPQC.Rows[i]["STT"].ToString() + "' ");
sqlCON sqlCON = new sqlCON();
var update = sqlCON.sqlExecuteNonQuery(stringBuilder.ToString(), false);
if (update == false)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "Update Flag Import finished goods fail!", "");
return(false);
}
}
return(true);
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "UpdateImportWarehouse(DataTable dtOutPQC)", ex.Message);
return(false);
}
}
public List <NGItemsMapping> listNGMappingGetReportTop16(string Dept, string processname)
{
List <NGItemsMapping> nGItemsMappings = new List <NGItemsMapping>();
StringBuilder sql = new StringBuilder();
sql.Append("select distinct modelcode, processcode, processname, itemcode, itemname, note ");
sql.Append("from m_process ");
sql.Append("where 1=1 and note like '%Top16%' ");
sql.Append("and modelcode = '" + Dept + "' ");
sql.Append("and processname = '" + processname + "' ");
sqlCON sql12 = new sqlCON();
DataTable dt = new DataTable();
sql12.sqlDataAdapterFillDatatable(sql.ToString(), ref dt);
nGItemsMappings = (from DataRow dr in dt.Rows
select new NGItemsMapping()
{
Department = dr["modelcode"].ToString(),
NGCode_Process = dr["processcode"].ToString(),
NGCodeName_Process = dr["processname"].ToString(),
NGCode_SFT = dr["itemcode"].ToString(),
NGCodeName_SFT = dr["itemname"].ToString(),
Note = (dr["note"].ToString().Split(';').Count() == 2) ? int.Parse(dr["note"].ToString().Split(';')[1].Substring(6)) : int.Parse(dr["note"].ToString().Substring(6))
}).ToList();
return(nGItemsMappings);
}
private void HRManagement_Load(object sender, EventArgs e)
{
sqlCON connect = new sqlCON();
connect.sqlDatatablePermision("Manpower", btn_Manpower);
connect.sqlDatatablePermision("SeasonalEmp", btn_SeasonalEmp);
}
public List <SettingManufacture> LoadingSettingManufactureFilter(string ProductNo)
{
List <SettingManufacture> settingManuf = new List <SettingManufacture>();
try
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(" select productName, productNo,PlanQuantity, WorkerTarget from t_settingManufacture ");
stringBuilder.Append(" where productName like '%" + ProductNo + "%'");
sqlCON sqlCON = new sqlCON();
DataTable dt = new DataTable();
sqlCON.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt);
settingManuf = (from DataRow dr in dt.Rows
select new SettingManufacture()
{
ProductName = (dr["ProductName"] != null) ? dr["ProductName"].ToString().Trim() : "",
ProductNo = (dr["productNo"] != null) ? dr["productNo"].ToString().Trim() : "",
PlanQty = (dr["PlanQuantity"].ToString() != null) ? int.Parse(dr["PlanQuantity"].ToString().Trim()) : 0,
Workertarget = (dr["WorkerTarget"].ToString() != null) ? int.Parse(dr["WorkerTarget"].ToString().Trim()) : 0
}).ToList();
}
catch (Exception)
{
return(null);
}
return(settingManuf);
}
public bool InsertToMQC_Realtime(string lot, string line, string item, string data, string Remark, int judge)
{
try
{
string datetimeserno = DateTime.Now.ToString("yyyyMMdd_HHmmss");
string serno = lot + "-" + datetimeserno;
string site = "B01";
string factory = "TECHLINK";
string process = "MQC";
string status = "";
string date_ = DateTime.Now.ToString("yyyy-MM-dd");
string time_ = DateTime.Now.ToString("HH:mm:ss");
string sqlQuerry = "";
string model = GetModelFromLot(lot);
sqlQuerry += "insert into m_ERPMQC_REALTIME (serno, lot, model, site, factory, line, process,item,inspectdate,inspecttime, data, judge,status,remark ) values( '";
sqlQuerry += serno + "', '" + lot + "', '" + model + "', '" + site + "', '" + factory + "', '" + line +
"', '" + process + "', '" + item + "', '" + date_ + "', '" + time_ + "', '" + data + "', '" + judge.ToString() + "', '" + status + "', '" + Remark + "' )";
sqlCON sqlCON = new sqlCON();
return(sqlCON.sqlExecuteNonQuery(sqlQuerry, false));
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "InsertToMQC_Realtime(string lot, string line, string item, string data, string Remark, int judge)", ex.Message);
return(false);
}
}
private void ConnectData_Load(object sender, EventArgs e)
{
sqlCON connect = new sqlCON();
string sql = "select distinct model from m_pqmdata order by model";
connect.getComboBoxData(sql, ref cmb_modelcode);
}
public bool IsExtinstDataReset(string line, DateTime dateTime)
{
try
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(" select ISNULL(COUNT(data),'0') from m_ERPMQC_REALTIME where 1=1 and judge = '1' ");
stringBuilder.Append(" and line = '" + line + "' ");
stringBuilder.Append(" and cast(inspectdate as datetime) + CAST (inspecttime as datetime) > '" + dateTime.ToString("yyyyMMdd hh:mm:ss") + "' ");
sqlCON sqlCON = new sqlCON();
var temp = sqlCON.sqlExecuteScalarString(stringBuilder.ToString());
try
{
int count = int.Parse(temp.Trim());
if (count > 0)
{
return(true);
}
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, " convert to int", ex.Message);
return(false);
}
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, " IsExtinstDataReset(string line, DateTime dateTime)", ex.Message);
return(false);
}
return(false);
}
private void cmb_modelcode_SelectedIndexChanged(object sender, EventArgs e)
{
sqlCON connect = new sqlCON();
string sql = "select distinct process from m_pqmdata where model = '" + cmb_modelcode.Text + "' order by process";
connect.getComboBoxData(sql, ref cmb_processcode);
}
public double QuantityCanRun(string lot)
{
double ReadyQty = 0;
try
{
if (lot.Length == 26)
{
sqlERPCON data = new sqlERPCON();
string lottam = lot;
double StockERP = double.Parse(data.sqlExecuteScalarString("select isnull(sum(TA011+TA012),'0') from SFCTA where ( TA001+ '-'+RTRIM(TA002)+';'+ TA003 +';'+TA004 +';'+TA006 ) = '" + lot + "' "));
var PlanERP = double.Parse(data.sqlExecuteScalarString("select (isnull (TA010,'0')) from SFCTA where ( TA001+ '-'+RTRIM(TA002)+';'+ TA003 +';'+TA004 +';'+TA006 ) = '" + lot + "' "));
sqlCON sqlCON = new sqlCON();
double StockRealtime = double.Parse(sqlCON.sqlExecuteScalarString("select isnull(sum(cast( isnull(data,'0') as int)),0) from m_ERPMQC_REALTIME where lot = '" + lot + "' and remark != 'RW'"));
var MAXSYSTEM = StockERP >= StockRealtime ? StockERP : StockRealtime;
ReadyQty = (PlanERP - MAXSYSTEM);
}
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "QuantityCanRun(string lot)", ex.Message);
}
return(ReadyQty);
}
public void searchdata(ref DataGridView dgv, bool load)
{
if (load == true)
{
dgv.DataSource = null;
}
dt = new DataTable();
StringBuilder sql = new StringBuilder();
sql.Append("select * from m_ipPLC where 1=1 ");
if (cmb_process.Text != "")
{
sql.Append("and process ='" + cmb_process.Text + "'");
}
if (cmb_ip.Text != "")
{
sql.Append("and IPPLC ='" + cmb_ip.Text + "'");
}
sql.Append("order by IPPLC");
sqlCON tf = new sqlCON();
tf.sqlDataAdapterFillDatatable(sql.ToString(), ref dt);
dgv.DataSource = dt;
dgv.Columns[0].Visible = false;
dgv.AutoGenerateColumns = true;
dgv.DefaultCellStyle.Font = new Font("Verdana", 8, FontStyle.Regular);
dgv.ColumnHeadersDefaultCellStyle.Font = new Font("Verdana", 10, FontStyle.Bold);
if (dgv_ip.RowCount == 0)
{
btn_edit.Enabled = false; btn_delete.Enabled = false;
}
}
public List <string> GetListStringHeaderReworkTop25()
{
List <string> headerRW25 = new List <string>();
try
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(@" select top(16) sum(cast(data as int)) as Tong, item, itemname from m_ERPMQC_REALTIME
inner join m_process on processcode = REPLACE(item,'RW','NG')
where remark ='RW'
group by item,itemname
order by Tong DESC ");
DataTable dt = new DataTable();
sqlCON sqlCON = new sqlCON();
sqlCON.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
headerRW25.Add(dt.Rows[i]["itemname"].ToString());
}
}
catch (Exception ex)
{
Logfile.Output(StatusLog.Error, "List<string> GetListStringHeaderReworkTop25()", ex.Message);
}
return(headerRW25);
}
public static List <QRImportClass> SelectQRCode(string QR_CODE)
{
List <QRImportClass> _listReturn = new List <QRImportClass>();
try
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("select * from t_QRImport where IDQRCODE = '");
stringBuilder.Append(QR_CODE.Trim() + "'");
sqlCON sqlTLVN2 = new sqlCON();
DataTable dataTable = new DataTable();
sqlTLVN2.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dataTable);
_listReturn = (from DataRow dr in dataTable.Rows
select new QRImportClass()
{
ID = (dr["Id"] != null) ? dr["Id"].ToString().Trim() : "",
QRCODE = (dr["IDQRCODE"] != null) ? dr["IDQRCODE"].ToString().Trim() : "",
STATUS = (dr["Status"].ToString() != null) ? dr["Status"].ToString().Trim() : "",
DATE = (dr["Update_Date"].ToString() != null) ?dr["Update_Date"].ToString().Trim() : ""
}).ToList();
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "InsertQRcode", ex.Message);
}
return(_listReturn);
}
public List <ScheduleReportItems> GetScheduleReportCommon(string ReportName)
{
List <ScheduleReportItems> list = new List <ScheduleReportItems>();
DataTable dt = new DataTable();
StringBuilder sql = new StringBuilder();
sql.Append("select reportname, reporttype, Minutes,hours, day, date, month,isBodyHTML,subject, attach, comments from t_report_schedule where 1=1 and reportname = '" + ReportName + "' ");
sqlCON tf = new sqlCON();
tf.sqlDataAdapterFillDatatable(sql.ToString(), ref dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
ScheduleReportItems item = new ScheduleReportItems();
item.ReportName = dt.Rows[i]["reportname"].ToString();
item.ReportType = dt.Rows[i]["reporttype"].ToString();
item.Minutes = dt.Rows[i]["Minutes"].ToString();
item.Hours = dt.Rows[i]["hours"].ToString();
item.Day = dt.Rows[i]["day"].ToString();
item.Date = dt.Rows[i]["date"].ToString();
item.Month = dt.Rows[i]["month"].ToString();
item.IsBodyHTML = bool.Parse(dt.Rows[i]["isBodyHTML"].ToString());
item.Subject = dt.Rows[i]["subject"].ToString();
item.AttachedFolder = dt.Rows[i]["attach"].ToString();
item.Contents = dt.Rows[i]["comments"].ToString();
list.Add(item);
}
dt = null;
return(list);
}
