/// <summary>
/// 获取参数
/// </summary>
/// <param name="allinone_areainfo"></param>
/// <returns></returns>
public Dictionary <string, string> GetParameters(AllInOne_AreaInfo allinone_areainfo)
{
Dictionary <string, string> dict = new Dictionary <string, string>();
if (allinone_areainfo.id != null)
{
dict.Add("@id", allinone_areainfo.id.ToString());
}
if (allinone_areainfo.name != null)
{
dict.Add("@name", allinone_areainfo.name.ToString());
}
if (allinone_areainfo.isDeleted != null)
{
dict.Add("@isDeleted", allinone_areainfo.isDeleted.ToString());
}
if (allinone_areainfo.lat != null)
{
dict.Add("@lat", allinone_areainfo.lat.ToString());
}
if (allinone_areainfo.lng != null)
{
dict.Add("@lng", allinone_areainfo.lng.ToString());
}
if (allinone_areainfo.mapAddress != null)
{
dict.Add("@mapAddress", allinone_areainfo.mapAddress.ToString());
}
if (allinone_areainfo.createUserId != null)
{
dict.Add("@createUserId", allinone_areainfo.createUserId.ToString());
}
return(dict);
}
/// <summary>
/// add
/// </summary>
/// <param name="AllInOne_AreaInfo"></param>
/// <returns></returns>
public int Add(AllInOne_AreaInfo model, SqlConnection connection = null, SqlTransaction transaction = null)
{
var str = GetInsertStr(model) + " select @@identity";
var dict = GetParameters(model);
return(Convert.ToInt32(SqlHelper.Instance.ExecuteScalar(str, dict, connection, transaction)));
}
/// <summary>
/// update
/// </summary>
/// <param name="AllInOne_AreaInfo"></param>
/// <returns></returns>
public void Update(AllInOne_AreaInfo model, SqlConnection connection = null, SqlTransaction transaction = null)
{
var str = GetUpdateStr(model);
var dict = GetParameters(model);
SqlHelper.Instance.ExcuteNon(str, dict, connection, transaction);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="allinone_areainfo"></param>
/// <returns>是否成功</returns>
public string GetUpdateStr(AllInOne_AreaInfo allinone_areainfo)
{
StringBuilder part1 = new StringBuilder();
part1.Append("update allinone_areainfo set ");
if (allinone_areainfo.name != null)
{
part1.Append("name = @name,");
}
if (allinone_areainfo.isDeleted != null)
{
part1.Append("isDeleted = @isDeleted,");
}
if (allinone_areainfo.lat != null)
{
part1.Append("lat = @lat,");
}
if (allinone_areainfo.lng != null)
{
part1.Append("lng = @lng,");
}
if (allinone_areainfo.mapAddress != null)
{
part1.Append("mapAddress = @mapAddress,");
}
if (allinone_areainfo.createUserId != null)
{
part1.Append("createUserId = @createUserId,");
}
int n = part1.ToString().LastIndexOf(",");
part1.Remove(n, 1);
part1.Append(" where id= @id ");
return(part1.ToString());
}
/// <summary>
/// 插入
/// </summary>
/// <param name="allinone_areainfo"></param>
/// <returns>是否成功</returns>
public string GetInsertStr(AllInOne_AreaInfo allinone_areainfo)
{
StringBuilder part1 = new StringBuilder();
StringBuilder part2 = new StringBuilder();
if (allinone_areainfo.name != null)
{
part1.Append("name,");
part2.Append("@name,");
}
if (allinone_areainfo.isDeleted != null)
{
part1.Append("isDeleted,");
part2.Append("@isDeleted,");
}
if (allinone_areainfo.lat != null)
{
part1.Append("lat,");
part2.Append("@lat,");
}
if (allinone_areainfo.lng != null)
{
part1.Append("lng,");
part2.Append("@lng,");
}
if (allinone_areainfo.mapAddress != null)
{
part1.Append("mapAddress,");
part2.Append("@mapAddress,");
}
if (allinone_areainfo.createUserId != null)
{
part1.Append("createUserId,");
part2.Append("@createUserId,");
}
StringBuilder sql = new StringBuilder();
sql.Append("insert into allinone_areainfo(").Append(part1.ToString().Remove(part1.Length - 1)).Append(") values (").Append(part2.ToString().Remove(part2.Length - 1)).Append(")");
return(sql.ToString());
}
