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;
}