public int UpdateManager(RLib.DB.DbConn dbconn, Model.Manager model) { StringBuilder sb = new StringBuilder(); sb.Append("UPDATE manager set "); sb.Append("name = @name,"); sb.Append("subName = @subname,"); sb.Append("loginName = @loginname,"); // sb.Append("loginPwd = @loginpwd,"); sb.Append("allowLogin = @allowlogin,"); sb.Append("state = @state,"); sb.Append("updateTime = getdate(),"); sb.Append("remark = @remark "); sb.Append(" WHERE managerId = @managerid;"); int rows = dbconn.ExecuteSql(sb.ToString(), new { managerid = model.ManagerId, name = model.Name, subname = model.SubName ?? "", loginname = model.LoginName ?? "", loginpwd = model.LoginPwd ?? "", allowlogin = model.AllowLogin, state = model.State, remark = model.Remark ?? "" }); return(rows); }
public BorrowResult(Model.Viewer _viewer, Model.Book _book, Model.Manager _manager) { InitializeComponent(); viewer = _viewer; book = _book; manager = _manager; RenderData(viewer, book, manager); }
public void Send(string managerLastName, SaleInfoRecord item) { lock (_lockObj) { using (_unitOfWork = new UnitOfWork()) { using (var transaction = _unitOfWork.BeginTransaction()) { try { DAL.Models.Manager newManager = new DAL.Models.Manager { LastName = managerLastName }; Model.Manager manager = _unitOfWork.ManagerRepository.FindBy(m => m.LastName == newManager.LastName); if (manager == null) { _unitOfWork.ManagerRepository.Create(newManager); _unitOfWork.Save(); manager = _unitOfWork.ManagerRepository.FindBy(m => m.LastName == newManager.LastName); } DAL.Models.Product newProduct = new DAL.Models.Product { Name = item.Product, Price = item.Price }; _unitOfWork.ProductRepository.Create(newProduct); DAL.Models.Client newClient = new DAL.Models.Client { Name = item.Client }; _unitOfWork.ClientRepository.Create(newClient); _unitOfWork.Save(); Model.Product product = _unitOfWork.ProductRepository.FindBy(p => p.Name == newProduct.Name); Model.Client client = _unitOfWork.ClientRepository.FindBy(c => c.Name == newClient.Name); DAL.Models.SaleInfo newSaleInfo = new DAL.Models.SaleInfo { ProductId = product.ProductId, ClientId = client.ClientId, ManagerId = manager.ManagerId, DateOfSale = item.DateOfSale }; _unitOfWork.SaleInfoRepository.Create(newSaleInfo); _unitOfWork.Save(); transaction.Commit(); } catch (Exception e) { transaction.Rollback(); throw new Exception(e.Source + " : Crash in sender from " + managerLastName); } } } } }
private void btSearchManager_Click(object sender, EventArgs e) { string information = ""; switch (combManager.Text.Trim()) { case "工号": information = "manID"; break; case "姓名": information = "manName"; break; case "性别": information = "manSex"; break; case "年龄": information = "manAge"; break; default: break; } Maticsoft.BLL.Manager man = new BLL.Manager(); string string1 = string.Format("{0} = '{1}'", information, tbManager.Text.Trim()); if (information == "manID") { Model.Manager manmodel = new Model.Manager(); manmodel = man.GetModel1(string1); if (manmodel.manID == "" || manmodel.manID == null) { MessageBox.Show("查无此人"); } else { SeekManager see = new Hotel.SeekManager(manmodel); see.ShowDialog(this); } } else { DataSet ds = new DataSet(); ds = man.GetList(string1); dgvManager.DataSource = ds.Tables[0]; ds.Tables[0].Columns["manID"].ColumnName = "前台工号"; ds.Tables[0].Columns["manName"].ColumnName = "姓名"; ds.Tables[0].Columns["manSex"].ColumnName = "性别"; ds.Tables[0].Columns["manAge"].ColumnName = "年龄"; ds.Tables[0].Columns["passwd"].ColumnName = "密码"; dgvManager.AllowUserToAddRows = false; dgvManager.SelectionMode = DataGridViewSelectionMode.FullRowSelect; } }
public string UpdateRate1(string code, string Id, string cn, string tw, string en, string th, string vn, string uName, string Rate) { if (Session[Util.ProjectConfig.ADMINUSER] == null) { return(""); } string json = ""; if (json != "stop") { Model.Rate rate = new Model.Rate(); rate.Name_cn = cn; rate.Name_tw = tw; rate.Name_en = en; rate.Name_th = th; rate.Name_vn = vn; rate.Code = code; rate.Id = Convert.ToInt32(Id); rate.Rate1 = Convert.ToDecimal(Rate); rate.Lasttime = DateTime.Now; Model.Manager m = Session[ProjectConfig.ADMINUSER] as Model.Manager; rate.Operator = m.ManagerId; string strHostName = Dns.GetHostName(); System.Net.IPAddress[] addressList = Dns.GetHostByName(Dns.GetHostName()).AddressList; rate.Ip = addressList[0].ToString(); bool reval = BLL.RateManager.UpdateRate(rate); if (reval) { bool ret = BLL.RatehistoryManager.AddRatehistory(rate); if (ret) { //Rates rates = new Rates(); Model.Rate rates = new Model.Rate(); rates.Name_cn = cn; rates.Name_tw = tw; rates.Name_en = en; rates.Name_th = th; rates.Name_vn = vn; rates.Rate1 = Convert.ToDecimal(Rate); rates.Lasttime = DateTime.Now; rates.Operator = m.ManagerId; rates.Ip = addressList[0].ToString(); json = DAL.ObjectToJson.ObjectsToJson <Model.Rate>(rates); } else { json = "none"; } } } return(json); }
public string AddRate(string code, string Name, string Rate, string Language) { if (Session[Util.ProjectConfig.ADMINUSER] == null) { return(""); } Model.Rate rate = new Model.Rate(); if (Language == "cn") { rate.Name_cn = Name; } if (Language == "tw") { rate.Name_tw = Name; } if (Language == "en") { rate.Name_en = Name; } if (Language == "th") { rate.Name_th = Name; } if (Language == "vn") { rate.Name_vn = Name; } rate.Rate1 = Convert.ToDecimal(Rate); rate.Lasttime = DateTime.Now; Model.Manager m = Session[ProjectConfig.ADMINUSER] as Model.Manager; rate.Operator = m.ManagerId; rate.Code = code; string strHostName = Dns.GetHostName(); System.Net.IPAddress[] addressList = Dns.GetHostByName(Dns.GetHostName()).AddressList; rate.Ip = addressList[0].ToString(); bool reval = BLL.RateManager.AddRate(rate); if (reval) { Rates rates = new Rates(); rates.Name = Name; rates.Rate = Convert.ToDecimal(Rate); rates.Lasttime = DateTime.Now; rates.Operator = m.ManagerId; rates.Ip = addressList[0].ToString(); return(DAL.ObjectToJson.ObjectsToJson <Rates>(rates)); } else { return("none"); } }
protected bool LoginAuto(string un, string pwd) { bool userpassword = false; Model.Manager LAM = new Model.Manager(); LAM.Name = un; LAM.Password = pwd; BLL.Manager LA = new BLL.Manager(); userpassword = LA.ValidatePassword(LAM); return(userpassword); }
private void tbID_TextChanged_1(object sender, EventArgs e) { Maticsoft.BLL.Manager man = new BLL.Manager(); string string1 = string.Format("manID = '{0}'", tbID.Text.Trim()); if (man.GetRecordCount(string1) == 1) { Model.Manager manmodel = new Model.Manager(); nudAge.Value = man.GetModel1(string1).manAge; } else { nudAge.Value = 18; } }
public ActionResult Test() { DotNet.SSO.IDal.IManagerDal managerDal = new DotNet.SSO.Dal.ManagerDal(); DotNet.SSO.Model.Manager manager = new Model.Manager() { LoginName="admin", DelFlag=1, EncryptKey="abc123", LoginPwd=DotNet.Utils.Encrypt.EncryptHelper.AESEncryString("123456","abc123"), ReMark="" }; managerDal.AddEntity(manager); return View(); }
public Model.Manager GetManagerName(string r_id) { string strSql = "select m_name from [Manager] where m_id=@r_id"; SqlParameter[] parameters ={ new SqlParameter ("@r_id",SqlDbType .VarChar,50), }; parameters[0].Value = r_id; Model.Manager model = new Model.Manager(); DataTable dt = SqlDbHelper.ExecuteDataTable(strSql.ToString(), CommandType.Text, parameters); if(dt.Rows.Count > 0) { model.Name = dt.Rows[0].ItemArray[0].ToString(); } return model; }
public Model.Manager AddManager(RLib.DB.DbConn dbconn, Model.Manager model) { string sql = "insert into manager(name,subname,loginname,loginpwd,allowlogin,state,createtime,remark)" + "values(@name,@subname,@loginname,@loginpwd,@allowlogin,@state,getdate(),@remark);"; dbconn.ExecuteSql(sql, new { name = model.Name, subname = model.SubName ?? "", loginname = model.LoginName ?? "", loginpwd = model.LoginPwd ?? "", allowlogin = model.AllowLogin, state = model.State, remark = model.Remark ?? "" }); model.ManagerId = dbconn.GetIdentity(); return(model); }
public void BorrowVIdErrTest() { Model.Book book = new Model.Book(); Model.Viewer viewer = new Model.Viewer(); Model.Manager manager = new Model.Manager(); book.Id = "book"; viewer.Id = "s000001";//学号错误 manager.Id = "manager"; //bool expected = false; //期望值 //bool actual; int expected = 0; //期望值 Hashtable actual; SQLDAL.Book target = new SQLDAL.Book(); actual = target.Borrow(book, viewer, manager); //实际值 Assert.AreEqual(expected, actual["result"]); }
public void BorrowTest() { Model.Book book = new Model.Book(); Model.Viewer viewer = new Model.Viewer(); Model.Manager manager = new Model.Manager(); book.Id = "book"; viewer.Id = "st"; manager.Id = "manager"; // bool expected = false; //期望值//因为数据库中已经存在这一项数据 所以为false //bool actual; int expected = 0; //期望值//因为数据库中已经存在这一项数据 所以为false Hashtable actual; SQLDAL.Book target = new SQLDAL.Book(); actual = target.Borrow(book, viewer, manager); //实际值 Assert.AreEqual(expected, actual["result"]); }
private void btConfirm_Click(object sender, EventArgs e) { if (tbID.Text.Trim() == "" || tbName.Text.Trim() == "" || cbSex.Text == "" || nupAge.Value.ToString() == "" || pbPhoto.Image == null) { MessageBox.Show("输入信息不完整!", "添加失败", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); flag = 1; } if (flag == 0) { Maticsoft.BLL.Manager man = new BLL.Manager(); Model.Manager manmodel = new Model.Manager(); string str1 = string.Format("manID = '{0}'", tbID.Text.Trim()); if (man.GetRecordCount(str1) > 0) { MessageBox.Show("当前工号已存在!", "添加失败", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } else { manmodel.manID = tbID.Text.Trim(); manmodel.manName = tbName.Text.Trim(); manmodel.manSex = cbSex.Text.Trim(); manmodel.manAge = Convert.ToInt32(nupAge.Value); manmodel.passwd = null; manmodel.manPhoto = mybyte; if (man.Add(manmodel) == true) { MessageBox.Show("添加成功!"); ((Main_Admin)this.Owner).ManagerLoad(); this.Close(); } else { MessageBox.Show("添加失败!"); } } } }
private void btConfirm_Click(object sender, EventArgs e) { if (tbID.Text.Trim() == "") { MessageBox.Show("输入信息不完整!", "修改失败", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); flag = 1; } if (flag == 0) { Maticsoft.BLL.Manager man = new BLL.Manager(); string string1 = string.Format("manID = '{0}'", tbID.Text.Trim()); if (man.GetRecordCount(string1) == 1) { Model.Manager manmodel = new Model.Manager(); manmodel.manID = tbID.Text.Trim(); manmodel.manName = tbName.Text.Trim(); manmodel.manSex = cbSex.Text.Trim(); manmodel.manAge = Convert.ToInt32(nudAge.Value); manmodel.passwd = null; manmodel.manPhoto = mybyte; if (man.Update(manmodel) == true) { MessageBox.Show("修改成功!"); ((Main_Admin)this.Owner).ManagerLoad(); this.Close(); } else { MessageBox.Show("修改失败!"); } } else { MessageBox.Show("不存在此员工!", "修改出错", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } }
public void MulBorrowTest() { Model.Book book = new Model.Book(); Model.Viewer viewer = new Model.Viewer(); Model.Manager manager = new Model.Manager(); book.Id = "9787513318525"; viewer.Id = "st"; manager.Id = "manager"; // bool expected = false; //期望值 //bool actual; int expected = -1; //期望值 已经借过的返回值为-1 Hashtable actual; SQLDAL.Book target = new SQLDAL.Book(); target.Borrow(book, viewer, manager);//第一次借 actual = target.Borrow(book, viewer, manager); //实际值//第二次借 Assert.AreEqual(expected, actual["result"]); //由于系统限制每个人只能借同一本书一次 所以测试时只有第一次是能成功 }
public SeekManager(Model.Manager man) { manmodel = man; InitializeComponent(); }
internal static Manager ToObject(Model.Manager manager) { return(manager == null ? null : new Manager(manager.Id, manager.SecondName)); }
public bool ValidatePassword(Model.Manager MM) { DAL.Manager VP = new DAL.Manager(); return(VP.SelectCount(MM)); }
public void ReturnBIdErrTest() { string b_id = "9787550264"; string r_id = "s001"; Model.Viewer v = new Model.Viewer(); v.Id = r_id; Model.Book b = new Model.Book(); b.Id = b_id; Model.Manager m = new Model.Manager(); //m.Id = m_id; //Model.Book book = new Model.Book(); //Model.Viewer viewer = new Model.Viewer(); Model.Manager manager = new Model.Manager(); //book.Id = "boo";//书号错误 //viewer.Id = "st"; manager.Id = "manager"; bool expected = false; //期望值 bool actual; SQLDAL.Book target = new SQLDAL.Book(); actual = target.ReturnBook(v, b, manager); //实际值 Assert.AreEqual(expected, actual); }
public string UpdateRate(string Id, string Name, string uName, string Rate, string Language) { if (Session[Util.ProjectConfig.ADMINUSER] == null) { return(""); } string json = ""; if (Name != uName) { if (RateManager.CeliName(Name, Language)) { json = "stop"; } } if (json != "stop") { Model.Rate rate = new Model.Rate(); if (Language == "cn") { rate.Name_cn = Name; } if (Language == "tw") { rate.Name_tw = Name; } if (Language == "en") { rate.Name_en = Name; } if (Language == "th") { rate.Name_th = Name; } if (Language == "vn") { rate.Name_vn = Name; } rate.Id = Convert.ToInt32(Id); rate.Rate1 = Convert.ToDecimal(Rate); rate.Lasttime = DateTime.Now; Model.Manager m = Session[ProjectConfig.ADMINUSER] as Model.Manager; rate.Operator = m.ManagerId; string strHostName = Dns.GetHostName(); System.Net.IPAddress[] addressList = Dns.GetHostByName(Dns.GetHostName()).AddressList; rate.Ip = addressList[0].ToString(); bool reval = BLL.RateManager.UpdateRate(rate); if (reval) { bool ret = BLL.RatehistoryManager.AddRatehistory(rate); if (ret) { Rates rates = new Rates(); rates.Name = Name; rates.Rate = Convert.ToDecimal(Rate); rates.Lasttime = DateTime.Now; rates.Operator = m.ManagerId; rates.Ip = addressList[0].ToString(); json = DAL.ObjectToJson.ObjectsToJson <Rates>(rates); } else { json = "none"; } } } return(json); }
public void ReturnTest() { Model.Book book = new Model.Book(); Model.Viewer viewer = new Model.Viewer(); Model.Manager manager = new Model.Manager(); book.Id = "9787569902921"; viewer.Id = "s001"; manager.Id = "manager"; bool expected = false; //期望值//因为数据库中已经存在这一项数据 所以为false bool actual; SQLDAL.Book target = new SQLDAL.Book(); actual = target.ReturnBook(viewer, book, manager); //实际值 Assert.AreEqual(expected, actual); }
private void GetAllVehiclesForTheDay(string state, string auctionName, string listAllLink) { var there = false; while (!there) { try { Browser.GoTo(listAllLink.Replace("standard", "enhanced")); there = true; } catch (WC.Exceptions.TimeoutException) { } } var dataTable = Browser.ElementOfType <WC.Table>(WC.Find.ByClass("dataTable")); if (!dataTable.Exists) { return; } var dataHeader = dataTable.ChildWithTag("thead", WC.Find.Any).AsElementContainer(); var trHeader = dataHeader.ElementsOfType <WC.TableRow>().First(); foreach (var cell in trHeader.ChildrenWithTag("th")) { Debug.WriteLine(Regex.Replace(cell.Text, @"[\W]", "")); } var dataBody = dataTable.TableBody(WC.Find.Any); var manheimModel = new Manheim.Model.ManheimEntities(dbPath); var stateEntity = manheimModel.States.Where(s => s.Name == state).SingleOrDefault(); if (stateEntity == null) { Log = new Exception("State " + state + " is not found."); return; } var mainColumn = Browser.Divs.Filter(WC.Find.ById("mainColumn")).Single(); #region Get Manager Model.Manager managerEntity = null; var para = mainColumn.Para(p => p.Children().Select(c => c.TagName).DefaultIfEmpty("").First() == "B"); if (para != null) { var b = para.Children().First(); var managerName = b.Exists && b.TextAfter.Contains("-") ? b.Text.Trim() : ""; managerEntity = manheimModel.Managers.SingleOrDefault(m => m.Name == managerName); if (managerEntity == null && !string.IsNullOrEmpty(managerName)) { var managerTitle = b.Exists ? b.TextAfter.Split('-')[1].Trim() : ""; b = b.Exists ? b.NextSibling : b; var phoneFaxMail = b.Exists ? b.TextAfter.Split(';') : new string[0]; var phone = phoneFaxMail.Length > 0 ? phoneFaxMail[0].Split(':')[1].Trim() : ""; var fax = phoneFaxMail.Length > 1 ? phoneFaxMail[1].Split(':')[1].Trim() : ""; var email = b.Exists ? b.NextSibling.Text.Trim() : ""; managerEntity = new Model.Manager() { Name = managerName, Title = managerTitle, Phone = phone, Fax = fax, Email = email }; manheimModel.Managers.Add(managerEntity); manheimModel.SaveChanges(); } } else { managerEntity = manheimModel.Managers.SingleOrDefault(m => m.Name == ""); if (managerEntity == null) { managerEntity = new Model.Manager() { Email = "", Fax = "", Phone = "", Title = "", Name = "" }; manheimModel.Managers.Add(managerEntity); manheimModel.SaveChanges(); } } #endregion #region Get Auction var auctionEntity = manheimModel.Auctions.SingleOrDefault(a => a.Name == auctionName); if (auctionEntity == null) { auctionEntity = new Model.Auction() { Name = auctionName, State = stateEntity, PreSaleManager = managerEntity }; manheimModel.Auctions.Add(auctionEntity); manheimModel.SaveChanges(); } #endregion var saleDateText = mainColumn.ElementWithTag("h4", WC.Find.ByText(new Regex(@"\d{2}/\d{2}/\d{4}"))).Text.Split('-')[0].Trim(); DateTime saleDate; if (!DateTime.TryParse(saleDateText, out saleDate)) { Log = new Exception("Sale date not found for " + auctionName + " in " + state); return; } #region if(false)Delete by SaleDate var md = ((IObjectContextAdapter)manheimModel).ObjectContext.MetadataWorkspace; var item = md.GetItems(DataSpace.CSpace); item = md.GetItems(DataSpace.CSSpace); item = md.GetItems(DataSpace.OCSpace); item = md.GetItems(DataSpace.OSpace); item = md.GetItems(DataSpace.SSpace); if (false) { var preSaleTable = typeof(Model.PreSale).GetCustomAttributes(typeof(EdmEntityTypeAttribute), true).Cast <EdmEntityTypeAttribute>().First(); var auctionIdField = ExpressionExtentions.GetLambda(() => new Model.PreSale().AuctionId); manheimModel.Database.ExecuteSqlCommand("DELETE " + preSaleTable.Name + " WHERE " + auctionIdField + " = {0}", auctionEntity.AuctionId); } #endregion //dataBody.OwnTableRows.ToList().ForEach(tr => foreach (var tr in dataBody.OwnTableRows) { var tds = tr.OwnTableCells; if (tds.Count == 0) { continue; } var vin = tds[6].Text + ""; var addPresSale = false; lock (auctionEntity) { addPresSale = !manheimModel.PreSales.Any(ps => ps.SaleDate == saleDate && ps.VIN == vin); } if (addPresSale) { try { WC.IE vehicleInfoIE = OpenVehicleInfoWindow(tds); if (vehicleInfoIE != null) { AddPreSale(manheimModel, auctionEntity, saleDate, tds, vin, vehicleInfoIE); } } catch (System.Data.Entity.Validation.DbEntityValidationException exc) { var ev = exc.EntityValidationErrors.First().ValidationErrors.First().ErrorMessage; Log = new Exception(ev); } } } }
public void MulReturnTest() { Model.Book book = new Model.Book(); Model.Viewer viewer = new Model.Viewer(); Model.Manager manager = new Model.Manager(); book.Id = "9787513318525"; viewer.Id = "st"; manager.Id = "manager"; bool expected = false; //期望值 bool actual; SQLDAL.Book target = new SQLDAL.Book(); target.ReturnBook(viewer, book, manager); //第一次还 actual = target.ReturnBook(viewer, book, manager); //实际值//第二次还 Assert.AreEqual(expected, actual); }
public void ReturnVIdErrTest() { Model.Book book = new Model.Book(); Model.Viewer viewer = new Model.Viewer(); Model.Manager manager = new Model.Manager(); book.Id = "book"; viewer.Id = "s00001";//学号错误 manager.Id = "manager"; bool expected = false; //期望值 bool actual; SQLDAL.Book target = new SQLDAL.Book(); actual = target.ReturnBook(viewer, book, manager); //实际值 Assert.AreEqual(expected, actual); }