private void BtnAddNewRecord_Click(object sender, EventArgs e) { string urlTemplate = txtUrlTemplate.Text.Trim(); string fieldAndTables = txtTables.Text.Trim(); if (urlTemplate._IsNullOrEmpty() || fieldAndTables._IsNullOrEmpty()) { MessageBox.Show("url模板或表和字段为空!"); return; } Record record = new Record(); record.TemplateUrl = urlTemplate; record.FieldsAndTables = fieldAndTables; int docId = DataProccess.Add(record); if (docId > 0) { MessageBox.Show("添加成功!"); } else { MessageBox.Show("添加失败!"); } }
private string FromSql(Record record) { StringBuilder sbsql = new StringBuilder(); if (!record.FieldsAndTables._IsNullOrEmpty()) { string[] sqlArray = record.FieldsAndTables.Split(new string[] { "|" }, StringSplitOptions.RemoveEmptyEntries); if (sqlArray.Length > 0) { foreach (var item in sqlArray) { string[] sqlItem = item.Split('-'); if (sqlItem.Length == 2) { sbsql.AppendLine(SqlContact(sqlItem[0], sqlItem[1])); } else if (sqlItem.Length == 3) { sbsql.AppendLine(SqlContact(sqlItem[0], sqlItem[1], sqlItem[2])); } } } } return sbsql.ToStr(); }
public static int Add(Record model) { return LiteDBOP.Save<Record>(model); }
private IList<Record> DealString(string strText) { IList<Record> recordList = null; if (!strText._IsNullOrEmpty()) { string[] _recordList = strText.Split(new string[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries); if (_recordList != null && _recordList.Count() > 0) { recordList = new List<Record>(); foreach (var item in _recordList) { string[] itemArray = item.Split(new string[] { "--" }, StringSplitOptions.RemoveEmptyEntries); if (itemArray.Length == 2) { Record record = new Record(); record.TemplateUrl = itemArray[0]; record.FieldsAndTables = itemArray[1]; recordList.Add(record); } } } } return recordList; }