private void EditCustomer()
{
var id = ParseInt(Utility.Decrypt(_key));
var obj = CustomerInstance.Find(f => f.id == id);
if (null == obj)
{
ShowNotification("./customers.aspx", "Error: could not find the customer.", false);
}
else
{
BuilldCustomer(obj);
var chk = CustomerInstance.Find(f => f.Code.Equals(obj.Code) && f.id != id);
if (null != chk)
{
ShowNotification("./customer_new.aspx", "Error: there have a same customer code exists.", false);
}
else
{
Update(obj);
// 保存历史记录
SaveHistory(new TB_AccountHistory()
{
ActionId = ActionInstance.Find(f => f.Name.Equals("EditCustomer")).id,
ObjectA = CustomerInstance.ToString(obj)
});
ShowNotification("./customers.aspx", "You have changed the customer: " + CustomerInstance.ToString(obj) + ".");
}
}
}
/// <summary>
/// 处理查询客户信息的请求
/// </summary>
private void HandleCustomerQuery()
{
var ret = "[]";
switch (cmd)
{
case "query":
// 查询Name或Code
var query = CustomerInstance.FindList(f => (f.Name.IndexOf(data) >= 0 ||
f.Code.IndexOf(data) >= 0) && f.Delete == false);
ret = JsonConverter.ToJson(query);
break;
case "customer":
var id = ParseInt(Utility.Decrypt(data));
var c = CustomerInstance.FindList(f => f.id == id && f.Delete == false);
ret = JsonConverter.ToJson(c);
break;
case "login":
// 客户登陆
ret = HandleCustomerLogin();
break;
}
ResponseJson(ret);
}
/// <summary>
/// 关闭已打开的bll instances
/// </summary>
private void CloseBlls()
{
TrackerPositionInstance.Close();
StorageInstance.Close();
PositionInstance.Close();
EquipmentInstance.Close();
EposInstance.Close();
DataInstance.Close();
DailyInstance.Close();
CustomerInstance.Close();
AlarmInstance.Close();
}
private void ShowEdit()
{
var obj = CustomerInstance.Find(f => f.id == ParseInt(Utility.Decrypt(_key)));
if (null == obj)
{
ShowNotification("./customers.aspx", "Error: paramenter error, cannot edit the customer.", false);
}
else
{
txtAddress.Value = obj.Address;
txtCode.Value = obj.Code;
txtIdCard.Value = obj.IdCard;
txtName.Value = obj.Name;
txtPhone.Value = obj.Phone;
}
}
private void ShowCustomers()
{
var totalRecords = 0;
var pageIndex = "" == hidPageIndex.Value ? 1 : int.Parse(hidPageIndex.Value);
pageIndex = (0 >= pageIndex ? 1 : pageIndex);
var list = CustomerInstance.FindPageList <TB_Customer>(pageIndex, PageSize, out totalRecords,
f => f.Name.IndexOf(txtName.Value.Trim()) >= 0 && f.Code.IndexOf(txtCode.Value.Trim()) >= 0 && f.Delete == false, "Name");
var totalPages = totalRecords / PageSize + (totalRecords % PageSize > 0 ? 1 : 0);
string html = "";
if (totalRecords < 1)
{
html = "<tr><td colspan=\"7\">No records, You can change the condition and try again " +
"or <a href=\"./customer_new.aspx\">ADD</a> some customer's informations.</td></tr>";
}
else
{
var cnt = (pageIndex - 1) * PageSize;
foreach (var obj in list)
{
cnt++;
var id = Utility.UrlEncode(Utility.Encrypt(obj.id.ToString()));
html += "<tr>" +
"<td style=\"text-align: center;\"><input type=\"checkbox\" id=\"cb_" + id + "\" /></td>" +
"<td style=\"text-align: center;\">" + cnt + "</td>" +
"<td><a href=\"./customer_new.aspx?key=" + id + "\" >" + obj.Name + "</a></td>" +
"<td>" + obj.Code + "</td>" +
"<td>" + obj.Phone + "</td>" +
"<td>" + obj.Fax + "</td>" +
"<td>" + obj.Address + "</td>" +
"<td></td>" +
"</tr>";
}
}
tbodyBody.InnerHtml = html;
divPagging.InnerHtml = "";
if (totalRecords > 0)
{
ShowPaggings(pageIndex, totalPages, totalRecords, "./customers.aspx", divPagging);
}
}
private string HandleCustomerLogin()
{
var ret = "{\"status\":-1,\"desc\":\"error\"}";
var tmp = data.Trim().Split(new char[] { ',' });
var uid = tmp[0].Trim();
if (uid.Length > 20)
{
uid = uid.Substring(0, 20);
}
var pwd = tmp[1].ToUpper().Trim();
if (pwd.Length > 32)
{
pwd = pwd.Substring(0, 32);
}
var query = CustomerInstance.FindList(f => (f.Code.Equals(uid) || f.Phone.IndexOf(uid) >= 0) && f.Delete == false);
var guest = query.Count() > 0 ? query.FirstOrDefault() : null;
if (null != guest)
{
if (guest.Password.Equals(pwd))
{
ret = "{\"status\":0,\"desc\":\"success\"}";
CustomerInstance.Update(f => f.id == guest.id, update => {
update.SignInTime = DateTime.Now;
update.SignInIP = Utility.GetClientIP(ctx);
});
ctx.Session[Utility.SessionNameCustomer] = guest;
}
else
{
ret = "{\"status\":-1,\"desc\":\"Password error.\"}";
}
}
else
{
ret = "{\"status\":-1,\"desc\":\"Not exist phone number.\"}";
}
return(ret);
}
protected void btDelete_Click(object sender, EventArgs e)
{
if (!HasSessionLose)
{
if ("" != hidID.Value)
{
var ids = GetIdList(hidID.Value.Split(new char[] { ',' }));
var list = CustomerInstance.FindList(f => ids.Contains(f.id) && f.Delete == false);
foreach (var obj in list)
{
obj.Delete = true;
Update(obj);
SaveHistory(new TB_AccountHistory
{
ActionId = ActionInstance.Find(f => f.Name.Equals("DeleteCustomer")).id,
ObjectA = CustomerInstance.ToString(obj)
});
}
ShowNotification("./customers.aspx", "Success: You have delete " + ids.Count() + " customer(s).");
}
}
}
private void NewCustomer()
{
var obj = CustomerInstance.Find(f => f.Code.Equals(txtCode.Value.Trim()));
if (null != obj)
{
ShowNotification("./customer_new.aspx", "Error: same customer number exists.", false);
}
else
{
obj = CustomerInstance.GetObject();
BuilldCustomer(obj);
CustomerInstance.Add(obj);
// 保存历史记录
SaveHistory(new TB_AccountHistory()
{
ActionId = ActionInstance.Find(f => f.Name.Equals("AddCustomer")).id,
ObjectA = CustomerInstance.ToString(obj)
});
ShowNotification("./customer_new.aspx", "You added a new customer into system.");
}
}
/// <summary>
/// Save customer record
/// </summary>
public static void SaveCustomer(bool IsNew, CustomerInstance objParams)
{
BrightPlatformEntities m_objBrightPlatformEntity = new BrightPlatformEntities(UserSession.EntityConnection);
var objCustomer = m_objBrightPlatformEntity.customers.CreateObject();
if (!IsNew)
{
objCustomer = null;
objCustomer = m_objBrightPlatformEntity.customers.Where(objField => objField.id == objParams.id).SingleOrDefault();
}
else
objCustomer.created_date = DateTime.Now;
objCustomer.customer_name = objParams.customer_name;
objCustomer.org_no = objParams.org_no;
objCustomer.reference_no = objParams.reference_no;
objCustomer.disabled = objParams.active == true? "0": "1";
objCustomer.owner = objParams.owner_name;
//objCustomer.address = objParams.address;
objCustomer.description = objParams.description;
objCustomer.modified_by = UserSession.CurrentUser.UserId;
objCustomer.modified_date = DateTime.Now;
if (IsNew)
m_objBrightPlatformEntity.customers.AddObject(objCustomer);
m_objBrightPlatformEntity.SaveChanges();
}
