public int AddSites(SitesManagementInfo SitesInfo)
{
int result = 0;
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(@"INSERT INTO [Ecshop_Sites]
([SitesName]
,[Code]
,[Province]
,[City]
,[IsDefault]
,[Sort]
,[Description])
VALUES
(@SitesName
,@Code
,@Province
,@City
,@IsDefault
,@Sort
,@Description);SELECT @@IDENTITY");
this.database.AddInParameter(sqlStringCommand, "SitesName", DbType.String, SitesInfo.SitesName);
this.database.AddInParameter(sqlStringCommand, "Code", DbType.String, SitesInfo.Code);
this.database.AddInParameter(sqlStringCommand, "Province", DbType.String, SitesInfo.Province);
this.database.AddInParameter(sqlStringCommand, "City", DbType.Int32, SitesInfo.City);
this.database.AddInParameter(sqlStringCommand, "IsDefault", DbType.Int32, SitesInfo.IsDefault);
this.database.AddInParameter(sqlStringCommand, "Sort", DbType.Int32, SitesInfo.Sort);
this.database.AddInParameter(sqlStringCommand, "Description", DbType.String, SitesInfo.Description);
object obj = this.database.ExecuteScalar(sqlStringCommand);
if (obj != null)
{
result = Convert.ToInt32(obj.ToString());
}
return(result);
}
public SitesManagementInfo GetSites(int SitesId)
{
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Ecshop_Sites WHERE SitesId = @SitesId");
this.database.AddInParameter(sqlStringCommand, "SitesId", DbType.Int32, SitesId);
SitesManagementInfo result = null;
using (IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
result = ReaderConvert.ReaderToModel <SitesManagementInfo>(dataReader);
}
return(result);
}
public bool UpdateSites(SitesManagementInfo SitesInfo)
{
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(@"UPDATE [Ecshop_Sites]
SET [SitesName] = @SitesName
,[Code] = @Code
,[Province] = @Province
,[City] = @City
,[IsDefault] =@IsDefault
,[Sort] = @Sort
,[Description] = @Description
WHERE SitesId=@SitesId");
this.database.AddInParameter(sqlStringCommand, "SitesName", DbType.String, SitesInfo.SitesName);
this.database.AddInParameter(sqlStringCommand, "Code", DbType.String, SitesInfo.Code);
this.database.AddInParameter(sqlStringCommand, "Province", DbType.Int32, SitesInfo.Province);
this.database.AddInParameter(sqlStringCommand, "City", DbType.Int32, SitesInfo.City);
this.database.AddInParameter(sqlStringCommand, "IsDefault", DbType.String, SitesInfo.IsDefault);
this.database.AddInParameter(sqlStringCommand, "Sort", DbType.String, SitesInfo.Sort);
this.database.AddInParameter(sqlStringCommand, "Description", DbType.String, SitesInfo.Description);
this.database.AddInParameter(sqlStringCommand, "SitesId", DbType.Int32, SitesInfo.SitesId);
return(this.database.ExecuteNonQuery(sqlStringCommand) > 0);
}
