/// <summary>
/// 新增数据
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Insert <T>(T entity, out string result)
{
result = "0";
int idenId = 0;
var conn = OpenConnection();
try
{
string sql = ModelPropUtils.ModelToInsertSql(entity, out result);
if (!result.Equals("0"))
{
result = "=>" + sql;
return(0);
}
//conn.Open();
sql += "SELECT @@identity;";
idenId = conn.ExecuteScalar <int>(sql, entity);
//result = res.ToString();
conn.Close();
}
catch (Exception ex)
{
result = $"ex=>{ex.ToString()}";
}
finally
{
if (conn.State == System.Data.ConnectionState.Open)
{
conn.Close();
}
}
return(idenId);
}
/// <summary>
/// 新增数据(成功返回0)
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public string Insert <T>(T entity)
{
string result = "";
var conn = OpenConnection();
try
{
string sql = ModelPropUtils.ModelToInsertSql(entity, out result);
if (!result.Equals("0"))
{
return(result);
}
//conn.Open();
var res = conn.Execute(sql, entity);
result = "0";// res.ToString();
conn.Close();
}
catch (Exception ex)
{
result = $"ex=>{ex.ToString()}";
}
finally
{
if (conn.State == System.Data.ConnectionState.Open)
{
conn.Close();
}
}
return(result);
}