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