public DbHelperSql GetDbHelperSql(EnumDbName dbName)
{
var val = _ht[dbName];
if (val == null)
{
lock (LockObject)
{
val = _ht[dbName];
if (val == null)
{
var name = dbName.ToString("G");
var readerConn = ConncetionReader(name);
var writerConn = GetConncetionWriter(name);
val = new DbHelperSql(readerConn,writerConn);
_ht[dbName] = val;
}
}
}
return (DbHelperSql)val;
}
/// <summary>
/// 分页获取数据列表
/// </summary>
public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM ( ");
strSql.Append(" SELECT ROW_NUMBER() OVER (");
if (!string.IsNullOrEmpty(orderby.Trim()))
{
strSql.Append("order by T." + orderby);
}
else
{
strSql.Append("order by T.ID desc");
}
strSql.Append(")AS Row, T.* from SystemRole T ");
if (!string.IsNullOrEmpty(strWhere.Trim()))
{
strSql.Append(" WHERE " + strWhere);
}
strSql.Append(" ) TT");
strSql.AppendFormat(" WHERE TT.Row between {0} and {1}", startIndex, endIndex);
return(DbHelperSql.Query(strSql.ToString()));
}
public IEnumerable <Movie> ToList()
{
using (var conn = new SqlConnection(_ConnectionString))
{
conn.Open();
var helper = new DbHelperSql(conn);
string sql = @"
select ID, Genre, Price, ReleaseDate, Title
from Movie
";
var dt = helper.ExecDataTableSql(sql);
var list = dt.AsEnumerable().Select(dr => new Movie()
{
Id = (int)dr["ID"],
Genre = (string)dr["Genre"],
Price = (decimal)dr["Price"],
ReleaseDate = (DateTime)dr["ReleaseDate"],
Title = (string)dr["Title"],
});
return(list);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(Guid LeavemessageUUID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from Leavemessage ");
strSql.Append(" where LeavemessageUUID=@LeavemessageUUID ");
SqlParameter[] parameters =
{
new SqlParameter("@LeavemessageUUID", SqlDbType.UniqueIdentifier, 16)
};
parameters[0].Value = LeavemessageUUID;
int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from SystemRole ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from Teacher ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(Guid BuildingUuid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from xf_Building ");
strSql.Append(" where BuildingUuid=@BuildingUuid ");
SqlParameter[] parameters =
{
new SqlParameter("@BuildingUuid", SqlDbType.UniqueIdentifier, 16)
};
parameters[0].Value = BuildingUuid;
int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(HeqiaoDaoshiCore.Model.ActiveQuantity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ActiveQuantity set ");
strSql.Append("CreateTime=@CreateTime,");
strSql.Append("AddTime=@AddTime,");
strSql.Append("Num=@Num,");
strSql.Append("Type=@Type");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@AddTime", SqlDbType.NVarChar, 50),
new SqlParameter("@Num", SqlDbType.Int, 4),
new SqlParameter("@Type", SqlDbType.Int, 4),
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@ActiveQuantityUUID", SqlDbType.UniqueIdentifier, 16)
};
parameters[0].Value = model.CreateTime;
parameters[1].Value = model.AddTime;
parameters[2].Value = model.Num;
parameters[3].Value = model.Type;
parameters[4].Value = model.ID;
parameters[5].Value = model.ActiveQuantityUUID;
int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
//
public bool UpdateById(Person model, Int32 id)
{
model.Id = id;
StringBuilder strSql = new StringBuilder();
strSql.Append("update [Person] set ");
if (model.@Username != null)
{
strSql.Append("username=@Username,");
}
if (model.@Password != null)
{
strSql.Append("password=@Password,");
}
if (model.@Age != null)
{
strSql.Append("age=@Age,");
}
if (model.@RegisterDate != null)
{
strSql.Append("registerDate=@RegisterDate,");
}
if (model.@Address != null)
{
strSql.Append("address=@Address,");
}
int n = strSql.ToString().LastIndexOf(",", StringComparison.Ordinal);
if (n > 0)
{
strSql.Remove(n, 1);
}
strSql.Append(" where id=@id ");
var flag = DbHelperSql.Update(strSql.ToString(), model);
return(flag);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(HeqiaoDaoshiCore.Model.Leavemessage model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Leavemessage set ");
strSql.Append("UserUUID=@UserUUID,");
strSql.Append("Content=@Content,");
strSql.Append("Createtime=@Createtime,");
strSql.Append("Isdelete=@Isdelete");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@UserUUID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@Content", SqlDbType.NVarChar, 255),
new SqlParameter("@Createtime", SqlDbType.NVarChar, 255),
new SqlParameter("@Isdelete", SqlDbType.VarChar, 255),
new SqlParameter("@LeavemessageUUID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.UserUUID;
parameters[1].Value = model.Content;
parameters[2].Value = model.Createtime;
parameters[3].Value = model.Isdelete;
parameters[4].Value = model.LeavemessageUUID;
parameters[5].Value = model.ID;
int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(HeqiaoDaoshiCore.Model.Mark model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Mark set ");
strSql.Append("CreateTime=@CreateTime,");
strSql.Append("MarkName=@MarkName,");
strSql.Append("MarkPicture=@MarkPicture,");
strSql.Append("IsDelete=@IsDelete");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@MarkName", SqlDbType.NVarChar, 50),
new SqlParameter("@MarkPicture", SqlDbType.NVarChar, 100),
new SqlParameter("@IsDelete", SqlDbType.Int, 4),
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@MarkUUID", SqlDbType.UniqueIdentifier, 16)
};
parameters[0].Value = model.CreateTime;
parameters[1].Value = model.MarkName;
parameters[2].Value = model.MarkPicture;
parameters[3].Value = model.IsDelete;
parameters[4].Value = model.ID;
parameters[5].Value = model.MarkUUID;
int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ClassLibrary1.Model.TcqType GetModel(Guid Tcqguid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Tcqguid,Tcqid,TcqName from TcqType ");
strSql.Append(" where Tcqguid=@Tcqguid ");
SqlParameter[] parameters =
{
new SqlParameter("@Tcqguid", SqlDbType.UniqueIdentifier, 16)
};
parameters[0].Value = Tcqguid;
ClassLibrary1.Model.TcqType model = new ClassLibrary1.Model.TcqType();
DataSet ds = DbHelperSql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public HeqiaoDaoshiCore.Model.Information GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,CreateTime,InformationUUID,Title,InformationTypeUUID,Introduce,Address,StartTime,Picture,State,IsDeleted,Photo from Information ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
HeqiaoDaoshiCore.Model.Information model = new HeqiaoDaoshiCore.Model.Information();
DataSet ds = DbHelperSql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(HeqiaoDaoshiCore.Model.News model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into News(");
strSql.Append("CreateTime,NewsUUID,Title,NewsContent,IsDelete,ReleaseState)");
strSql.Append(" values (");
strSql.Append("@CreateTime,@NewsUUID,@Title,@NewsContent,@IsDelete,@ReleaseState)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@NewsUUID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@Title", SqlDbType.NVarChar, 50),
new SqlParameter("@NewsContent", SqlDbType.NVarChar, -1),
new SqlParameter("@IsDelete", SqlDbType.Int, 4),
new SqlParameter("@ReleaseState", SqlDbType.Int, 4)
};
parameters[0].Value = model.CreateTime;
parameters[1].Value = Guid.NewGuid();
parameters[2].Value = model.Title;
parameters[3].Value = model.NewsContent;
parameters[4].Value = model.IsDelete;
parameters[5].Value = model.ReleaseState;
object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public big_data.Model.Userinfoty GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 UserInfoUUID,ID,IsDeleted,AddTime,AddPeople,RealName,UserIdCard,Wechat,Phone,Email,Sex,Address,DepartmentUUID,Birth,IdentityCard,Residence,Domicile,Nation,Education,QianYiSTime,QianYiETime,Settled,Occupation,DyStaues,Politics,position,Evaluate,OrganizationUuid,JoinArmy,ArmyTime,SettledTime,TownUuid,Defense,Category,Partybranch,JoinDate,Work,Age,Household,Relation,HouseholderName from Userinfoty ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
big_data.Model.Userinfoty model = new big_data.Model.Userinfoty();
DataSet ds = DbHelperSql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ClassLibrary1.Model.Teacher GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,CreateTime,TeacherUuid,Name,Sex,Gh,DepartmentUuid,YiCard,DormitoryUuid,Picture,DormitoryNumUuid,Phone,IdCard,Email,Nation,Political,Religion,IsDeleted,AddTime,AddPeople,SchoolDistrictUuid,ProfessionalTitle from Teacher ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
ClassLibrary1.Model.Teacher model = new ClassLibrary1.Model.Teacher();
DataSet ds = DbHelperSql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ClassLibrary1.Model.YiCardLSXX GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,YicardUuid,YicardName,Possessor,ConsumType,ExpenseCal,Balance,IsDeleted,AddTime,AddPeople,ConsumTime,Address,SiteName,DepName from YiCardLSXX ");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
ClassLibrary1.Model.YiCardLSXX model = new ClassLibrary1.Model.YiCardLSXX();
DataSet ds = DbHelperSql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public HeqiaoDaoshiCore.Model.Mapmark GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,CreateTime,MapmarkUUID,MarkUUID,Position,IsDelete,Introduce from Mapmark ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
HeqiaoDaoshiCore.Model.Mapmark model = new HeqiaoDaoshiCore.Model.Mapmark();
DataSet ds = DbHelperSql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ClassLibrary1.Model.Department GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,CreateTime,DepartmentUuid,DepartmentName,ResPeople,Phone,IsDeleted,AddTime,AddPeople from Department ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
ClassLibrary1.Model.Department model = new ClassLibrary1.Model.Department();
DataSet ds = DbHelperSql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Haikan.SchoolProjectsCore.MDB.Model.HFile model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into HFile(");
strSql.Append("EnterpriseName,EnterpriseFile,ContractFile,InvoiceFile,ProjectFile,IsDele)");
strSql.Append(" values (");
strSql.Append("@EnterpriseName,@EnterpriseFile,@ContractFile,@InvoiceFile,@ProjectFile,@IsDele)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@EnterpriseName", SqlDbType.VarChar, 255),
new SqlParameter("@EnterpriseFile", SqlDbType.VarChar, 255),
new SqlParameter("@ContractFile", SqlDbType.VarChar, 255),
new SqlParameter("@InvoiceFile", SqlDbType.VarChar, 255),
new SqlParameter("@ProjectFile", SqlDbType.VarChar, 255),
new SqlParameter("@IsDele", SqlDbType.VarChar, 255)
};
parameters[0].Value = model.EnterpriseName;
parameters[1].Value = model.EnterpriseFile;
parameters[2].Value = model.ContractFile;
parameters[3].Value = model.InvoiceFile;
parameters[4].Value = model.ProjectFile;
parameters[5].Value = model.IsDele;
object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public big_data.Model.UnifiedAddressLibrary GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 UnifiedAddressLibraryUUID,ID,oid,SOURCEADDRESS,CITY,COUNTY,TOWN,COMMUNITY,SQUAD,VILLAGE,SZONE,STREET,DOOR,RESREGION,BUILDING,BUILDING_NUM,UNIT,FLOOR,ROOM,GRID_CODE,BUILDING_CODE,HOUSE_CODE,CODE,CREATETIME,UPDATETIME,ISVALID,FROM_STATUS,TO_STATUS,BUILDING_PATH,DATASOURCE,REVERSE1,REVERSE2,LON,LAT,Z,ROOM_FLOOR,ADDRTYPE,GUID,INSERTTIME,SYSTEMID,ISDELETE,BELONG_BUILDING,ADDRESS_TYPE,REMARK,AddTime from UnifiedAddressLibrary ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
big_data.Model.UnifiedAddressLibrary model = new big_data.Model.UnifiedAddressLibrary();
DataSet ds = DbHelperSql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Haikan.SchoolProjectsCore.MDB.Model.HFile GetModel(int FileID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 FileID,EnterpriseName,EnterpriseFile,ContractFile,InvoiceFile,ProjectFile,IsDele from HFile ");
strSql.Append(" where FileID=@FileID");
SqlParameter[] parameters =
{
new SqlParameter("@FileID", SqlDbType.Int, 4)
};
parameters[0].Value = FileID;
Haikan.SchoolProjectsCore.MDB.Model.HFile model = new Haikan.SchoolProjectsCore.MDB.Model.HFile();
DataSet ds = DbHelperSql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public HeqiaoDaoshiCore.Model.Food GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,CreateTime,FoodUUID,FoodName,Title,Introduction,Address,Price,Picture,State,IsDelete,FoodorTechan,Cover,Lon,Lat,ytype,PlayType,ShopId from Food ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
HeqiaoDaoshiCore.Model.Food model = new HeqiaoDaoshiCore.Model.Food();
DataSet ds = DbHelperSql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public big_data.Model.UnifiedAddressLibraryUserInfo GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,UnifiedAddressLibraryID,UserIDList,AddTime from UnifiedAddressLibraryUserInfo ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
big_data.Model.UnifiedAddressLibraryUserInfo model = new big_data.Model.UnifiedAddressLibraryUserInfo();
DataSet ds = DbHelperSql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public HeqiaoDaoshiCore.Model.CulturalIntroduc GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 CulturalIntroducUUID,Title,ReleaseTime,IsRelease,Cover,Content,AddTime,AddPeople,ID,IsDeleted,Photo from CulturalIntroduc ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
HeqiaoDaoshiCore.Model.CulturalIntroduc model = new HeqiaoDaoshiCore.Model.CulturalIntroduc();
DataSet ds = DbHelperSql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(HeqiaoDaoshiCore.Model.Mapmark model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Mapmark(");
strSql.Append("CreateTime,MapmarkUUID,MarkUUID,Position,IsDelete,Introduce)");
strSql.Append(" values (");
strSql.Append("@CreateTime,@MapmarkUUID,@MarkUUID,@Position,@IsDelete,@Introduce)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@MapmarkUUID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@MarkUUID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@Position", SqlDbType.NVarChar, 50),
new SqlParameter("@IsDelete", SqlDbType.Int, 4),
new SqlParameter("@Introduce", SqlDbType.NVarChar, 255)
};
parameters[0].Value = model.CreateTime;
parameters[1].Value = Guid.NewGuid();
parameters[2].Value = Guid.NewGuid();
parameters[3].Value = model.Position;
parameters[4].Value = model.IsDelete;
parameters[5].Value = model.Introduce;
object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public HeqiaoDaoshiCore.Model.Hotel GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,CreateTime,HotelUUID,Name,Phone,Introduction,Address,Price,Picture,State,IsDelete,AddTime,AddPeople,Cover,HotelUrl,Lon,Lat,ShopId from Hotel ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
HeqiaoDaoshiCore.Model.Hotel model = new HeqiaoDaoshiCore.Model.Hotel();
DataSet ds = DbHelperSql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public HeqiaoDaoshiCore.Model.Gtoilet GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 GtoiletUuid,ID,IsDeleted,GtoiletName,GtoiletAddress,Lon,Lat,GtoiletStaues,KongqiZhil,WaterYujin,AddTime,AddPeople,Picture from Gtoilet ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
HeqiaoDaoshiCore.Model.Gtoilet model = new HeqiaoDaoshiCore.Model.Gtoilet();
DataSet ds = DbHelperSql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public HeqiaoDaoshiCore.Model.SystemIcon GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 SystemIconUUID,Code,Size,Color,Custom,Description,Status,IsDeleted,CreatedOn,CreatedByUserGuid,CreatedByUserName,ModifiedOn,ModifiedByUserGuid,ModifiedByUserName,ID from SystemIcon ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
HeqiaoDaoshiCore.Model.SystemIcon model = new HeqiaoDaoshiCore.Model.SystemIcon();
DataSet ds = DbHelperSql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public HeqiaoDaoshiCore.Model.HotelRoom GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,HotelRoomUuid,HotelRoomName,Price,Introduction,Address,Picture,State,IsDelete,HotelUuid from HotelRoom ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
HeqiaoDaoshiCore.Model.HotelRoom model = new HeqiaoDaoshiCore.Model.HotelRoom();
DataSet ds = DbHelperSql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ClassLibrary1.Model.SystemUser GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 SystemUserUUID,LoginName,RealName,UserIdCard,PassWord,UserType,SchoolUUID,AddTime,AddPeople,IsDeleted,ManageDepartment,ID,ZaiGang,Phone,Email,Sex,InTime,Types,Address,SystemRoleUUid,Remarks,StaffNum,Wechat,Topic,Content,Train,Main,Job,HealthCertificate,IsStaff,IsCreEdu,PersonnelType,ReviewStatus,CardNumber,IsBlacklist from SystemUser ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
ClassLibrary1.Model.SystemUser model = new ClassLibrary1.Model.SystemUser();
DataSet ds = DbHelperSql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public PersonDao()
{
_dbHelper = SqlMapper.Instance.GetDbHelperSql(EnumDbName.Test1);
}
public UrlInfoDao()
{
_dbHelper = SqlMapper.Instance.GetDbHelperSql(EnumDbName.Test1);
}