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;
}
