public ActionResult Details(string id)
{
int idC = Convert.ToInt32(id);
DistributorModel temp = db.Distributors.Where(ta => ta.ID == idC).SingleOrDefault();
return(View("Details", temp));
}
/// <summary>
/// 更新信息
/// </summary>
public int UpdateInfo(SqlTransaction trans, DistributorModel disModel, long SN)
{
string key = "Cache_Distributor_Model_" + SN;
CacheHelper.RemoveCache(key);
return(disDAL.UpdateInfo(trans, disModel, SN));
}
public void PopulateControls()
{
var cat = new PatternModel {
NickName = "Please Select", ID = 0
};
var cats = new List <PatternModel> {
cat
};
cats.AddRange(GetPattern());
ddlPattern.DataSource = cats;
ddlPattern.DataBind();
var coordinator = new UserModel {
ID = 0, Username = "******"
};
var coordinators = new List <UserModel> {
coordinator
};
coordinators.AddRange(GetCordinator());
ddlCoordinator.DataSource = coordinators;
ddlCoordinator.DataBind();
var distributor = new DistributorModel {
ID = 0, Name = "Please select"
};
var distributors = new List <DistributorModel> {
distributor
};
distributors.AddRange(GetDistributor());
ddlDistributor.DataSource = distributors;
ddlDistributor.DataBind();
}
public DistributorModel FindById(string id)
{
StartNewUnitOfWork();
DistributorModel qrCodeModel = distributorRepository.Get(id);
EndUnitOfWork();
return(qrCodeModel);
}
public static void BindProductToDistributorWithQrCode(string qrCode, string productName, string distributorName)
{
QrCodeModel qrCodeModel = qrCodeService.FindById(qrCode);
ProductModel product = productService.FindById(productName);
DistributorModel distributor = distributorService.FindById(distributorName);
qrCodeModel.Distributor = distributor;
qrCodeModel.Product = product;
qrCodeService.Update(qrCodeModel);
}
public void BindProductWithDistributor(string qrCodeId, string productNameId, string distributorId)
{
QrCodeModel qrCodeModel = qrCodeService.FindById(qrCodeId);
ProductModel product = productService.FindById(productNameId);
DistributorModel distributor = distributorService.FindById(distributorId);
qrCodeModel.Distributor = distributor;
qrCodeModel.Product = product;
qrCodeService.Update(qrCodeModel);
}
public ActionResult Create(DistributorModel dis)
{
if (dis != null)
{
db.Distributors.Add(dis);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(View());
}
}
public void TestBindingService()
{
string qrcode = "http://192.168.1.101:8080/qrcode-manage/0";
string distributorName = "河北";
string productName = "咳咳音乐";
QrCodeModel qrcodeModel = qrcodeService.FindById(qrcode);
DistributorModel distributorModel = distributorService.FindById(distributorName);
ProductModel productModel = productService.FindById(productName);
qrcodeModel.Distributor = distributorModel;
qrcodeModel.Product = productModel;
qrcodeService.Add(qrcodeModel);
}
public JsonResult Insert(DistributorModel data)
{
if (data.Code != null)
{
data.State = true;
data.Region = 2;
db.Distributors.Add(data);
db.SaveChanges();
return(Json("OK"));
}
else
{
return(Json("Loi"));
}
}
/// <summary>
/// 从缓存读取信息
/// </summary>
public DistributorModel GetCacheInfo(SqlTransaction trans, long SN)
{
string key = "Cache_Distributor_Model_" + SN;
object value = CacheHelper.GetCache(key);
if (value != null)
{
return((DistributorModel)value);
}
else
{
DistributorModel disModel = disDAL.GetInfo(trans, SN);
CacheHelper.AddCache(key, disModel, null, Cache.NoAbsoluteExpiration, TimeSpan.FromMinutes(20), CacheItemPriority.Normal, null);
return(disModel);
}
}
public async Task <JsonResult> DeleteAsync(int id)
{
try
{
DistributorModel model = new DistributorModel(_unitOfWork);
await model.DeleteAsync(id);
logger.Debug("Distributor deleted successfully.");
return(Json(new { result = true }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
logger.Error("Error while invoking Delete action method: ", ex);
return(Json(new { result = false, error = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Edit(DistributorModel dis, bool?IsChecked)
{
if (ModelState.IsValid)
{
if (IsChecked == true)
{
dis.State = true;
}
else
{
dis.State = false;
}
db.Entry(dis).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public async Task <JsonResult> GetDistributors()
{
try
{
logger.Debug("Search Controller GetDistributors action method is invoked");
DistributorModel model = new DistributorModel(_unitOfWork);
List <Distributor> records = await model.GetDistributorsByPageAsync(null, null, string.Empty, string.Empty, string.Empty, string.Empty);
return(this.Json(records.Select(x => new { Id = x.Id, Name = x.Name }), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
logger.Error("Error while invoking GetDistributors action method: ", ex);
return(this.Json(new { error = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public async Task <JsonResult> ListAsync(int?page, int?limit, string sortBy, string direction, string code, string name)
{
try
{
DistributorModel model = new DistributorModel(_unitOfWork);
List <Distributor> records = await model.GetDistributorsByPageAsync(page, limit, sortBy, direction, code, name);
int total = await model.GetTotalDistributorsAsync(page, limit, sortBy, direction, code, name);
logger.Debug("Distributor Controller List action method is invoked");
logger.Debug(string.Format("Total {0} distributors are found and {1} is returned", total, records.Count()));
return(this.Json(new { records, total }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
logger.Error("Error while invoking List action method: ", ex);
return(this.Json(new { error = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public Boolean edit(DistributorModel distributorModel)
{
try
{
string sqlString = "update tblDistributor set Distributor_Name = '" + distributorModel.distributorName +
"',Distributor_NumberPhone = '" + distributorModel.distributorNumberPhone +
"',Distributor_Manager = '" + distributorModel.distributorManager +
"',Distributor_Email = '" + distributorModel.distributorEmail +
"',Distributor_Address = '" + distributorModel.distributorAddress +
"',Distributor_Amount_Of_Debt = '" + distributorModel.distributorNotice +
"' where Distributor_Id ='" + distributorModel.distributorId + "'";
sqlConnection.Open();
SqlCommand sqlCommand = new SqlCommand(sqlString, sqlConnection);
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
return(true);
}
catch
{
return(false);
}
}
public Boolean add(DistributorModel distributorModel)
{
try
{
string sqlString = "Insert into tblDistributor Values('" + distributorModel.distributorId + "','"
+ distributorModel.distributorName + "','"
+ distributorModel.distributorNumberPhone + "','"
+ distributorModel.distributorManager + "','"
+ distributorModel.distributorEmail + "','"
+ distributorModel.distributorAddress + "','"
+ distributorModel.distributorNotice + "')";
sqlConnection.Open();
SqlCommand cmd = new SqlCommand(sqlString, sqlConnection);
cmd.ExecuteNonQuery();
sqlConnection.Close();
return(true);
}
catch
{
return(false);
}
}
public async Task <JsonResult> SaveAsync(DistributorViewModel record)
{
try
{
DistributorModel model = new DistributorModel(_unitOfWork);
if (ModelState.IsValid)
{
await model.SaveAsync(record);
logger.Debug("Distributor saved successfully.");
return(Json(new { result = true }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { result = false }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
logger.Error("Error while invoking Save action method: ", ex);
return(Json(new { result = false, error = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public void CreateDatabaseSchemaTest()
{
ProductModel product = new ProductModel();
StockLevelModel stockLevel1 = new StockLevelModel();
stockLevel1.Amount = 10;
stockLevel1.Products.Add(product);
product.ProductName = "可口可乐";
product.UnitName = "瓶子";
product.StockLevels.Add(stockLevel1);
productService.Add(product);
stockLevelService.Add(stockLevel1);
WarehouseModel warehouse = new WarehouseModel();
warehouse.Address = "chengdu shi";
warehouse.StockLevels.Add(stockLevel1);
stockLevel1.Warehouses.Add(warehouse);
warehouseService.Add(warehouse);
IList <string> productNames = productService.GetAllProductNames();
Console.WriteLine(productNames);
DistributorModel distributor = new DistributorModel();
distributor.Name = "黄凯";
distributor.Address = "贵州";
distributorService.Add(distributor);
IList <string> distributorNames = distributorService.GetAllDistributorNames();
Console.WriteLine(distributorNames);
}
public ActionResult ImportExcel()
{
HttpFileCollectionBase files = Request.Files;
HttpPostedFileBase FileUpload = files[0];
List <string> data = new List <string>();
if (FileUpload != null)
{
// tdata.ExecuteCommand("truncate table OtherCompanyAssets");
if (FileUpload.ContentType == "application/vnd.ms-excel" || FileUpload.ContentType == "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
{
string filename = FileUpload.FileName;
//string targetpath = Server.MapPath("~/Files/Excel");
string targetpath = "D:/MassMail/ImportFiles/";
FileUpload.SaveAs(targetpath + filename);
string pathToExcelFile = targetpath + filename;
var connectionString = "";
if (filename.EndsWith(".xls"))
{
connectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0; data source={0}; Extended Properties=Excel 8.0;", pathToExcelFile);
}
else if (filename.EndsWith(".xlsx"))
{
connectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\";", pathToExcelFile);
}
var adapter = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", connectionString);
var ds = new DataSet();
adapter.Fill(ds, "ExcelTable");
DataTable dtable = ds.Tables["ExcelTable"];
string sheetName = "Sheet1";
var excelFile = new ExcelQueryFactory(pathToExcelFile);
var dataExcel = from a in excelFile.Worksheet <DistributorModel>(sheetName) select a;
List <Contact> Contacts = new List <Contact>();
foreach (var item in dataExcel)
{
try
{
if (item.Code != "")
{
DistributorModel TU = new DistributorModel();
TU.Name = item.Name;
TU.Address = item.Address;
TU.ID = item.ID;
TU.Code = item.Code;
TU.AdminMail = item.AdminMail;
TU.SEMail = item.SEMail;
TU.AcMail = item.AcMail;
TU.ManagerMail = item.ManagerMail;
TU.Region = item.Region;
TU.State = true;
db.Distributors.Add(TU);
db.SaveChanges();
}
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
}
}
//deleting excel file from folder
if ((System.IO.File.Exists(pathToExcelFile)))
{
System.IO.File.Delete(pathToExcelFile);
}
return(PartialView("_GetListContacts", Contacts.ToList()));
}
}
return(View());
}
public ActionResult GetListSearch(string selectednumbers, string paramJson, DistributorModel NPP, int?page = 1)
{
//int pageSize = 6;
//int pageNumber = (page ?? 1);
//string s1 = Name;
var data = from a in db.Distributors
join b in db.Regions on a.Region equals b.ID
select new DistributorsView
{
ID = a.ID,
Region = a.Region,
Name = a.Name,
Code = a.Code,
AdminMail = a.AdminMail,
SEMail = a.SEMail,
AcMail = a.AcMail,
ManagerMail = a.ManagerMail,
State = a.State,
Address = a.Address,
Regions = b
};
if (!String.IsNullOrEmpty(NPP.Code))
{
data = data.Where(s => s.Code.ToString().ToUpper().Contains(NPP.Code.ToUpper()));
}
if (!String.IsNullOrEmpty(NPP.Name))
{
data = data.Where(s => s.Name.ToString().ToUpper().Contains(NPP.Name.ToUpper()));
}
if (!String.IsNullOrEmpty(NPP.SEMail))
{
data = data.Where(s => s.SEMail.ToString().ToUpper().Contains(NPP.SEMail.ToUpper()));
}
if (!String.IsNullOrEmpty(NPP.ManagerMail))
{
data = data.Where(s => s.ManagerMail.ToString().ToUpper().Contains(NPP.ManagerMail.ToUpper()));
}
if (!String.IsNullOrEmpty(NPP.AcMail))
{
data = data.Where(s => s.AcMail.ToString().ToUpper().Contains(NPP.AcMail.ToUpper()));
}
if (!String.IsNullOrEmpty(NPP.AdminMail))
{
data = data.Where(s => s.AdminMail.ToString().ToUpper().Contains(NPP.AdminMail.ToUpper()));
}
if (!String.IsNullOrEmpty(NPP.Address))
{
data = data.Where(s => s.Address.ToString().ToUpper().Contains(NPP.Address.ToUpper()));
}
var tempData = data;
List <DistributorsView> lst = new List <DistributorsView>();
if (selectednumbers == "")
{
lst = data.ToList();
}
else
{
string[] idR = selectednumbers.Split(',');
lst = lst.ToList();
foreach (string item in idR)
{
int id = Convert.ToInt32(item);
tempData = data.Where(s => s.Region == id);
lst.AddRange(tempData);
}
}
return(PartialView("_GetListSearch", lst.ToList()));
}
/// <summary>
/// 插入信息
/// </summary>
public int InsertInfo(SqlTransaction trans, DistributorModel disModel)
{
return(disDAL.InsertInfo(trans, disModel));
}
public Boolean add(DistributorModel distributorModel)
{
return(dalDistributor.add(distributorModel));
}
public ProfileIndexModel()
{
Distributor = new DistributorModel();
ProfileBoxes = new List <ProfileModel>();
}
public Boolean edit(DistributorModel distributorModel)
{
return(dalDistributor.edit(distributorModel));
}
public void Add(DistributorModel distributor)
{
StartNewUnitOfWork();
distributorRepository.Add(distributor);
EndUnitOfWork();
}
