public void Add(DataLayer.Model.FileReplace_RuleConfig model)
{
using (var context = new DataLayer.DAL.MyDBContext())
{
context.FileReplace_RuleConfig.Add(model);
context.SaveChanges();
}
}
/// <summary>
/// 保存
/// </summary>
private void btnSave_Click(object sender, EventArgs e)
{
int ruleId = XCLNetTools.Common.DataTypeConvert.ToInt(this.txtRuleID.Text.Trim());
DataLayer.Model.FileReplace_RuleConfig model = new DataLayer.Model.FileReplace_RuleConfig();
model.CreateTime = model.UpdateTime = DateTime.Now;
model.IsFileContent = this.ckIsFileContent.Checked;
model.IsFileName = this.ckIsFileName.Checked;
model.IsIgnoreCase = this.ckIsIgnoreCase.Checked;
model.IsRegex = this.ckIsRegex.Checked;
model.IsWholeMatch = this.ckIsWholeMatch.Checked;
model.Name = this.txtRuleName.Text.Trim();
model.NewContent = this.txtNewContent.Text.Trim();
model.OldContent = this.txtOldContent.Text.Trim();
if (string.IsNullOrEmpty(model.Name))
{
DevExpress.XtraEditors.XtraMessageBox.Show("请输入规则名！", "系统提示");
return;
}
if (string.IsNullOrEmpty(model.OldContent))
{
DevExpress.XtraEditors.XtraMessageBox.Show("请输入要查找的内容！", "系统提示");
return;
}
if (ruleId > 0 && bll.IsExist(ruleId))
{
model.RuleConfigID = ruleId;
bll.Update(model);
}
else
{
bll.Add(model);
}
this.InitRuleConfigGrid();
this.tabPageAdd.PageVisible = false;
this.tabRuleConfig.SelectedPage = this.tabPageSelectRule;
}
/// <summary>
/// 保存
/// </summary>
private void btnSave_Click(object sender, EventArgs e)
{
int ruleId = XCLNetTools.StringHander.Common.GetInt(this.txtRuleID.Text.Trim());
DataLayer.Model.FileReplace_RuleConfig model = new DataLayer.Model.FileReplace_RuleConfig();
model.CreateTime = model.UpdateTime = DateTime.Now;
model.IsFileContent = this.ckIsFileContent.Checked;
model.IsFileName = this.ckIsFileName.Checked;
model.IsIgnoreCase = this.ckIsIgnoreCase.Checked;
model.IsRegex = this.ckIsRegex.Checked;
model.IsWholeMatch = this.ckIsWholeMatch.Checked;
model.Name = this.txtRuleName.Text.Trim();
model.NewContent = this.txtNewContent.Text.Trim();
model.OldContent = this.txtOldContent.Text.Trim();
if (string.IsNullOrEmpty(model.Name))
{
MessageBox.Show("请输入规则名！");
return;
}
if (string.IsNullOrEmpty(model.OldContent))
{
MessageBox.Show("请输入要查找的内容！");
return;
}
if (ruleId > 0 && bll.IsExist(ruleId))
{
model.RuleConfigID = ruleId;
bll.Update(model);
}
else
{
bll.Add(model);
}
this.InitRuleConfigGrid();
}
public void Update(DataLayer.Model.FileReplace_RuleConfig model)
{
using (var context = new DataLayer.DAL.MyDBContext())
{
var info = context.FileReplace_RuleConfig.FirstOrDefault(k => k.RuleConfigID == model.RuleConfigID);
if (null == info)
{
return;
}
info.IsFileContent = model.IsFileContent;
info.IsFileName = model.IsFileName;
info.IsIgnoreCase = model.IsIgnoreCase;
info.IsRegex = model.IsRegex;
info.IsWholeMatch = model.IsWholeMatch;
info.Name = model.Name;
info.NewContent = model.NewContent;
info.OldContent = model.OldContent;
info.UpdateTime = DateTime.Now;
context.FileReplace_RuleConfig.Attach(info);
context.Entry(info).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
/// <summary>
/// 导入规则
/// </summary>
private void btnInput_Click(object sender, EventArgs e)
{
OpenFileDialog openFile = new OpenFileDialog();
openFile.Filter = "Excel文件|*.xls;*.xlsx";
if (openFile.ShowDialog() != System.Windows.Forms.DialogResult.OK)
{
return;
}
try
{
var dt = XCLNetTools.Office.ExcelHandler.ExcelToData.ReadExcelToTable(openFile.FileNames[0]);
var nameColIndex = XCLNetTools.DataSource.DataTableHelper.GetColIndex(dt, 1, "名称");
var oldContentColIndex = XCLNetTools.DataSource.DataTableHelper.GetColIndex(dt, 1, "查找内容");
var newContentColIndex = XCLNetTools.DataSource.DataTableHelper.GetColIndex(dt, 1, "替换内容");
var isRegexColIndex = XCLNetTools.DataSource.DataTableHelper.GetColIndex(dt, 1, "是否为正则表达式");
var isIgnoreCaseColIndex = XCLNetTools.DataSource.DataTableHelper.GetColIndex(dt, 1, "是否区分大小写");
var isWholeMatchColIndex = XCLNetTools.DataSource.DataTableHelper.GetColIndex(dt, 1, "是否整字匹配");
var isFileNameColIndex = XCLNetTools.DataSource.DataTableHelper.GetColIndex(dt, 1, "是否匹配文件名");
var isFileContentColIndex = XCLNetTools.DataSource.DataTableHelper.GetColIndex(dt, 1, "是否匹配文件内容");
var createTimeColIndex = XCLNetTools.DataSource.DataTableHelper.GetColIndex(dt, 1, "创建时间");
var updateTimeColIndex = XCLNetTools.DataSource.DataTableHelper.GetColIndex(dt, 1, "更新时间");
if (nameColIndex == -1 || oldContentColIndex == -1 || newContentColIndex == -1 || isRegexColIndex == -1 || isIgnoreCaseColIndex == -1 || isWholeMatchColIndex == -1 || isFileNameColIndex == -1 || isFileContentColIndex == -1 || createTimeColIndex == -1 || updateTimeColIndex == -1)
{
DevExpress.XtraEditors.XtraMessageBox.Show("准备导入的文件模板缺少相关列，请确保模板是正确的（您可以将导出的Excel文件作为模板）！", "系统提示");
return;
}
if (dt.Rows.Count <= 2)
{
DevExpress.XtraEditors.XtraMessageBox.Show("没有任务数据需要导入！", "系统提示");
return;
}
var dtNow = DateTime.Now;
var msg = new List <string>();
var lst = new List <DataLayer.Model.FileReplace_RuleConfig>();
for (var i = 2; i < dt.Rows.Count; i++)
{
var dr = dt.Rows[i];
var model = new DataLayer.Model.FileReplace_RuleConfig();
model.Name = (dr[nameColIndex] ?? "").ToString().Trim();
model.OldContent = dr[oldContentColIndex].ToString();
model.NewContent = dr[newContentColIndex].ToString();
model.IsRegex = dr[isRegexColIndex].ToString() == "是";
model.IsIgnoreCase = dr[isIgnoreCaseColIndex].ToString() == "是";
model.IsWholeMatch = dr[isWholeMatchColIndex].ToString() == "是";
model.IsFileName = dr[isFileNameColIndex].ToString() == "是";
model.IsFileContent = dr[isFileContentColIndex].ToString() == "是";
model.CreateTime = XCLNetTools.Common.DataTypeConvert.ToDateTime(dr[createTimeColIndex].ToString(), dtNow);
model.UpdateTime = XCLNetTools.Common.DataTypeConvert.ToDateTime(dr[updateTimeColIndex].ToString(), dtNow);
if (string.IsNullOrWhiteSpace(model.Name))
{
msg.Add(string.Format("第{0}行中的【名称】必填！", (i + 1).ToString()));
break;
}
if (string.IsNullOrEmpty(model.OldContent))
{
msg.Add(string.Format("第{0}行中的【查找内容】必填！", (i + 1).ToString()));
break;
}
lst.Add(model);
}
if (msg.Count > 0)
{
DevExpress.XtraEditors.XtraMessageBox.Show(string.Join(System.Environment.NewLine, msg.ToArray()), "系统提示");
return;
}
if (lst.Count > 0)
{
this.bll.Add(lst);
this.InitRuleConfigGrid();
DevExpress.XtraEditors.XtraMessageBox.Show(string.Format("您已成功导入{0}条规则！", lst.Count.ToString()), "系统提示");
return;
}
}
catch
{
DevExpress.XtraEditors.XtraMessageBox.Show("系统错误，请重新选择有效的文件！", "系统提示");
}
}