public bool UpdateAsync(AboutInstart model)
{
using (var conn = DapperFactory.GetConnection())
{
var fields = model.ToFields(removeFields: new List <string>
{
"PassLearning",
"CreateTime"
});
if (fields == null || fields.Count == 0)
{
return(false);
}
var fieldList = new List <string>();
foreach (var field in fields)
{
fieldList.Add(string.Format("{0}=@{0}", field));
}
model.ModifyTime = DateTime.Now;
string sql = string.Format("update [AboutInstart] set {0};", string.Join(",", fieldList));
return(conn.Execute(sql, model) > 0);
}
}
public bool InsertAsync(AboutInstart model)
{
using (var conn = DapperFactory.GetConnection())
{
var fields = model.ToFields();
if (fields == null || fields.Count == 0)
{
return(false);
}
model.CreateTime = DateTime.Now;
model.ModifyTime = DateTime.Now;
string sql = string.Format("insert into [AboutInstart] ({0}) values ({1});", string.Join(",", fields), string.Join(",", fields.Select(n => "@" + n)));
return(conn.Execute(sql, model) > 0);
}
}