/// <summary>
/// 提交添加
/// </summary>
private bool SubmintAdd()
{
try
{
var member = new LHCustomerLink
{
FCode = txtFCode.Text.Trim(),
FName = tbxFCustomer.Text.Trim(),
FAddress = txtFAddress.Text.Trim(),
FLinkman = txtFLinkman.Text.Trim(),
FPhome = txtFPhome.Text.Trim(),
FMoile = txtFMoile.Text.Trim(),
FMemo = txtFMemo.Text.Trim(),
FSpell = ChineseSpell.MakeSpellCode(tbxFCustomer.Text.Trim(), "",
SpellOptions.FirstLetterOnly).ToUpper(),
FCompanyId = CurrentUser.AccountComId,
FCity = txtFCity.Text.Trim(),
FZip = txtFZip.Text.Trim(),
};
return(CustomerLinkService.Add(member));
}
catch (Exception ex)
{
throw;
}
}
/// <summary>
///
/// </summary>
private void BindDataGrid()
{
var list = CustomerLinkService.Where(p => p.FCode == FCode && p.FCompanyId == CurrentUser.AccountComId).ToList();
//绑定数据源
Grid1.DataSource = list;
Grid1.DataBind();
}
/// <summary>
/// Grid1_RowCommand
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Grid1_RowCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "Delete" || e.CommandName == "Add")
{
var datakey = Convert.ToInt32(Grid1.DataKeys[e.RowIndex][1]);
CustomerLinkService.Delete(p => p.FId == datakey && p.FCompanyId == CurrentUser.AccountComId);
BindDataGrid();
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnBatchDelete_Click(object sender, EventArgs e)
{
IEnumerable <int> selectIds = GetSelectIds();
try
{
CustomerLinkService.Delete(p => p.FCompanyId == CurrentUser.AccountComId && selectIds.Contains(p.FId));
Alert.Show("删除成功！", MessageBoxIcon.Information);
BindDataGrid();
}
catch (Exception)
{
Alert.Show("删除失败！", MessageBoxIcon.Warning);
}
}
/// <summary>
/// 提交编辑
/// </summary>
private bool SubmintEdit()
{
if (Link != null)
{
Link.FCode = txtFCode.Text.Trim();
Link.FName = tbxFCustomer.Text.Trim();
Link.FAddress = txtFAddress.Text.Trim();
Link.FLinkman = txtFLinkman.Text.Trim();
Link.FPhome = txtFPhome.Text.Trim();
Link.FMoile = txtFMoile.Text.Trim();
Link.FMemo = txtFMemo.Text.Trim();
Link.FSpell = ChineseSpell.MakeSpellCode(tbxFCustomer.Text.Trim(), "",
SpellOptions.FirstLetterOnly).ToUpper();
Link.FCity = txtFCity.Text.Trim();
Link.FZip = txtFZip.Text.Trim();
return(CustomerLinkService.SaveChanges() >= 0);
}
return(false);
}
/// <summary>
/// 绑定数据表格
/// </summary>
private void BindDataGrid()
{
int output;
dynamic orderingSelector;
Expression <Func <LHCustomerLink, bool> > predicate = BuildPredicate(out orderingSelector);
//取数据源
IQueryable <LHCustomerLink> list = CustomerLinkService.Where(predicate, Grid1.PageSize, Grid1.PageIndex + 1,
orderingSelector, EnumHelper.ParseEnumByString <OrderingOrders>(SortDirection), out output);
//设置页面大小
Grid1.RecordCount = output;
//绑定数据源
Grid1.DataSource = list;
Grid1.DataBind();
ddlPageSize.SelectedValue = Grid1.PageSize.ToString(CultureInfo.InvariantCulture);
}
private void GridEdit()
{
#region update
var dictModified = Grid1.GetModifiedDict();
foreach (var rowKey in dictModified.Keys)
{
int datakey = Convert.ToInt32(Grid1.DataKeys[rowKey][1].ToString());
var sKeys = new StringBuilder();
var sValues = new StringBuilder();
foreach (var key in dictModified[rowKey].Keys)
{
sKeys.AppendFormat("{0},", key);
}
foreach (var dictValue in dictModified[rowKey].Values)
{
sValues.AppendFormat("{0},", dictValue);
}
var details = CustomerLinkService.Where(p => p.FId == datakey && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault();
var keys = sKeys.ToString().Split(',');
var values = sValues.ToString().Split(',');
for (int i = 0; i < keys.Count(); i++)
{
#region 修改内容
var key = keys[i];
var value = values[i];
if (!string.IsNullOrEmpty(key))
{
if (details != null)
{
if (key.Equals("FLinkman"))
{
details.FLinkman = value;
}
if (key.Equals("FAddress"))
{
details.FAddress = value;
}
if (key.Equals("FPhome"))
{
details.FPhome = value;
}
if (key.Equals("FMoile"))
{
details.FMoile = value;
}
if (key.Equals("FMemo"))
{
details.FMemo = value;
}
if (key.Equals("FType"))
{
details.FType = value;
}
}
}
#endregion
}
CustomerLinkService.SaveChanges();
}
#endregion
var addList = Grid1.GetNewAddedList();
#region AddRow
foreach (var add in addList)
{
var sKeys = new StringBuilder();
var sValues = new StringBuilder();
foreach (var key in add.Keys)
{
sKeys.AppendFormat("{0},", key);
}
foreach (var dictValue in add.Values)
{
sValues.AppendFormat("{0},", dictValue);
}
var keys = sKeys.ToString().Split(',');
var values = sValues.ToString().Split(',');
var details = new LHCustomerLink();
for (int i = 0; i < keys.Count(); i++)
{
#region 修改内容
details.FCompanyId = CurrentUser.AccountComId;
details.FCode = FCode;
var key = keys[i];
var value = values[i];
if (!string.IsNullOrEmpty(key))
{
if (key.Equals("FLinkman"))
{
details.FLinkman = value;
}
if (key.Equals("FAddress"))
{
details.FAddress = value;
}
if (key.Equals("FPhome"))
{
details.FPhome = value;
}
if (key.Equals("FMoile"))
{
details.FMoile = value;
}
if (key.Equals("FMemo"))
{
details.FMemo = value;
}
if (key.Equals("FType"))
{
details.FType = value;
}
}
#endregion
}
CustomerLinkService.Add(details);
}
#endregion
}
