/// <summary>
/// 生成DeleteSQL
/// </summary>
private static string GetDeleteSql(ICTransType tranInfo, string fTableName)
{
var tableInfo = tranInfo.Tables.Find(x => x.FTableName == fTableName);
string sql = "";
if (!tableInfo.bSlave)
{
tranInfo.Tables.ForEach(x =>
{
sql += ";delete from " + x.FTableName + " where " + tableInfo.FPKName + " = @" + tableInfo.FPKName;
});
}
else
{
sql = "delete from " + tableInfo.FTableName + " where " + tableInfo.FPKName + " = @" + tableInfo.FPKName;
}
return(sql);
}
public void Add(ICTransType model)
{
string sqlM = SQLBuilder.GetInsertSql("ICTransType");
string sqlD = SQLBuilder.GetInsertSql("ICTableInfo");
var tran = DbHelperSQL.GetTransaction();
try
{
tran.Connection.Execute(sqlM, model, tran);
tran.Connection.Execute(sqlD, model.Tables, tran);
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
}
