/// <summary>
/// 增加一条数据
/// </summary>
public int Add(HeqiaoDaoshiCore.Model.SystemUserRoleMapping model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SystemUserRoleMapping(");
strSql.Append("SystemUserUUID,SystemRoleUUID,AddTime,AddPeople)");
strSql.Append(" values (");
strSql.Append("@SystemUserUUID,@SystemRoleUUID,@AddTime,@AddPeople)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@SystemUserUUID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@SystemRoleUUID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@AddTime", SqlDbType.NVarChar, 255),
new SqlParameter("@AddPeople", SqlDbType.NVarChar, 255)
};
parameters[0].Value = Guid.NewGuid();
parameters[1].Value = Guid.NewGuid();
parameters[2].Value = model.AddTime;
parameters[3].Value = model.AddPeople;
object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(HeqiaoDaoshiCore.Model.Mark model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Mark(");
strSql.Append("CreateTime,MarkUUID,MarkName,MarkPicture,IsDelete)");
strSql.Append(" values (");
strSql.Append("@CreateTime,@MarkUUID,@MarkName,@MarkPicture,@IsDelete)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@MarkUUID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@MarkName", SqlDbType.NVarChar, 50),
new SqlParameter("@MarkPicture", SqlDbType.NVarChar, 100),
new SqlParameter("@IsDelete", SqlDbType.Int, 4)
};
parameters[0].Value = model.CreateTime;
parameters[1].Value = Guid.NewGuid();
parameters[2].Value = model.MarkName;
parameters[3].Value = model.MarkPicture;
parameters[4].Value = model.IsDelete;
object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(HeqiaoDaoshiCore.Model.PublicityType model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into PublicityType(");
strSql.Append("CreateTime,PublicityTypeUUID,Name,IsDeleted)");
strSql.Append(" values (");
strSql.Append("@CreateTime,@PublicityTypeUUID,@Name,@IsDeleted)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@CreateTime", SqlDbType.DateTime2, 8),
new SqlParameter("@PublicityTypeUUID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@Name", SqlDbType.VarChar, 255),
new SqlParameter("@IsDeleted", SqlDbType.Int, 4)
};
parameters[0].Value = model.CreateTime;
parameters[1].Value = Guid.NewGuid();
parameters[2].Value = model.Name;
parameters[3].Value = model.IsDeleted;
object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
public int Add(String userID, String roleID)
{
var strSql = new StringBuilder();
strSql.Append("INSERT INTO tbLOG_Role_User(");
strSql.Append("User_ID,Role_ID)");
strSql.Append(" SELECT @User_ID,B.ID FROM (");
strSql.Append(" SELECT CONVERT(XML, '<v>' + REPLACE(@Role_ID, ',', '</v><v>')+ '</v>') AS ID) A OUTER APPLY (");
strSql.Append(" SELECT ID = N.v.value('.', 'VARCHAR(1000)') FROM A.ID.nodes('/v') N ( v )) B ");
strSql.Append("LEFT JOIN dbo.tbLOG_Role_User RU ON RU.Role_ID = B.ID AND RU.User_ID = @User_ID WHERE RU.Role_ID IS NULL ");
strSql.Append("SELECT SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@User_ID", SqlDbType.VarChar, 50),
new SqlParameter("@Role_ID", SqlDbType.NVarChar, 1000)
};
parameters[0].Value = userID.ToUpper();
parameters[1].Value = roleID;
var obj = DbHelperSql.GetSingle(DbHelperSql.DefaultUpdateConn, strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Haikan.LabSystemCore.Model.CreditCardBehavior model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CreditCardBehavior(");
strSql.Append("CardNo,DeviceID,AddTime,ProjectID)");
strSql.Append(" values (");
strSql.Append("@CardNo,@DeviceID,@AddTime,@ProjectID)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@CardNo", SqlDbType.VarChar, 255),
new SqlParameter("@DeviceID", SqlDbType.VarChar, 255),
new SqlParameter("@AddTime", SqlDbType.VarChar, 255),
new SqlParameter("@ProjectID", SqlDbType.Int, 4)
};
parameters[0].Value = model.CardNo;
parameters[1].Value = model.DeviceID;
parameters[2].Value = model.AddTime;
parameters[3].Value = model.ProjectID;
object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Haikan.SchoolProjectsCore.MDB.Model.Employee model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Employee(");
strSql.Append("ProjectName,EnterpriseName,EmployeeName,EmployeeTime,Note)");
strSql.Append(" values (");
strSql.Append("@ProjectName,@EnterpriseName,@EmployeeName,@EmployeeTime,@Note)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ProjectName", SqlDbType.VarChar, 255),
new SqlParameter("@EnterpriseName", SqlDbType.VarChar, 255),
new SqlParameter("@EmployeeName", SqlDbType.VarChar, 255),
new SqlParameter("@EmployeeTime", SqlDbType.VarChar, 255),
new SqlParameter("@Note", SqlDbType.VarChar, 255)
};
parameters[0].Value = model.ProjectName;
parameters[1].Value = model.EnterpriseName;
parameters[2].Value = model.EmployeeName;
parameters[3].Value = model.EmployeeTime;
parameters[4].Value = model.Note;
object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(HeqiaoDaoshiCore.Model.Treasurerecord model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Treasurerecord(");
strSql.Append("TreasurerecordUUID,UserUUID,Content,Createtime)");
strSql.Append(" values (");
strSql.Append("@TreasurerecordUUID,@UserUUID,@Content,@Createtime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@TreasurerecordUUID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@UserUUID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@Content", SqlDbType.NVarChar, 255),
new SqlParameter("@Createtime", SqlDbType.NVarChar, 255)
};
parameters[0].Value = Guid.NewGuid();
parameters[1].Value = Guid.NewGuid();
parameters[2].Value = model.Content;
parameters[3].Value = model.Createtime;
object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Haikan.SchoolProjectsCore.MDB.Model.Eenterprises model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Eenterprises(");
strSql.Append("EnterpriseName,Contact,EInformation,Note,Audit)");
strSql.Append(" values (");
strSql.Append("@EnterpriseName,@Contact,@EInformation,@Note,@Audit)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@EnterpriseName", SqlDbType.VarChar, 255),
new SqlParameter("@Contact", SqlDbType.VarChar, 255),
new SqlParameter("@EInformation", SqlDbType.VarChar, 255),
new SqlParameter("@Note", SqlDbType.VarChar, 255),
new SqlParameter("@Audit", SqlDbType.VarChar, 255)
};
parameters[0].Value = model.EnterpriseName;
parameters[1].Value = model.Contact;
parameters[2].Value = model.EInformation;
parameters[3].Value = model.Note;
parameters[4].Value = model.Audit;
object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(big_data.Model.UnifiedAddressLibraryUserInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into UnifiedAddressLibraryUserInfo(");
strSql.Append("UnifiedAddressLibraryID,UserIDList,AddTime)");
strSql.Append(" values (");
strSql.Append("@UnifiedAddressLibraryID,@UserIDList,@AddTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@UnifiedAddressLibraryID", SqlDbType.Int, 4),
new SqlParameter("@UserIDList", SqlDbType.NVarChar, -1),
new SqlParameter("@AddTime", SqlDbType.DateTime2, 8)
};
parameters[0].Value = model.UnifiedAddressLibraryID;
parameters[1].Value = model.UserIDList;
parameters[2].Value = model.AddTime;
object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
public int Add(int programID, String buttonID, String Url)
{
var strSql = new StringBuilder();
strSql.Append("INSERT INTO tbLOG_Program_Button(");
strSql.Append("Program_ID,Button_ID,Url)");
strSql.Append(" SELECT @Program_ID,B.ID,@Url FROM (");
strSql.Append(" SELECT CONVERT(XML, '<v>' + REPLACE(@Button_ID, ',', '</v><v>')+ '</v>') AS ID) A OUTER APPLY (");
strSql.Append(" SELECT ID = N.v.value('.', 'VARCHAR(1000)') FROM A.ID.nodes('/v') N ( v )) B ");
strSql.Append("LEFT JOIN dbo.tbLOG_Program_Button PB ON PB.Button_ID = B.ID AND PB.Program_ID = @Program_ID WHERE PB.Button_ID IS NULL ");
strSql.Append("SELECT SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@Program_ID", SqlDbType.Int, 4),
new SqlParameter("@Button_ID", SqlDbType.VarChar, 200),
new SqlParameter("@Url", SqlDbType.VarChar, 100)
};
parameters[0].Value = programID;
parameters[1].Value = buttonID;
parameters[2].Value = Url;
var obj = DbHelperSql.GetSingle(DbHelperSql.DefaultUpdateConn, strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(HeqiaoDaoshiCore.Model.ActiveQuantity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ActiveQuantity(");
strSql.Append("CreateTime,ActiveQuantityUUID,AddTime,Num,Type)");
strSql.Append(" values (");
strSql.Append("@CreateTime,@ActiveQuantityUUID,@AddTime,@Num,@Type)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@ActiveQuantityUUID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@AddTime", SqlDbType.NVarChar, 50),
new SqlParameter("@Num", SqlDbType.Int, 4),
new SqlParameter("@Type", SqlDbType.Int, 4)
};
parameters[0].Value = model.CreateTime;
parameters[1].Value = Guid.NewGuid();
parameters[2].Value = model.AddTime;
parameters[3].Value = model.Num;
parameters[4].Value = model.Type;
object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(big_data.Model.RegionInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into RegionInfo(");
strSql.Append("RegionID,RegionX,RegionY,AddTime)");
strSql.Append(" values (");
strSql.Append("@RegionID,@RegionX,@RegionY,@AddTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@RegionID", SqlDbType.Int, 4),
new SqlParameter("@RegionX", SqlDbType.VarChar, 255),
new SqlParameter("@RegionY", SqlDbType.VarChar, 255),
new SqlParameter("@AddTime", SqlDbType.DateTime2, 8)
};
parameters[0].Value = model.RegionID;
parameters[1].Value = model.RegionX;
parameters[2].Value = model.RegionY;
parameters[3].Value = model.AddTime;
object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
public virtual int Insert(T entity)
{
var type = typeof(T);
var sql = type.GengerateInertSqlString();
var obj = DbHelperSql.GetSingle(sql, AdoUtil.GetParameters(entity));
return(obj == null ? 0 : Convert.ToInt32(obj));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(HeqiaoDaoshiCore.Model.Food model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Food(");
strSql.Append("CreateTime,FoodUUID,FoodName,Title,Introduction,Address,Price,Picture,State,IsDelete,FoodorTechan,Cover,Lon,Lat,ytype,PlayType,ShopId)");
strSql.Append(" values (");
strSql.Append("@CreateTime,@FoodUUID,@FoodName,@Title,@Introduction,@Address,@Price,@Picture,@State,@IsDelete,@FoodorTechan,@Cover,@Lon,@Lat,@ytype,@PlayType,@ShopId)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@FoodUUID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@FoodName", SqlDbType.NVarChar, 255),
new SqlParameter("@Title", SqlDbType.NVarChar, -1),
new SqlParameter("@Introduction", SqlDbType.NVarChar, -1),
new SqlParameter("@Address", SqlDbType.NVarChar, -1),
new SqlParameter("@Price", SqlDbType.NVarChar, 20),
new SqlParameter("@Picture", SqlDbType.NVarChar, -1),
new SqlParameter("@State", SqlDbType.Int, 4),
new SqlParameter("@IsDelete", SqlDbType.Int, 4),
new SqlParameter("@FoodorTechan", SqlDbType.Int, 4),
new SqlParameter("@Cover", SqlDbType.VarChar, 255),
new SqlParameter("@Lon", SqlDbType.NVarChar, 255),
new SqlParameter("@Lat", SqlDbType.NVarChar, 255),
new SqlParameter("@ytype", SqlDbType.NVarChar, 255),
new SqlParameter("@PlayType", SqlDbType.NVarChar, 255),
new SqlParameter("@ShopId", SqlDbType.Int, 4)
};
parameters[0].Value = model.CreateTime;
parameters[1].Value = Guid.NewGuid();
parameters[2].Value = model.FoodName;
parameters[3].Value = model.Title;
parameters[4].Value = model.Introduction;
parameters[5].Value = model.Address;
parameters[6].Value = model.Price;
parameters[7].Value = model.Picture;
parameters[8].Value = model.State;
parameters[9].Value = model.IsDelete;
parameters[10].Value = model.FoodorTechan;
parameters[11].Value = model.Cover;
parameters[12].Value = model.Lon;
parameters[13].Value = model.Lat;
parameters[14].Value = model.ytype;
parameters[15].Value = model.PlayType;
parameters[16].Value = model.ShopId;
object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
///
/// </summary>
/// <param name="sqlClause"></param>
/// <returns></returns>
public object GetSingleObject(string sqlClause)
{
var result =
_providerConfig.DbProvider == DbProvider.MySql
? DbHelperMySql.GetSingle(_providerConfig.DbConnectionString, sqlClause)
: DbHelperSql.GetSingle(_providerConfig.DbConnectionString, sqlClause);
return(result);
}
public int GetSingle(string sqlClause)
{
var result =
_providerConfig.DbProvider == DbProvider.MySql
? DbHelperMySql.GetSingle(_providerConfig.DbConnectionString, sqlClause)
: DbHelperSql.GetSingle(_providerConfig.DbConnectionString, sqlClause);
return(TypeParse.StrToInt(result));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(HeqiaoDaoshiCore.Model.SystemPermission model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SystemPermission(");
strSql.Append("SystemPermissionUUID,SystemMenuUUID,Name,ActionCode,Icon,Description,Status,IsDeleted,Type,CreatedByUserGuid,CreatedOn,CreatedByUserName,ModifiedOn,ModifiedByUserGuid,ModifiedByUserName,CaPower)");
strSql.Append(" values (");
strSql.Append("@SystemPermissionUUID,@SystemMenuUUID,@Name,@ActionCode,@Icon,@Description,@Status,@IsDeleted,@Type,@CreatedByUserGuid,@CreatedOn,@CreatedByUserName,@ModifiedOn,@ModifiedByUserGuid,@ModifiedByUserName,@CaPower)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@SystemPermissionUUID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@SystemMenuUUID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@Name", SqlDbType.NVarChar, 255),
new SqlParameter("@ActionCode", SqlDbType.NVarChar, 255),
new SqlParameter("@Icon", SqlDbType.NVarChar, 255),
new SqlParameter("@Description", SqlDbType.NVarChar, 255),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@IsDeleted", SqlDbType.Int, 4),
new SqlParameter("@Type", SqlDbType.Int, 4),
new SqlParameter("@CreatedByUserGuid", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@CreatedOn", SqlDbType.NVarChar, 255),
new SqlParameter("@CreatedByUserName", SqlDbType.NVarChar, 255),
new SqlParameter("@ModifiedOn", SqlDbType.NVarChar, 255),
new SqlParameter("@ModifiedByUserGuid", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@ModifiedByUserName", SqlDbType.NVarChar, 255),
new SqlParameter("@CaPower", SqlDbType.NVarChar, 255)
};
parameters[0].Value = Guid.NewGuid();
parameters[1].Value = Guid.NewGuid();
parameters[2].Value = model.Name;
parameters[3].Value = model.ActionCode;
parameters[4].Value = model.Icon;
parameters[5].Value = model.Description;
parameters[6].Value = model.Status;
parameters[7].Value = model.IsDeleted;
parameters[8].Value = model.Type;
parameters[9].Value = Guid.NewGuid();
parameters[10].Value = model.CreatedOn;
parameters[11].Value = model.CreatedByUserName;
parameters[12].Value = model.ModifiedOn;
parameters[13].Value = Guid.NewGuid();
parameters[14].Value = model.ModifiedByUserName;
parameters[15].Value = model.CaPower;
object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(HeqiaoDaoshiCore.Model.Strategy model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Strategy(");
strSql.Append("StrategyUuid,Isdelete,Staues,SystemUserUUID,Title,StrategyContent,PhotoUrl,AddPeople,AddTime,AuditStaues,ThroughStaues,TipsType,Count,ytype,PlayType)");
strSql.Append(" values (");
strSql.Append("@StrategyUuid,@Isdelete,@Staues,@SystemUserUUID,@Title,@StrategyContent,@PhotoUrl,@AddPeople,@AddTime,@AuditStaues,@ThroughStaues,@TipsType,@Count,@ytype,@PlayType)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@StrategyUuid", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@Isdelete", SqlDbType.Int, 4),
new SqlParameter("@Staues", SqlDbType.NVarChar, 255),
new SqlParameter("@SystemUserUUID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@Title", SqlDbType.NVarChar, 255),
new SqlParameter("@StrategyContent", SqlDbType.NVarChar, -1),
new SqlParameter("@PhotoUrl", SqlDbType.NVarChar, -1),
new SqlParameter("@AddPeople", SqlDbType.NVarChar, 255),
new SqlParameter("@AddTime", SqlDbType.NVarChar, 255),
new SqlParameter("@AuditStaues", SqlDbType.Int, 4),
new SqlParameter("@ThroughStaues", SqlDbType.Int, 4),
new SqlParameter("@TipsType", SqlDbType.Int, 4),
new SqlParameter("@Count", SqlDbType.Int, 4),
new SqlParameter("@ytype", SqlDbType.NVarChar, 255),
new SqlParameter("@PlayType", SqlDbType.NVarChar, 255)
};
parameters[0].Value = Guid.NewGuid();
parameters[1].Value = model.Isdelete;
parameters[2].Value = model.Staues;
parameters[3].Value = Guid.NewGuid();
parameters[4].Value = model.Title;
parameters[5].Value = model.StrategyContent;
parameters[6].Value = model.PhotoUrl;
parameters[7].Value = model.AddPeople;
parameters[8].Value = model.AddTime;
parameters[9].Value = model.AuditStaues;
parameters[10].Value = model.ThroughStaues;
parameters[11].Value = model.TipsType;
parameters[12].Value = model.Count;
parameters[13].Value = model.ytype;
parameters[14].Value = model.PlayType;
object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(HeqiaoDaoshiCore.Model.Bank model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Bank(");
strSql.Append("BankUuid,IsDeleted,BankName,BankAddress,Lon,Lat,Staues,Telephone,Remark,RemarkOne,RemarkTwo,Picture,AddTime,AddPeople)");
strSql.Append(" values (");
strSql.Append("@BankUuid,@IsDeleted,@BankName,@BankAddress,@Lon,@Lat,@Staues,@Telephone,@Remark,@RemarkOne,@RemarkTwo,@Picture,@AddTime,@AddPeople)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@BankUuid", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@IsDeleted", SqlDbType.Int, 4),
new SqlParameter("@BankName", SqlDbType.NVarChar, -1),
new SqlParameter("@BankAddress", SqlDbType.NVarChar, -1),
new SqlParameter("@Lon", SqlDbType.NVarChar, 255),
new SqlParameter("@Lat", SqlDbType.NVarChar, 255),
new SqlParameter("@Staues", SqlDbType.NVarChar, 255),
new SqlParameter("@Telephone", SqlDbType.NVarChar, 255),
new SqlParameter("@Remark", SqlDbType.NVarChar, -1),
new SqlParameter("@RemarkOne", SqlDbType.NVarChar, -1),
new SqlParameter("@RemarkTwo", SqlDbType.NVarChar, -1),
new SqlParameter("@Picture", SqlDbType.NVarChar, -1),
new SqlParameter("@AddTime", SqlDbType.NVarChar, 255),
new SqlParameter("@AddPeople", SqlDbType.NVarChar, 255)
};
parameters[0].Value = Guid.NewGuid();
parameters[1].Value = model.IsDeleted;
parameters[2].Value = model.BankName;
parameters[3].Value = model.BankAddress;
parameters[4].Value = model.Lon;
parameters[5].Value = model.Lat;
parameters[6].Value = model.Staues;
parameters[7].Value = model.Telephone;
parameters[8].Value = model.Remark;
parameters[9].Value = model.RemarkOne;
parameters[10].Value = model.RemarkTwo;
parameters[11].Value = model.Picture;
parameters[12].Value = model.AddTime;
parameters[13].Value = model.AddPeople;
object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(HeqiaoDaoshiCore.Model.Bus model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Bus(");
strSql.Append("CreateTime,BusUuid,Name,PassSite,Introduction,Address,Picture,State,IsDelete,BegainTime,EndTime,BegainSite,EndSite,type)");
strSql.Append(" values (");
strSql.Append("@CreateTime,@BusUuid,@Name,@PassSite,@Introduction,@Address,@Picture,@State,@IsDelete,@BegainTime,@EndTime,@BegainSite,@EndSite,@type)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@BusUuid", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@Name", SqlDbType.NVarChar, -1),
new SqlParameter("@PassSite", SqlDbType.NVarChar, -1),
new SqlParameter("@Introduction", SqlDbType.NVarChar, -1),
new SqlParameter("@Address", SqlDbType.NVarChar, -1),
new SqlParameter("@Picture", SqlDbType.NVarChar, -1),
new SqlParameter("@State", SqlDbType.Int, 4),
new SqlParameter("@IsDelete", SqlDbType.Int, 4),
new SqlParameter("@BegainTime", SqlDbType.NVarChar, -1),
new SqlParameter("@EndTime", SqlDbType.NVarChar, -1),
new SqlParameter("@BegainSite", SqlDbType.NVarChar, -1),
new SqlParameter("@EndSite", SqlDbType.NVarChar, -1),
new SqlParameter("@type", SqlDbType.VarChar, 255)
};
parameters[0].Value = model.CreateTime;
parameters[1].Value = Guid.NewGuid();
parameters[2].Value = model.Name;
parameters[3].Value = model.PassSite;
parameters[4].Value = model.Introduction;
parameters[5].Value = model.Address;
parameters[6].Value = model.Picture;
parameters[7].Value = model.State;
parameters[8].Value = model.IsDelete;
parameters[9].Value = model.BegainTime;
parameters[10].Value = model.EndTime;
parameters[11].Value = model.BegainSite;
parameters[12].Value = model.EndSite;
parameters[13].Value = model.type;
object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(HeqiaoDaoshiCore.Model.SystemIcon model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SystemIcon(");
strSql.Append("SystemIconUUID,Code,Size,Color,Custom,Description,Status,IsDeleted,CreatedOn,CreatedByUserGuid,CreatedByUserName,ModifiedOn,ModifiedByUserGuid,ModifiedByUserName)");
strSql.Append(" values (");
strSql.Append("@SystemIconUUID,@Code,@Size,@Color,@Custom,@Description,@Status,@IsDeleted,@CreatedOn,@CreatedByUserGuid,@CreatedByUserName,@ModifiedOn,@ModifiedByUserGuid,@ModifiedByUserName)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@SystemIconUUID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@Code", SqlDbType.NVarChar, 50),
new SqlParameter("@Size", SqlDbType.NVarChar, 20),
new SqlParameter("@Color", SqlDbType.NVarChar, 50),
new SqlParameter("@Custom", SqlDbType.NVarChar, 60),
new SqlParameter("@Description", SqlDbType.NVarChar, -1),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@IsDeleted", SqlDbType.Int, 4),
new SqlParameter("@CreatedOn", SqlDbType.DateTime2, 8),
new SqlParameter("@CreatedByUserGuid", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@CreatedByUserName", SqlDbType.NVarChar, -1),
new SqlParameter("@ModifiedOn", SqlDbType.DateTime2, 8),
new SqlParameter("@ModifiedByUserGuid", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@ModifiedByUserName", SqlDbType.NVarChar, -1)
};
parameters[0].Value = Guid.NewGuid();
parameters[1].Value = model.Code;
parameters[2].Value = model.Size;
parameters[3].Value = model.Color;
parameters[4].Value = model.Custom;
parameters[5].Value = model.Description;
parameters[6].Value = model.Status;
parameters[7].Value = model.IsDeleted;
parameters[8].Value = model.CreatedOn;
parameters[9].Value = Guid.NewGuid();
parameters[10].Value = model.CreatedByUserName;
parameters[11].Value = model.ModifiedOn;
parameters[12].Value = Guid.NewGuid();
parameters[13].Value = model.ModifiedByUserName;
object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(big_data.Model.Town model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Town(");
strSql.Append("TownUuid,IsDeleted,TownName,TownPeople,PartyMember,Geographical,Company,SjTownUuid,TownGrade,Lon,Lat,AddTime,AddPeople)");
strSql.Append(" values (");
strSql.Append("@TownUuid,@IsDeleted,@TownName,@TownPeople,@PartyMember,@Geographical,@Company,@SjTownUuid,@TownGrade,@Lon,@Lat,@AddTime,@AddPeople)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@TownUuid", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@IsDeleted", SqlDbType.Int, 4),
new SqlParameter("@TownName", SqlDbType.NVarChar, -1),
new SqlParameter("@TownPeople", SqlDbType.NVarChar, 255),
new SqlParameter("@PartyMember", SqlDbType.NVarChar, 255),
new SqlParameter("@Geographical", SqlDbType.NVarChar, 255),
new SqlParameter("@Company", SqlDbType.NVarChar, 255),
new SqlParameter("@SjTownUuid", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@TownGrade", SqlDbType.NVarChar, 255),
new SqlParameter("@Lon", SqlDbType.NVarChar, 255),
new SqlParameter("@Lat", SqlDbType.NVarChar, 255),
new SqlParameter("@AddTime", SqlDbType.NVarChar, 255),
new SqlParameter("@AddPeople", SqlDbType.NVarChar, 255)
};
parameters[0].Value = Guid.NewGuid();
parameters[1].Value = model.IsDeleted;
parameters[2].Value = model.TownName;
parameters[3].Value = model.TownPeople;
parameters[4].Value = model.PartyMember;
parameters[5].Value = model.Geographical;
parameters[6].Value = model.Company;
parameters[7].Value = Guid.NewGuid();
parameters[8].Value = model.TownGrade;
parameters[9].Value = model.Lon;
parameters[10].Value = model.Lat;
parameters[11].Value = model.AddTime;
parameters[12].Value = model.AddPeople;
object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(HeqiaoDaoshiCore.Model.Tourism model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Tourism(");
strSql.Append("TourismUuid,CreateTime,Name,SpotContent,Address,Picture,Video,Audio,IsDelete,OrderBy,State,AddTime,AddPeople)");
strSql.Append(" values (");
strSql.Append("@TourismUuid,@CreateTime,@Name,@SpotContent,@Address,@Picture,@Video,@Audio,@IsDelete,@OrderBy,@State,@AddTime,@AddPeople)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@TourismUuid", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@SpotContent", SqlDbType.NVarChar, -1),
new SqlParameter("@Address", SqlDbType.NVarChar, -1),
new SqlParameter("@Picture", SqlDbType.NVarChar, -1),
new SqlParameter("@Video", SqlDbType.NVarChar, -1),
new SqlParameter("@Audio", SqlDbType.NVarChar, -1),
new SqlParameter("@IsDelete", SqlDbType.Int, 4),
new SqlParameter("@OrderBy", SqlDbType.Int, 4),
new SqlParameter("@State", SqlDbType.Int, 4),
new SqlParameter("@AddTime", SqlDbType.NVarChar, 50),
new SqlParameter("@AddPeople", SqlDbType.NVarChar, 255)
};
parameters[0].Value = Guid.NewGuid();
parameters[1].Value = model.CreateTime;
parameters[2].Value = model.Name;
parameters[3].Value = model.SpotContent;
parameters[4].Value = model.Address;
parameters[5].Value = model.Picture;
parameters[6].Value = model.Video;
parameters[7].Value = model.Audio;
parameters[8].Value = model.IsDelete;
parameters[9].Value = model.OrderBy;
parameters[10].Value = model.State;
parameters[11].Value = model.AddTime;
parameters[12].Value = model.AddPeople;
object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ClassLibrary1.Model.YiCardLSXX model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into YiCardLSXX(");
strSql.Append("YicardUuid,YicardName,Possessor,ConsumType,ExpenseCal,Balance,IsDeleted,AddTime,AddPeople,ConsumTime,Address,SiteName,DepName)");
strSql.Append(" values (");
strSql.Append("@YicardUuid,@YicardName,@Possessor,@ConsumType,@ExpenseCal,@Balance,@IsDeleted,@AddTime,@AddPeople,@ConsumTime,@Address,@SiteName,@DepName)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@YicardUuid", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@YicardName", SqlDbType.VarChar, 255),
new SqlParameter("@Possessor", SqlDbType.VarChar, 255),
new SqlParameter("@ConsumType", SqlDbType.VarChar, 255),
new SqlParameter("@ExpenseCal", SqlDbType.VarChar, 255),
new SqlParameter("@Balance", SqlDbType.VarChar, 255),
new SqlParameter("@IsDeleted", SqlDbType.Int, 4),
new SqlParameter("@AddTime", SqlDbType.VarChar, 255),
new SqlParameter("@AddPeople", SqlDbType.VarChar, 255),
new SqlParameter("@ConsumTime", SqlDbType.VarChar, 255),
new SqlParameter("@Address", SqlDbType.VarChar, 255),
new SqlParameter("@SiteName", SqlDbType.VarChar, 255),
new SqlParameter("@DepName", SqlDbType.VarChar, 255)
};
parameters[0].Value = Guid.NewGuid();
parameters[1].Value = model.YicardName;
parameters[2].Value = model.Possessor;
parameters[3].Value = model.ConsumType;
parameters[4].Value = model.ExpenseCal;
parameters[5].Value = model.Balance;
parameters[6].Value = model.IsDeleted;
parameters[7].Value = model.AddTime;
parameters[8].Value = model.AddPeople;
parameters[9].Value = model.ConsumTime;
parameters[10].Value = model.Address;
parameters[11].Value = model.SiteName;
parameters[12].Value = model.DepName;
object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
public int Count(string tableName, string whereClause)
{
tableName = tableName.Replace("'", "''");
if (!string.IsNullOrEmpty(whereClause) && !whereClause.TrimStart().ToLower().StartsWith("where "))
{
whereClause = " where " + whereClause;
}
string sqlClause = string.Format("SELECT Count(*) FROM {0} {1}", tableName, whereClause);
var result =
_providerConfig.DbProvider == DbProvider.MySql
? DbHelperMySql.GetSingle(_providerConfig.DbConnectionString, sqlClause)
: DbHelperSql.GetSingle(_providerConfig.DbConnectionString, sqlClause);
return(TypeParse.StrToInt(result));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(HeqiaoDaoshiCore.Model.Gtoilet model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Gtoilet(");
strSql.Append("GtoiletUuid,IsDeleted,GtoiletName,GtoiletAddress,Lon,Lat,GtoiletStaues,KongqiZhil,WaterYujin,AddTime,AddPeople,Picture)");
strSql.Append(" values (");
strSql.Append("@GtoiletUuid,@IsDeleted,@GtoiletName,@GtoiletAddress,@Lon,@Lat,@GtoiletStaues,@KongqiZhil,@WaterYujin,@AddTime,@AddPeople,@Picture)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@GtoiletUuid", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@IsDeleted", SqlDbType.Int, 4),
new SqlParameter("@GtoiletName", SqlDbType.NVarChar, 255),
new SqlParameter("@GtoiletAddress", SqlDbType.NVarChar, 255),
new SqlParameter("@Lon", SqlDbType.NVarChar, 255),
new SqlParameter("@Lat", SqlDbType.NVarChar, 255),
new SqlParameter("@GtoiletStaues", SqlDbType.NVarChar, 255),
new SqlParameter("@KongqiZhil", SqlDbType.NVarChar, 255),
new SqlParameter("@WaterYujin", SqlDbType.NVarChar, 255),
new SqlParameter("@AddTime", SqlDbType.NVarChar, 255),
new SqlParameter("@AddPeople", SqlDbType.NVarChar, 255),
new SqlParameter("@Picture", SqlDbType.NVarChar, -1)
};
parameters[0].Value = Guid.NewGuid();
parameters[1].Value = model.IsDeleted;
parameters[2].Value = model.GtoiletName;
parameters[3].Value = model.GtoiletAddress;
parameters[4].Value = model.Lon;
parameters[5].Value = model.Lat;
parameters[6].Value = model.GtoiletStaues;
parameters[7].Value = model.KongqiZhil;
parameters[8].Value = model.WaterYujin;
parameters[9].Value = model.AddTime;
parameters[10].Value = model.AddPeople;
parameters[11].Value = model.Picture;
object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(HeqiaoDaoshiCore.Model.ArticlesManagement model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ArticlesManagement(");
strSql.Append("ArticleTitle,ArticleTypeUUID,ReleaseTime,IsDelete,IsRelease,ArticleUUID,CoverPhoto,ArticleName,AddPeople,AddTime,Count,IsRecommend)");
strSql.Append(" values (");
strSql.Append("@ArticleTitle,@ArticleTypeUUID,@ReleaseTime,@IsDelete,@IsRelease,@ArticleUUID,@CoverPhoto,@ArticleName,@AddPeople,@AddTime,@Count,@IsRecommend)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ArticleTitle", SqlDbType.VarChar, 255),
new SqlParameter("@ArticleTypeUUID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@ReleaseTime", SqlDbType.VarChar, 255),
new SqlParameter("@IsDelete", SqlDbType.Int, 4),
new SqlParameter("@IsRelease", SqlDbType.Int, 4),
new SqlParameter("@ArticleUUID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@CoverPhoto", SqlDbType.VarChar, -1),
new SqlParameter("@ArticleName", SqlDbType.VarChar, -1),
new SqlParameter("@AddPeople", SqlDbType.VarChar, 255),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@Count", SqlDbType.Int, 4),
new SqlParameter("@IsRecommend", SqlDbType.Bit, 1)
};
parameters[0].Value = model.ArticleTitle;
parameters[1].Value = Guid.NewGuid();
parameters[2].Value = model.ReleaseTime;
parameters[3].Value = model.IsDelete;
parameters[4].Value = model.IsRelease;
parameters[5].Value = Guid.NewGuid();
parameters[6].Value = model.CoverPhoto;
parameters[7].Value = model.ArticleName;
parameters[8].Value = model.AddPeople;
parameters[9].Value = model.AddTime;
parameters[10].Value = model.Count;
parameters[11].Value = model.IsRecommend;
object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
///
/// </summary>
/// <param name="tablename"></param>
/// <returns></returns>
public bool CheckTableExists(string tablename)
{
tablename = tablename.Replace("'", "''");
if (_providerConfig.DbProvider == DbProvider.MySql)
{
var temp = Utils.ParseConnectionString(_providerConfig.DbConnectionString);
var dbname = temp.GetValueByParams("database", "initial catalog");
var sqlClause = string.Format("select count(*) from INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA='{1}' and TABLE_NAME='{0}' ", tablename, dbname);
return(DbHelperMySql.Exists(_providerConfig.DbConnectionString, sqlClause));
}
else
{
var sqlClause = "SELECT * FROM dbo.SysObjects WHERE ID = object_id(N'" + tablename + "') AND OBJECTPROPERTY(ID, 'IsTable') = 1";
return(TypeParse.StrToInt(DbHelperSql.GetSingle(_providerConfig.DbConnectionString, sqlClause)) != 0);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(HeqiaoDaoshiCore.Model.TourGuide model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TourGuide(");
strSql.Append("TourGuideUUID,TourGuideName,Phone,ReleaseTime,ReleaseState,IsDeleted,AddTime,AddPeople,Picture,Content,FMPicture)");
strSql.Append(" values (");
strSql.Append("@TourGuideUUID,@TourGuideName,@Phone,@ReleaseTime,@ReleaseState,@IsDeleted,@AddTime,@AddPeople,@Picture,@Content,@FMPicture)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@TourGuideUUID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@TourGuideName", SqlDbType.NVarChar, 255),
new SqlParameter("@Phone", SqlDbType.NVarChar, 100),
new SqlParameter("@ReleaseTime", SqlDbType.NVarChar, 255),
new SqlParameter("@ReleaseState", SqlDbType.Int, 4),
new SqlParameter("@IsDeleted", SqlDbType.Int, 4),
new SqlParameter("@AddTime", SqlDbType.NVarChar, 255),
new SqlParameter("@AddPeople", SqlDbType.NVarChar, 255),
new SqlParameter("@Picture", SqlDbType.NVarChar, -1),
new SqlParameter("@Content", SqlDbType.NVarChar, -1),
new SqlParameter("@FMPicture", SqlDbType.NVarChar, -1)
};
parameters[0].Value = Guid.NewGuid();
parameters[1].Value = model.TourGuideName;
parameters[2].Value = model.Phone;
parameters[3].Value = model.ReleaseTime;
parameters[4].Value = model.ReleaseState;
parameters[5].Value = model.IsDeleted;
parameters[6].Value = model.AddTime;
parameters[7].Value = model.AddPeople;
parameters[8].Value = model.Picture;
parameters[9].Value = model.Content;
parameters[10].Value = model.FMPicture;
object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(HeqiaoDaoshiCore.Model.Information model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Information(");
strSql.Append("CreateTime,InformationUUID,Title,InformationTypeUUID,Introduce,Address,StartTime,Picture,State,IsDeleted,Photo)");
strSql.Append(" values (");
strSql.Append("@CreateTime,@InformationUUID,@Title,@InformationTypeUUID,@Introduce,@Address,@StartTime,@Picture,@State,@IsDeleted,@Photo)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@CreateTime", SqlDbType.DateTime2, 8),
new SqlParameter("@InformationUUID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@Title", SqlDbType.VarChar, 255),
new SqlParameter("@InformationTypeUUID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@Introduce", SqlDbType.VarChar, -1),
new SqlParameter("@Address", SqlDbType.VarChar, 255),
new SqlParameter("@StartTime", SqlDbType.DateTime),
new SqlParameter("@Picture", SqlDbType.VarChar, -1),
new SqlParameter("@State", SqlDbType.Bit, 1),
new SqlParameter("@IsDeleted", SqlDbType.Int, 4),
new SqlParameter("@Photo", SqlDbType.VarChar, -1)
};
parameters[0].Value = model.CreateTime;
parameters[1].Value = Guid.NewGuid();
parameters[2].Value = model.Title;
parameters[3].Value = Guid.NewGuid();
parameters[4].Value = model.Introduce;
parameters[5].Value = model.Address;
parameters[6].Value = model.StartTime;
parameters[7].Value = model.Picture;
parameters[8].Value = model.State;
parameters[9].Value = model.IsDeleted;
parameters[10].Value = model.Photo;
object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
