private void btnSave_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(this.txtBoxAddress.Text) || string.IsNullOrEmpty(this.txtBoxName.Text) || string.IsNullOrEmpty(this.txtBoxEmail.Text) || string.IsNullOrEmpty(this.txtBoxLastName.Text) || string.IsNullOrEmpty(this.txtBoxPhone.Text)) { this.lblResponse.Text = "Error, please type mandatory information...!"; } else { this.lblResponse.Text = string.Empty; ProcessDao Process = new ProcessDao(); var resp = Process.SavePersonalData(this.txtBoxName.Text, this.txtBoxLastName.Text, this.txtBoxAddress.Text, this.txtBoxPhone.Text, this.txtBoxEmail.Text); if (resp > 0) { this.lblResponse.Text = "Personal data saved successfully...!"; ClearInformation(); } } } catch (SqlException) { this.lblResponse.Text = "Error, Please check your connection to the database...!"; } catch (Exception) { throw; } }
// GET: Process public ActionResult Index(long id) { //Kiểm tra quyền truy cập của user UserLogin us = (UserLogin)Session[CommonConstant.USER_SESSION]; ProjectUserDao puDao = new ProjectUserDao(); //Kiểm tra quyền truy cập của lạnh đạo bool inGroup = false; GroupUserDao gru = new GroupUserDao(); //Kiểm tra theo user có thuộc nhóm lãnh đạo kho Guid grid = new Guid("964D283D-BEA0-4D85-B7C0-355487A5DF0C"); if (gru.FiindByID(grid, us.UserID) != null) { inGroup = true; } //Kiểm tra theo user có thuộc nhóm trong dự án ko ProjectUser objPU = puDao.FindByID(us.UserID, id); if (objPU != null) { inGroup = true; } if (inGroup == false) { SetAlert("Bạn không có quyền cập nhật tiến độ dự án", Common.CommonConstant.ALERT_DANGER); return(RedirectToAction("Details", "Project", new { id = id })); } ProjectDao bdDao = new ProjectDao(); ViewBag.Project = bdDao.FindByID(id); if (ViewBag.Project.Status < 1) { SetAlert("Dự án chưa được duyệt!", Common.CommonConstant.ALERT_WARNING); return(RedirectToAction("Details", "Project", new { id = id })); } if (ViewBag.Project.Status > 2) { SetAlert("Dự án đã kết thúc!", Common.CommonConstant.ALERT_WARNING); return(RedirectToAction("Details", "Project", new { id = id })); } ProcessDao prcessDao = new ProcessDao(); ViewBag.lstprocess = prcessDao.ToListProcessUserByProjectID(id); ViewBag.lstProjectProcessMessege = prcessDao.GetListProjectProcessMessege(id).ToArray <ProjectMessage>(); ViewBag.Messege = prcessDao.CountProcessMessage(id).ToString(); FeedbackDao feedDao = new FeedbackDao(); ViewBag.Feedback = feedDao.ToListByProjectID(id).Count.ToString(); return(View()); }
public ActionResult Index(FormCollection data) { try { UserLogin us = (UserLogin)Session[CommonConstant.USER_SESSION]; var dao = new FeedbackDao(); long projectID = Convert.ToInt64(data["txtID"].ToString()); ProcessDao prcessDao = new ProcessDao(); ViewBag.lstprocess = prcessDao.ToListProcessUserByProjectID(projectID); ViewBag.lstProjectProcessMessege = prcessDao.GetListProjectProcessMessege(projectID).ToArray <ProjectMessage>(); ViewBag.Messege = prcessDao.CountProcessMessage(projectID).ToString(); Feedback objFeedback = new Feedback(); objFeedback.ProjectID = projectID; objFeedback.Description = data["txtDescription"].ToString(); objFeedback.CreateDate = Hepper.GetDateServer(); objFeedback.ModifiedDate = Hepper.GetDateServer(); objFeedback.CreateBy = us.UserName; objFeedback.ModifiedBy = us.UserName; if (dao.Insert(objFeedback) > 0) { SetAlert("Thêm thành công", "success"); ViewBag.Feedback = dao.ToListFeebBackUser(projectID).ToArray <FeedbackUser>(); List <FeedbackUser> fdnul = new List <FeedbackUser>(); foreach (FeedbackUser fb in ViewBag.Feedback) { if (fb.ChildID == null) { fdnul.Add(fb); } } ViewBag.FeedbackNull = fdnul.ToArray <FeedbackUser>(); return(RedirectToAction("Index")); } } catch { SetAlert("Không thêm được", "danger"); return(View()); } return(View()); }
private void LoadPersonalData() { ProcessDao Process = new ProcessDao(); try { var lstPersonalData = Process.GetPersonalData(); if (lstPersonalData.Tables.Count != 0) { //DataSet isn't empty this.dataGridViewPersonalData.AutoGenerateColumns = true; this.dataGridViewPersonalData.DataSource = lstPersonalData.Tables[0]; } } catch (Exception) { throw; } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnDelete_Click(object sender, EventArgs e) { int resp = 0; List <string> lstSelected = new List <string>(); try { foreach (DataGridViewRow row in dataGridViewPersonalData.Rows) { bool isSelected = Convert.ToBoolean(row.Cells["Delete"].Value); if (isSelected) { lstSelected.Add(row.Cells["Id"].Value.ToString()); } } if (lstSelected == null) { MessageBox.Show("Please select at least one record for delete...!"); } else { ProcessDao process = new ProcessDao(); resp = process.DeletePersonalData(lstSelected); } if (resp > 0) { LoadPersonalData(); MessageBox.Show("The database has been updated."); } } catch (Exception) { throw; } }
public ActionResult Index(FormCollection data) { long id = Convert.ToInt64(data["txtID"].ToString()); try { UserLogin us = (UserLogin)Session[CommonConstant.USER_SESSION]; var dao = new ProcessDao(); ViewBag.lstProjectProcessMessege = dao.GetListProjectProcessMessege(Convert.ToInt64(data["txtID"].ToString())); ViewBag.lstprocess = dao.ToListProcessUserByProjectID(Convert.ToInt64(data["txtID"].ToString())); Process objProcess = new Process(); string sName = "Giai đoạn " + (dao.ToListByProjectID(id).Count() + 1).ToString(); objProcess.ProjectID = id; // objProcess.Name = data["txtName"].ToString(); objProcess.Name = sName; objProcess.Description = data["txtDescription"].ToString(); objProcess.CreateDate = Hepper.GetDateServer(); objProcess.ModifiedDate = Hepper.GetDateServer(); objProcess.CreateBy = us.UserName; objProcess.ModifiedBy = us.UserName; if (dao.Insert(objProcess) > 0) { SetAlert("Cập nhật tiến độ thành công", Common.CommonConstant.ALERT_SUCCESS); ViewBag.lstprocess = dao.ToListProcessUserByProjectID(Convert.ToInt64(data["txtID"].ToString())); ViewBag.lstProjectProcessMessege = dao.GetListProjectProcessMessege(Convert.ToInt64(data["txtID"].ToString())); return(RedirectToAction("Index", "Process", new { id = id })); } } catch { SetAlert("Không cập nhật được tiến độ", "danger"); return(RedirectToAction("Index", "Process", new { id = id })); } return(View()); }
public ProcessSvc() { this.procDao = new ProcessDao(); this.procInstance = null; }
// GET: Feedback public ActionResult Index(long id) { ////Kiểm tra quyền truy cập của user //UserLogin us = (UserLogin)Session[CommonConstant.USER_SESSION]; //ProjectUserDao usDao = new ProjectUserDao(); //List<ProjectUser> lstUP = usDao.FindByProjectID(id); //bool inGroup = false; //foreach (var u in lstUP) //{ // if (u.LoginID == us.UserID) // { // inGroup = true; // break; // } //} ////Kiểm tra quyền truy cập của lạnh đạo //GroupUserDao gru = new GroupUserDao(); //Guid grid = new Guid("964D283D-BEA0-4D85-B7C0-355487A5DF0C"); //if (gru.FiindByID(grid, us.UserID) != null) //{ // inGroup = true; //} //if (!inGroup) //{ // RedirectToAction("NotiAuthorize", "Home"); //} ProjectDao bdDao = new ProjectDao(); ViewBag.Project = bdDao.FindByID(id); if (ViewBag.Project.Status < 1) { SetAlert("Dự án chưa được duyệt!", Common.CommonConstant.ALERT_WARNING); return(RedirectToAction("Details", "Project", new { id = id })); } if (ViewBag.Project.Status > 2) { SetAlert("Dự án đã kết thúc!", Common.CommonConstant.ALERT_WARNING); return(RedirectToAction("Details", "Project", new { id = id })); } ProcessDao prcessDao = new ProcessDao(); //ViewBag.lstprocess = prcessDao.ToListProcessUserByProjectID(id); //ViewBag.lstProjectProcessMessege = prcessDao.GetListProjectProcessMessege(id).ToArray<ProjectMessage>(); ViewBag.Messege = prcessDao.CountProcessMessage(id).ToString(); FeedbackDao feedDao = new FeedbackDao(); ViewBag.Feedback = feedDao.ToListFeebBackUser(id).ToArray <FeedbackUser>(); List <FeedbackUser> fdnul = new List <FeedbackUser>(); foreach (FeedbackUser fb in ViewBag.Feedback) { if (fb.ChildID == null) { fdnul.Add(fb); } } ViewBag.FeedbackNull = fdnul.ToArray <FeedbackUser>(); return(View()); }
public NaNaProcessWebSvc() { this.plmSvc = new NaNa.PLMIntegrationEFGP.PLMIntegrationEFGPService(); this.procDao = new ProcessDao(); }
/// <summary> /// 添加商品 /// </summary> private void AddGoods() { if (oddText.Text == "按F2选择加工单") { MessageBox.Show("扫码前,请选择一条加工单!"); numberTextBox.Text = ""; return; } if (string.IsNullOrEmpty(numberTextBox.Text)) { return; } //现在还是18位条码 if (numberTextBox.Text.Length != 18 || !numberTextBox.Text.StartsWith("28")) { MessageBox.Show("请检查条码是否正确!", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning); numberTextBox.Text = ""; return; } //以后的13位条码 //if (numberTextBox.Text.Length != 13 || !numberTextBox.Text.StartsWith("28")) //{ // MessageBox.Show("请检查条码是否正确!", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning); // numberTextBox.Text = ""; // return; //} ///以后的13位条码 //string serialNumber = numberTextBox.Text.Substring(2, 5); //string weightString = numberTextBox.Text.Substring(7, 5); //float weigth = float.Parse(weightString.Insert(2, ".")); ///现在的18位条码 string serialNumber = numberTextBox.Text.Substring(2, 5); string weightString = numberTextBox.Text.Substring(12, 5); float weigth = float.Parse(weightString.Insert(2, ".")); string processItemId = ""; if (this.itemDataGird.DataSource != null && this.itemDataGird.RowCount != 0) { for (int i = 0; i < itemDataGird.RowCount; i++) { if (itemDataGird[1, i].Value.ToString() == serialNumber) { processItemId = itemDataGird[0, i].Value.ToString(); break; } } } ProcessItem item = new ProcessItem(); ProcessItemDao dao = new ProcessItemDao(); if (string.IsNullOrEmpty(processItemId)) { if (CalculateFlag) { ///新增数据 OracleConnection conn = null; OracleCommand cmd = new OracleCommand(); string sql = "select id,GOODS_NAME,GOODS_SPECIFICATIONS,GOODS_UNIT from ZC_GOODS_MASTER where SERIALNUMBER = :serialNumber"; try { conn = OracleUtil.OpenConn(); cmd.Connection = conn; cmd.CommandText = sql; cmd.Parameters.Add(":serialNumber", serialNumber); OracleDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { item.GoodsFileId = reader.IsDBNull(0) ? string.Empty : reader.GetString(0); item.GoodsName = reader.IsDBNull(1) ? string.Empty : reader.GetString(1); item.Specifications = reader.IsDBNull(2) ? string.Empty : reader.GetString(2); item.Unit = reader.IsDBNull(3) ? string.Empty : reader.GetString(3); } } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { cmd.Dispose(); OracleUtil.CloseConn(conn); } item.Id = Guid.NewGuid().ToString(); item.CreateTime = DateTime.Now; item.UpdateTime = DateTime.Now; item.GoodsNum = "1"; item.ProcessGoodsId = processGoodsId; item.SerialNumber = serialNumber; item.TypeFlag = "2"; item.GoodsWeight = weigth.ToString(); dao.AddProcessItem(item); } else { MessageBox.Show("当前加工单不存在此商品,无法扫码减去!"); numberTextBox.Text = ""; return; } } else { ///更新数据 item = dao.FindById(processItemId); if (CalculateFlag) { item.GoodsNum = (float.Parse(item.GoodsNum) + 1).ToString(); item.GoodsWeight = (float.Parse(item.GoodsWeight) + weigth).ToString(); item.CreateTime = DateTime.Now; item.UpdateTime = DateTime.Now; dao.UpdateItem(item); } else { if (float.Parse(item.GoodsWeight) < weigth) { MessageBox.Show(item.GoodsName + "的重量小于需要减去的商品数量, 扫码失败!"); numberTextBox.Text = ""; return; } else if (float.Parse(item.GoodsWeight) == weigth) { dao.DeleteById(processItemId); } else { item.GoodsNum = (float.Parse(item.GoodsNum) - 1).ToString(); item.GoodsWeight = (float.Parse(item.GoodsWeight) - weigth).ToString(); item.CreateTime = DateTime.Now; item.UpdateTime = DateTime.Now; dao.UpdateItem(item); } } } /// 更新主表 ProcessDao mainDao = new ProcessDao(); string goodsNum = mainDao.FindGoodsNum(processGoodsId); if (CalculateFlag) { if (string.IsNullOrEmpty(goodsNum)) { goodsNum = "1"; } else { goodsNum = (float.Parse(goodsNum) + 1).ToString(); } } else { goodsNum = (float.Parse(goodsNum) - 1).ToString(); } mainDao.updateNum(processGoodsId, goodsNum); loadDataGridView(); ///清空条码 numberTextBox.Text = ""; ///每次扫码结束,默认是+ calculateButton.Text = "加(F1)"; CalculateFlag = true; }