public JsonResult LoadCustomers()
{
string strErrText = string.Empty;
CustomerSystem customer = new CustomerSystem();
List<Customer> listCustomer = customer.LoadCustomers(LoginAccountId, LoginStaffName, out strErrText);
if (listCustomer == null)
{
throw new Exception(strErrText);
}
var ret = from c in listCustomer
select new
{
c.Id,
c.Name
};
return Json(ret, JsonRequestBehavior.AllowGet);
}
public ActionResult ExportCustomers()
{
string strErrText;
//读取全部数据
CustomerSystem customer = new CustomerSystem();
List<Customer> listCustomer = customer.LoadCustomers(LoginAccountId, LoginStaffName, out strErrText);
if (listCustomer == null)
{
throw new Exception(strErrText);
}
//生成GridView
BoundField colCustomerId = new BoundField();
colCustomerId.HeaderText = InnoSoft.LS.Resources.Labels.CustomerId;
colCustomerId.DataField = "CustomerId";
BoundField colName = new BoundField();
colName.HeaderText = InnoSoft.LS.Resources.Labels.CustomerName;
colName.DataField = "Name";
BoundField colFullName = new BoundField();
colFullName.HeaderText = InnoSoft.LS.Resources.Labels.CustomerFullName;
colFullName.DataField = "FullName";
BoundField colWarningStock = new BoundField();
colWarningStock.HeaderText = InnoSoft.LS.Resources.Labels.WarningStock;
colWarningStock.DataField = "WarningStock";
BoundField colStopStock = new BoundField();
colStopStock.HeaderText = InnoSoft.LS.Resources.Labels.StopStock;
colStopStock.DataField = "StopStock";
BoundField colSettlementExpression = new BoundField();
colSettlementExpression.HeaderText = InnoSoft.LS.Resources.Labels.SettlementExpression;
colSettlementExpression.DataField = "SettlementExpression";
BoundField colValuationMode = new BoundField();
colValuationMode.HeaderText = InnoSoft.LS.Resources.Labels.ValuationMode;
colValuationMode.DataField = "ValuationMode";
BoundField colGrossWeightRate = new BoundField();
colGrossWeightRate.HeaderText = InnoSoft.LS.Resources.Labels.GrossWeightRate;
colGrossWeightRate.DataField = "GrossWeightRate";
BoundField colOwnOrganId = new BoundField();
colOwnOrganId.HeaderText = InnoSoft.LS.Resources.Labels.OwnOrganId;
colOwnOrganId.DataField = "OwnOrganId";
BoundField colOwnOrganName = new BoundField();
colOwnOrganName.HeaderText = InnoSoft.LS.Resources.Labels.OwnOrganName;
colOwnOrganName.DataField = "OwnOrganName";
BoundField colRemark = new BoundField();
colRemark.HeaderText = InnoSoft.LS.Resources.Labels.Remark;
colRemark.DataField = "Remark";
var grid = new GridView();
grid.Columns.Add(colCustomerId);
grid.Columns.Add(colName);
grid.Columns.Add(colFullName);
grid.Columns.Add(colWarningStock);
grid.Columns.Add(colStopStock);
grid.Columns.Add(colSettlementExpression);
grid.Columns.Add(colValuationMode);
grid.Columns.Add(colGrossWeightRate);
grid.Columns.Add(colOwnOrganId);
grid.Columns.Add(colOwnOrganName);
grid.Columns.Add(colRemark);
grid.AutoGenerateColumns = false;
grid.DataSource = from c in listCustomer
select new
{
CustomerId = c.Id,
Name = c.Name,
FullName = c.FullName,
WarningStock = c.WarningStock > 0 ? c.WarningStock.ToString() : string.Empty,
StopStock = c.StopStock > 0 ? c.StopStock.ToString() : string.Empty,
SettlementExpression = c.SettlementExpression,
ValuationMode = c.ValuationMode,
GrossWeightRate = c.GrossWeightRate > 0 ? c.GrossWeightRate.ToString("#0.######") : string.Empty,
OwnOrganId = c.OwnOrganId,
OwnOrganName = c.OwnOrganName,
Remark = c.Remark
};
grid.DataBind();
//导出GridView
Response.ClearContent();
Response.Charset = InnoSoft.LS.Resources.Encoding.ExcelCharset;
Response.ContentEncoding = System.Text.Encoding.GetEncoding(InnoSoft.LS.Resources.Encoding.ExcelContent);
Response.ContentType = "application/ms-excel";
Response.Write("<meta http-equiv=Content-Type content=text/html charset=" + InnoSoft.LS.Resources.Encoding.ExcelCharset + ">");
Response.AddHeader("content-disposition", "attachment; filename=Customer.xls");
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
return View("SetCustomer");
}
public JsonResult LoadCustomerFullNames(string term)
{
//读取所有客户数据
string strErrText = string.Empty;
CustomerSystem customer = new CustomerSystem();
List<Customer> listCustomer = customer.LoadCustomers(LoginAccountId, LoginStaffName, out strErrText);
if (listCustomer == null)
{
listCustomer = new List<Customer>();
}
//提取客户全称中包含关键字的记录
var ret = (
from c in listCustomer
where c.FullName.Contains(term)
select c.FullName).ToArray();
return Json(ret, JsonRequestBehavior.AllowGet);
}
public ActionResult ModifyAccount(string id)
{
string strErrText;
//生成Model数据
long nAccountId = long.Parse(id);
AuthenticateSystem auth = new AuthenticateSystem();
Account data = auth.LoadAccount(nAccountId, LoginAccountId, LoginStaffName, out strErrText);
if (data == null)
{
throw new Exception(strErrText);
}
AccountViewModel model = new AccountViewModel();
model.Id = data.Id;
model.Name = data.Name;
model.Password = data.Password;
model.AccountType = data.AccountType;
model.OrganId = data.AccountType == InnoSoft.LS.Resources.Options.Staff ? data.OrganId : 0;
model.StaffId = data.AccountType == InnoSoft.LS.Resources.Options.Staff ? data.StaffId : 0;
model.CustomerId = data.AccountType == InnoSoft.LS.Resources.Options.Staff ? 0 : data.OrganId;
model.ContactName = data.AccountType == InnoSoft.LS.Resources.Options.Staff ? string.Empty : data.StaffName;
model.IsCancel = data.IsCancel;
if (data.AccountType == InnoSoft.LS.Resources.Options.Staff)
{
//生成组织部门下拉列表
OrganizationSystem organ = new OrganizationSystem();
List<Organization> listOrganization = organ.LoadOrganizations(LoginAccountId, LoginStaffName, out strErrText);
if (listOrganization == null)
{
throw new Exception(strErrText);
}
List<SelectListItem> selectListOrganization = new List<SelectListItem>();
selectListOrganization.Add(new SelectListItem { Text = string.Empty, Value = "0" });
selectListOrganization.AddRange(from o in listOrganization
orderby o.FullName
select new SelectListItem
{
Text = o.FullName,
Value = o.Id.ToString()
});
ViewData["Organizations"] = new SelectList(selectListOrganization, "Value", "Text", model.OrganId);
//生成空的客户下拉列表
List<Customer> listCustomer = new List<Customer>();
List<SelectListItem> selectListCustomer = new List<SelectListItem>();
selectListCustomer.Add(new SelectListItem { Text = string.Empty, Value = "0" });
selectListCustomer.AddRange(from c in listCustomer
select new SelectListItem
{
Text = c.Name,
Value = c.Id.ToString()
});
ViewData["Customers"] = new SelectList(selectListCustomer, "Value", "Text");
}
else
{
//生成空的组织部门下拉列表
{
List<Organization> listOrganization = new List<Organization>();
List<SelectListItem> selectListOrganization = new List<SelectListItem>();
selectListOrganization.Add(new SelectListItem { Text = string.Empty, Value = "0" });
selectListOrganization.AddRange(from o in listOrganization
select new SelectListItem
{
Text = o.FullName,
Value = o.Id.ToString()
});
ViewData["Organizations"] = new SelectList(selectListOrganization, "Value", "Text");
}
//生成客户下拉列表
CustomerSystem customer = new CustomerSystem();
List<Customer> listCustomer = customer.LoadCustomers(LoginAccountId, LoginStaffName, out strErrText);
if (listCustomer == null)
{
throw new Exception(strErrText);
}
List<SelectListItem> selectListCustomer = new List<SelectListItem>();
selectListCustomer.Add(new SelectListItem { Text = string.Empty, Value = "0" });
selectListCustomer.AddRange(from c in listCustomer
orderby c.Name
select new SelectListItem
{
Text = c.Name,
Value = c.Id.ToString()
});
ViewData["Customers"] = new SelectList(selectListCustomer, "Value", "Text", model.OrganId);
}
//生成员工下拉列表
if (data.AccountType == InnoSoft.LS.Resources.Options.Staff)
{
StaffSystem staff = new StaffSystem();
List<Staff> listStaff = staff.LoadStaffsByOrganId(model.OrganId, LoginAccountId, LoginStaffName, out strErrText);
if (listStaff == null)
{
throw new Exception(strErrText);
}
List<SelectListItem> selectListStaff = new List<SelectListItem>();
selectListStaff.Add(new SelectListItem { Text = string.Empty, Value = "0" });
selectListStaff.AddRange(from s in listStaff
select new SelectListItem
{
Text = s.FullName,
Value = s.Id.ToString()
});
ViewData["Staffs"] = new SelectList(selectListStaff, "Value", "Text", model.StaffId);
}
else
{
List<Staff> listStaff = new List<Staff>();
List<SelectListItem> selectListStaff = new List<SelectListItem>();
selectListStaff.Add(new SelectListItem { Text = string.Empty, Value = "0" });
selectListStaff.AddRange(from s in listStaff
select new SelectListItem
{
Text = s.Name,
Value = s.Id.ToString()
});
ViewData["Staffs"] = new SelectList(selectListStaff, "Value", "Text");
}
return View(model);
}
