private void BtnClassRole_Click(object sender, EventArgs e)
{
List <CMNDICT> dictList = new List <CMNDICT>();
if (clbClass.SelectedItems.Count == 0)
{
MsgBoxEx.Info("Please select at least one item.");
return;
}
foreach (WmClassificationItemEntity item in clbClass.CheckedItems)
{
CMNDICT model = new CMNDICT();
model.DICTID = "3000";
model.CODE = item.ID.ToString();
model.NAME = item.NAME.ToString();
dictList.Add(model);
}
IsysService service = sysService.GetService();
service.AddDict(dictList);
MsgBoxEx.Info("Save success, please refresh the data.");
}
private void cbxDisk_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbxDisk.SelectedIndex != -1)
{
chartDisk.Series[0].Points.Clear();
chartDisk.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Pie;
chartDisk.Series[0].Points.AddXY("Free Space(GB)", diskList[cbxDisk.SelectedIndex].FreeSpace);
chartDisk.Series[0].Points.AddXY("Used Space(GB)", diskList[cbxDisk.SelectedIndex].UsedSpace);
chartDisk.Series[0].IsValueShownAsLabel = true;
//alter
var diskAlter = DataCache.CmnDict.Where(s => s.DICTID == "3022" && cbxDisk.Text.Contains(s.REMARK.ToUpper())).Select(s => s.VALUE).FirstOrDefault();
if (!string.IsNullOrEmpty(diskAlter))
{
var percent = Convert.ToInt32(diskList[cbxDisk.SelectedIndex].FreeSpace * 100 / diskList[cbxDisk.SelectedIndex].TotalSize);
if (percent < int.Parse(diskAlter))
{
MsgBoxEx.Warn("Disk remaining space is less than alert value, please clean up");
}
}
}
}
private void btnDbImp_Click(object sender, EventArgs e)
{
if (MsgBoxEx.ConfirmYesNo("Are you sure to import the file") == DialogResult.No)
{
return;
}
if (string.IsNullOrEmpty(cbxFiles.Text))
{
MsgBoxEx.Info("Please select a file to import.");
return;
}
ShowLoading(ToopEnum.loading);
IwrService service = wrService.GetService();
var rs = service.ImpOrExpDatabase("1", cbxFiles.Text) >= 0;
if (rs)
{
cbxFiles.Items.AddRange(service.GetDBFilesList().ToArray());
}
CloseLoading();
}
bool arule_OptRule(string type, string[] data)
{
IsysService service = sysService.GetService();
var rs = string.Empty;
switch (type)
{
case "ADD":
data[0] = Guid.NewGuid().ToString();
rs = service.AddRule(data[0], data[1], data[2], data[3], data[4].ToLower() == "all" ? "*" : data[4]);
break;
case "EDIT":
rs = service.EditRule(data[0], data[1], data[2], data[3], data[4].ToLower() == "all" ? "*" : data[4]);
break;
case "DEL":
rs = service.DelRule(data[0]);
break;
default:
break;
}
if (rs == "-1")
{
MsgBoxEx.Info("Name already exist");
return(false);
}
frm_config_Load(null, null);
return(true);
}
private void btnOK_Click(object sender, EventArgs e)
{
if (txtRecipeId.Text.Trim().Length < 1)
{
txtRecipeId.Focus();
MsgBoxEx.Info("Please input recipe id");
return;
}
IwrService service = wrService.GetService();
var res = 0;
var type = rbRepice.Checked ? "0" : rbLayer.Checked ? "1" : rbDevice.Checked ? "2" : "0";
if (IsAdd)
{
res = service.AddYield(txtRecipeId.Text, type, nudLotYield.Value, nudWaferYield.Value, nudAYield.Value, nudBYield.Value, nudCYield.Value, nudDYield.Value, nudEYield.Value, txtImg.Text);
}
else
{
res = service.EditYield(txtRecipeId.Text, type, nudLotYield.Value, nudWaferYield.Value, nudAYield.Value, nudBYield.Value, nudCYield.Value, nudDYield.Value, nudEYield.Value, txtImg.Text);
}
if (res == -2)
{
MsgBoxEx.Info("The recipe id already exists");
return;
}
DialogResult = DialogResult.OK;
}
/// <summary>
/// 表空间扩容
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnTableSpaceAdd_Click(object sender, EventArgs e)
{
if (MsgBoxEx.ConfirmYesNo("Are you sure to add the tablespace") == DialogResult.No)
{
return;
}
ShowLoading(ToopEnum.loading);
try
{
IwrService service = wrService.GetService();
var rs = service.AddTableSpace("");
if (rs)
{
MsgBoxEx.Info("Please restart the program.");
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
CloseLoading();
}
}
private void btnQuery_Click(object sender, EventArgs e)
{
double tdays = (dateTo.Value - dtDate.Value).TotalDays;
if (tdays < 0)
{
dtDate.Focus();
MsgBoxEx.Info("From date selection error.");
return;
}
IwrService service = wrService.GetService();
var lst = service.GetWaferResultHis(dtDate.Value.ToString("yyyyMMdd000000"), dateTo.Value.ToString("yyyyMMdd235959"), GetLot());
if (DataCache.UserInfo.FilterData)
{
var newWaferList = ((from w in lst
group w by new { w.DEVICE, w.LAYER, w.LOT, w.SUBSTRATE_ID } into l
select new { DEVICE = l.Key.DEVICE, LAYER = l.Key.LAYER, LOT = l.Key.LOT, SUBSTRATE_ID = l.Key.SUBSTRATE_ID, CREATEDDATE = l.Max(s => s.CREATEDDATE) }))
.ToList();
lst = (from w in lst
join n in newWaferList
on new { w.DEVICE, w.LAYER, w.LOT, w.SUBSTRATE_ID, w.CREATEDDATE } equals new { n.DEVICE, n.LAYER, n.LOT, n.SUBSTRATE_ID, n.CREATEDDATE }
select w).ToList();
}
grdData.AutoGenerateColumns = false;
grdData.DataSource = lst;
}
private void btnOK_Click(object sender, EventArgs e)
{
if (txtName.Text.Trim().Length < 1)
{
txtName.Focus();
MsgBoxEx.Info("Please input name");
return;
}
IsysService service = sysService.GetService();
string res = "";
if (IsAdd)
{
res = service.AddRole(txtCode.Text, txtName.Text.Trim(), txtRemark.Text.Trim(), DataCache.UserInfo.ID);
}
else
{
res = service.UpdateRole(txtCode.Text, txtName.Text.Trim(), txtRemark.Text.Trim(), DataCache.UserInfo.ID);
}
if (res != "1")
{
MsgBoxEx.Info(res);
return;
}
DialogResult = DialogResult.OK;
}
private void btnSystem_Click(object sender, EventArgs e)
{
IsysService service = sysService.GetService();
var list = service.GetCmn("3022");
if (list.Count > 0)
{
foreach (var l in list)
{
switch (l.CODE)
{
case "0":
l.VALUE = nudDisk.Value.ToString();
break;
default:
break;
}
}
}
service.UpdateDict(list);
MsgBoxEx.Info("Save success, please refresh the data.");
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (MsgBoxEx.ConfirmYesNo("Are you sure to delete the data") == DialogResult.No)
{
return;
}
DataOperation(2);
}
private void lblConnction_Click(object sender, EventArgs e)
{
frm_connsetting frm = new frm_connsetting();
if (frm.ShowDialog() == DialogResult.OK)
{
MsgBoxEx.Info("Saved successfully, Please run the program again.");
Application.Exit();
}
}
private void btnRecovery_Click(object sender, EventArgs e)
{
if (MsgBoxEx.ConfirmYesNo("Are you sure to recovery the data") == DialogResult.No)
{
return;
}
DataOperation(1);
DataCache.RefreshCache();
}
private void btnOk_Click(object sender, EventArgs e)
{
if (txtOldPwd.Text.Trim().Length < 1)
{
txtOldPwd.Focus();
MsgBoxEx.Info("Please input old password");
return;
}
if (txtNewPwd.Text.Trim().Length < 1)
{
txtNewPwd.Focus();
MsgBoxEx.Info("Please input new password");
return;
}
if (txtConPwd.Text.Trim().Length < 1)
{
txtConPwd.Focus();
MsgBoxEx.Info("Please input confirm password");
return;
}
if (txtNewPwd.Text.Trim() != txtConPwd.Text.Trim())
{
txtNewPwd.Focus();
MsgBoxEx.Info("New password and confirm password is not the same");
return;
}
IsysService service = sysService.GetService();
string res = service.UpdatePwd(DataCache.UserInfo.ID, txtOldPwd.Text.Trim(), txtNewPwd.Text.Trim(), DataCache.UserInfo.ID);
if (res == "1")
{
MsgBoxEx.Info("Your password has been changed successfully,Please log in again.");
//btnClose_Click(null, null);
if (frmMain != null)
{
frmMain.ReLogin();
}
}
else if (res == "-1")
{
MsgBoxEx.Error("Your old password input errors");
}
else
{
MsgBoxEx.Error("Your password modification failed");
}
}
private void frm_main_Load(object sender, EventArgs e)
{
timer1.Enabled = true;
cbxLang.SelectedIndex = 0;
label4.Text = string.Format("{0:yyyy/MM/dd HH:mm:ss}", DateTime.Now);
pnlLeft.Enabled = false;
pnlLeft.Width = 1;
lblArrow.Image = global::WR.Client.UI.Properties.Resources.pright;
ShowForm("");
System.Threading.Tasks.Task.Factory.StartNew(() =>
{
while (true)
{
try
{
System.Threading.Thread.Sleep(60000); //20s
IsysService service = sysService.GetService();
var deviceArray = service.GetHeartBeatInterval().Select(s => s.REMARK).ToArray();
if (deviceArray.Length > 0)
{
var msg = string.Format("The {0} has stopped uploading, please check its status.", string.Join(",", deviceArray));
if (this.InvokeRequired)
{
this.BeginInvoke(new Action(() =>
{
MsgBoxEx.Warn(msg);
}));
}
else
{
MsgBoxEx.Warn(msg);
}
return;
}
}
catch (Exception ex)
{
}
}
});
}
private void picClose_Click(object sender, EventArgs e)
{
if (MsgBoxEx.ConfirmYesNo("Are you sure to exit?") == DialogResult.No)
{
return;
}
if (frm.GetType().Name == "frm_preview")
{
var frmP = frm as frm_preview;
frm.Close();
}
this.Close();
}
private void btnDbExp_Click(object sender, EventArgs e)
{
if (MsgBoxEx.ConfirmYesNo("Are you sure to back up the database") == DialogResult.No)
{
return;
}
ShowLoading(ToopEnum.loading);
IwrService service = wrService.GetService();
service.ImpOrExpDatabase("0");
CloseLoading();
//timer1.Enabled = true;
}
/// <summary>
/// 保存自定义缺陷
/// </summary>
/// <returns></returns>
private bool SaveHotKey()
{
grdClass.EndEdit();
List <WmClassificationItemEntity> items = grdClass.DataSource as List <WmClassificationItemEntity>;
if (items == null || items.Count < 1)
{
return(false);
}
StringBuilder sbt = new StringBuilder();
foreach (var item in items)
{
if (!string.IsNullOrEmpty(item.InspectionType))
{
if (items.Any(p => p.ID != item.ID && p.HOTKEY == item.HOTKEY && !string.IsNullOrEmpty(item.HOTKEY)))
{
MsgBoxEx.Info(string.Format("Acc Keys[{0}] already repeated!", DataCache.CmnDict.FirstOrDefault(p => p.DICTID == "2010" && p.CODE == item.HOTKEY).NAME));
return(false);
}
sbt.AppendFormat(";{0}|{1}|{2}", item.ID, item.HOTKEY, item.COLOR);
}
}
if (sbt.Length < 1)
{
return(true);
}
IwrService service = wrService.GetService();
int res = service.UpdateClassificationItemUser(sbt.ToString(), "");
if (res == 1)
{
items.ForEach((p) => { p.InspectionType = ""; });
}
return(true);
}
private void btnOK_Click(object sender, EventArgs e)
{
if (txtName.Text.Trim().Length < 1)
{
txtName.Focus();
MsgBoxEx.Info("Please input name");
return;
}
if (IsAdd && lbResult.Items.Count == 0)
{
MsgBoxEx.Info("Please select wafer result");
return;
}
IwrService service = wrService.GetService();
var res = 0;
var resultId = string.Join(",", ResultList.Select(s => s.ID).ToArray());
if (IsAdd)
{
res = service.AddLibray(resultId, txtName.Text.Trim(), txtRemark.Text, DataCache.UserInfo.ID, (ckStatus.Checked ? "1" : "0"));
}
else
{
res = service.UpdateLibray(Entity.LID, txtName.Text.Trim(), txtRemark.Text, (ckStatus.Checked ? "1" : "0"), DataCache.UserInfo.ID);
}
if (res == -1)
{
MsgBoxEx.Info("Name already exist");
return;
}
else if (res != 1)
{
MsgBoxEx.Info("Save failed");
return;
}
DialogResult = DialogResult.OK;
}
private void tlPlanEdit_Click(object sender, EventArgs e)
{
if (grdPlan.SelectedRows == null || grdPlan.SelectedRows.Count < 1)
{
MsgBoxEx.Info("Please select the updated data");
return;
}
string id = grdPlan.SelectedRows[0].Cells["pid"].Value.ToString();
var data = grdPlan.DataSource as List <EMPLAN>;
frm_planedit frm = new frm_planedit();
frm.emPlan = data.FirstOrDefault(p => p.PID == id);
if (frm.ShowDialog() == DialogResult.OK)
{
tlPlanRefresh.PerformClick();
}
}
private void btnArchive_Click(object sender, EventArgs e)
{
if (MsgBoxEx.ConfirmYesNo("Are you sure to archive the data") == DialogResult.No)
{
return;
}
DataOperation(0);
DataCache.RefreshCache();
IsysService service = sysService.GetService();
var entity = service.GetCmn("3021").FirstOrDefault(s => s.CODE == "0");
if (entity != null)
{
txtArchiveDate.Text = entity.VALUE;
}
}
private void ArchiveDate()
{
var lastDate = DataCache.CmnDict.Where(s => s.DICTID == "3021" && s.CODE == "0").Select(s => s.VALUE).FirstOrDefault();
if (string.IsNullOrEmpty(lastDate))
{
MsgBoxEx.Info("Data not yet archived, please archive now.");
}
else
{
var intervalDay = (DateTime.Now - DateTime.ParseExact(lastDate,
"yyyyMMdd",
System.Globalization.CultureInfo.InvariantCulture)).Days;
if (intervalDay > 7)
{
MsgBoxEx.Info("It's been over seven days since the last archive, please archive now.");
}
}
}
private void tlPlanAdd_Click(object sender, EventArgs e)
{
if (grdLibrary.SelectedRows == null || grdLibrary.SelectedRows.Count < 1)
{
MsgBoxEx.Info("Please add a new library");
return;
}
string lid = grdLibrary.SelectedRows[0].Cells["LID"].Value.ToString();
frm_planedit frm = new frm_planedit();
frm.LID = lid;
frm.IsAdd = true;
if (frm.ShowDialog() == DialogResult.OK)
{
LoadPlanData(lid);
}
}
private void tlDel_Click(object sender, EventArgs e)
{
if (grdLibrary.SelectedRows == null || grdLibrary.SelectedRows.Count < 1)
{
return;
}
if (MsgBoxEx.ConfirmYesNo("Are you sure to delete the record?") == DialogResult.No)
{
return;
}
string id = grdLibrary.SelectedRows[0].Cells["lid"].Value.ToString();
IwrService service = wrService.GetService();
service.DeleteLibray(id, DataCache.UserInfo.ID);
tlSearch.PerformClick();
}
private void tlDel_Click(object sender, EventArgs e)
{
if (grdData.SelectedRows == null || grdData.SelectedRows.Count < 1)
{
return;
}
if (MsgBoxEx.ConfirmYesNo("Are you sure to delete the record?") == DialogResult.No)
{
return;
}
string id = grdData.SelectedRows[0].Cells["ColCode"].Value.ToString();
IsysService service = sysService.GetService();
service.DelRole(id);
tlSearch.PerformClick();
}
private void tlPlanDelete_Click(object sender, EventArgs e)
{
if (grdPlan.SelectedRows == null || grdPlan.SelectedRows.Count < 1)
{
MsgBoxEx.Info("Please select Delete data");
return;
}
if (MsgBoxEx.ConfirmYesNo("Are you sure to delete the record?") == DialogResult.No)
{
return;
}
string id = grdPlan.SelectedRows[0].Cells["pid"].Value.ToString();
IwrService service = wrService.GetService();
service.DeletePlan(id, DataCache.UserInfo.ID);
tlPlanRefresh.PerformClick();
}
private void btnOK_Click(object sender, EventArgs e)
{
string userid = txtUser.Text.Trim();
if (string.IsNullOrEmpty(userid))
{
MsgBoxEx.Info(MessageConst.frm_login_msg001);
return;
}
string pwd = txtPwd.Text.Trim();
if (string.IsNullOrEmpty(pwd))
{
MsgBoxEx.Info(MessageConst.frm_login_msg002);
return;
}
btnOK.Enabled = false;
btnReset.Enabled = false;
txtUser.Enabled = false;
txtPwd.Enabled = false;
lblMsg.Visible = true;
var thr = new Thread(() =>
{
try
{
Login(userid, pwd);
}
catch (Exception ex)
{
log.Error(ex);
//MsgBoxEx.Error(ex.Message);
}
});
thr.Start();
}
private void btnOK_Click(object sender, EventArgs e)
{
if (txtID.Text.Trim().Length < 1)
{
txtID.Focus();
MsgBoxEx.Info("Please input ID");
return;
}
if (txtName.Text.Trim().Length < 1)
{
txtName.Focus();
MsgBoxEx.Info("Please input name");
return;
}
IsysService service = sysService.GetService();
string res = "";
if (IsAdd)
{
res = service.AddUser(Guid.NewGuid().ToString("N").ToUpper(), txtID.Text.Trim(), txtPwd.Text.Trim(),
txtName.Text.Trim(), txtPhone.Text.Trim(), txtEmail.Text.Trim(), txtRemark.Text.Trim(), (cbxRereview.Checked ? "1" : "0"), DataCache.UserInfo.ID);
}
else
{
res = service.UpdateUser(tbUser.ID, txtID.Text.Trim(), txtPwd.Text.Trim(),
txtName.Text.Trim(), txtPhone.Text.Trim(), txtEmail.Text.Trim(), txtRemark.Text.Trim(), (cbxRereview.Checked ? "1" : "0"), DataCache.UserInfo.ID);
}
if (res != "1")
{
MsgBoxEx.Info(res);
return;
}
DialogResult = DialogResult.OK;
}
private void btnWaferYield_Click(object sender, EventArgs e)
{
IsysService service = sysService.GetService();
//yield
var list = service.GetCmn("3010");
if (list.Count > 0)
{
foreach (var l in list)
{
switch (l.CODE)
{
case "0":
l.VALUE = nudLotYield.Value.ToString();
break;
case "1":
l.VALUE = nudWaferYield.Value.ToString();
break;
default:
break;
}
}
}
var rs = service.UpdateDict(list);
if (rs == "0")
{
DataCache.CmnDict = service.GetCmn("");
}
MsgBoxEx.Info("Save success, please refresh the data.");
}
private void Login(string userid, string pwd)
{
IsysService service = sysService.GetService();
UserInfoEntity ent = service.Login(userid, pwd);
if (ent.IsOK == 0)
{
DataCache.UserInfo = ent;
LoadLocalSettings(DataCache.UserInfo);
DataCache.CmnDict = service.GetCmn("");
DataCache.Tbmenus = service.GetMenuByUserId(userid);
var msg = GetExamInfo();
if (!string.IsNullOrEmpty(msg))
{
MsgBoxEx.Info(msg);
return;
}
//加载数据
DataCache.RefreshCache();
if (this.InvokeRequired)
{
this.Invoke(new Action(() =>
{
System.Configuration.Configuration config = WR.Utils.Config.GetConfig();
config.AppSettings.Settings.Remove("userid");
config.AppSettings.Settings.Add("userid", userid);
config.Save();
WR.Utils.Config.Refresh();
frmMain.SetForm();
}));
}
else
{
System.Configuration.Configuration config = WR.Utils.Config.GetConfig();
config.AppSettings.Settings.Remove("userid");
config.AppSettings.Settings.Add("userid", userid);
config.Save();
WR.Utils.Config.Refresh();
frmMain.SetForm();
}
}
else
{
string msg = MessageConst.frm_login_msg003;
switch (ent.IsOK)
{
case -99:
msg = MessageConst.frm_login_msg003;
break;
case -1:
msg = MessageConst.const_msg001;
break;
case -2:
msg = MessageConst.const_msg002;
break;
case -3:
msg = MessageConst.const_msg003;
break;
case -4:
msg = MessageConst.const_msg001;
break;
default:
msg = MessageConst.const_msg001;
break;
}
if (this.InvokeRequired)
{
this.Invoke(new Action(() =>
{
MsgBoxEx.Info(msg);
btnOK.Enabled = true;
btnReset.Enabled = true;
lblMsg.Visible = false;
txtUser.Enabled = true;
txtPwd.Enabled = true;
txtPwd.Focus();
}));
}
else
{
MsgBoxEx.Info(msg);
btnOK.Enabled = true;
btnReset.Enabled = true;
lblMsg.Visible = false;
txtUser.Enabled = true;
txtPwd.Enabled = true;
txtPwd.Focus();
}
}
}
private void btnOK_Click(object sender, EventArgs e)
{
if (txtName.Text.Trim().Length < 1)
{
txtName.Focus();
MsgBoxEx.Info("Please input name");
return;
}
int tdays = (int)(dtDate.Value - DateTime.Now.Date).TotalDays;
if (tdays < 0)
{
dtDate.Focus();
MsgBoxEx.Info("From date selection error.");
return;
}
tdays = (int)(dtEndTime.Value - dtStartTime.Value).TotalMinutes;
if (tdays <= 0)
{
dtEndTime.Focus();
MsgBoxEx.Info("From date selection error.");
return;
}
if (nudUser.Value <= 0)
{
nudUser.Focus();
MsgBoxEx.Info("Number selection error.");
return;
}
if (nudDefect.Value <= 0)
{
nudDefect.Focus();
MsgBoxEx.Info("Defect Number selection error.");
return;
}
IwrService service = wrService.GetService();
var res = 0;
var startTime = string.Format("{0} {1}:00", dtDate.Value.ToString("yyyy-MM-dd"), dtStartTime.Value.ToString("HH:mm"));
var endTime = string.Format("{0} {1}:00", dtDate.Value.ToString("yyyy-MM-dd"), dtEndTime.Value.ToString("HH:mm"));
if (IsAdd)
{
res = service.AddPlan(LID, txtName.Text.Trim(), startTime, endTime, (int)nudUser.Value, (int)nudDefect.Value, txtRemark.Text, DataCache.UserInfo.ID);
}
else
{
res = service.UpdatePlan(emPlan.PID, txtName.Text.Trim(), startTime, endTime, (int)nudUser.Value, (int)nudDefect.Value, txtRemark.Text, DataCache.UserInfo.ID);
}
//if (res != 1)
//{
// MsgBoxEx.Info(res.ToString());
// return;
//}
if (res == -1)
{
MsgBoxEx.Info("Name already exist");
return;
}
else if (res != 1)
{
MsgBoxEx.Info("Save failed");
return;
}
DialogResult = DialogResult.OK;
}
