public int Update(PropertyCompanyInfo model)
{
string cmdText = @"update PropertyCompany set CompanyName = @CompanyName,ShortName = @ShortName,Province = @Province,ProvinceCityId = @ProvinceCityId,City = @City,District = @District,LastUpdatedDate = @LastUpdatedDate
where Id = @Id" ;
SqlParameter[] parms =
{
new SqlParameter("@Id", SqlDbType.UniqueIdentifier),
new SqlParameter("@CompanyName", SqlDbType.NVarChar, 30),
new SqlParameter("@ShortName", SqlDbType.VarChar, 30),
new SqlParameter("@Province", SqlDbType.NVarChar, 10),
new SqlParameter("@ProvinceCityId", SqlDbType.UniqueIdentifier),
new SqlParameter("@City", SqlDbType.NVarChar, 10),
new SqlParameter("@District", SqlDbType.NVarChar, 20),
new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime)
};
parms[0].Value = model.Id;
parms[1].Value = model.CompanyName;
parms[2].Value = model.ShortName;
parms[3].Value = model.Province;
parms[4].Value = model.ProvinceCityId;
parms[5].Value = model.City;
parms[6].Value = model.District;
parms[7].Value = model.LastUpdatedDate;
return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parms));
}
public List <PropertyCompanyInfo> GetList(string sqlWhere, params SqlParameter[] cmdParms)
{
string cmdText = @"select Id,CompanyName,ShortName,Province,ProvinceCityId,City,District,LastUpdatedDate
from PropertyCompany";
if (!string.IsNullOrEmpty(sqlWhere))
{
cmdText += "where 1=1 " + sqlWhere;
}
List <PropertyCompanyInfo> list = new List <PropertyCompanyInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, cmdParms))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
PropertyCompanyInfo model = new PropertyCompanyInfo();
model.Id = reader.GetGuid(0);
model.CompanyName = reader.GetString(1);
model.ShortName = reader.GetString(2);
model.Province = reader.GetString(3);
model.ProvinceCityId = reader.GetGuid(4);
model.City = reader.GetString(5);
model.District = reader.GetString(6);
model.LastUpdatedDate = reader.GetDateTime(7);
list.Add(model);
}
}
}
return(list);
}
public List <PropertyCompanyInfo> GetList()
{
string cmdText = @"select Id,CompanyName,ShortName,Province,ProvinceCityId,City,District,LastUpdatedDate
from PropertyCompany
order by LastUpdatedDate " ;
List <PropertyCompanyInfo> list = new List <PropertyCompanyInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
PropertyCompanyInfo model = new PropertyCompanyInfo();
model.Id = reader.GetGuid(0);
model.CompanyName = reader.GetString(1);
model.ShortName = reader.GetString(2);
model.Province = reader.GetString(3);
model.ProvinceCityId = reader.GetGuid(4);
model.City = reader.GetString(5);
model.District = reader.GetString(6);
model.LastUpdatedDate = reader.GetDateTime(7);
list.Add(model);
}
}
}
return(list);
}
public PropertyCompanyInfo GetModel(object Id)
{
PropertyCompanyInfo model = null;
string cmdText = @"select top 1 Id,CompanyName,ShortName,Province,ProvinceCityId,City,District,LastUpdatedDate
from PropertyCompany
where Id = @Id " ;
SqlParameter parm = new SqlParameter("@Id", SqlDbType.UniqueIdentifier);
parm.Value = Guid.Parse(Id.ToString());
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parm))
{
if (reader != null)
{
while (reader.Read())
{
model = new PropertyCompanyInfo();
model.Id = reader.GetGuid(0);
model.CompanyName = reader.GetString(1);
model.ShortName = reader.GetString(2);
model.Province = reader.GetString(3);
model.ProvinceCityId = reader.GetGuid(4);
model.City = reader.GetString(5);
model.District = reader.GetString(6);
model.LastUpdatedDate = reader.GetDateTime(7);
}
}
}
return(model);
}
private void Bind(ref string myDataAppend)
{
string error = "";
try
{
if (!Id.Equals(Guid.Empty))
{
Page.Title = "编辑物业公司信息";
PropertyCompany bll = new PropertyCompany();
PropertyCompanyInfo model = bll.GetModel(Id);
if (model != null)
{
myDataAppend += "{ \"Id\":\"" + model.Id + "\",\"ProvinceCityId\":\"" + model.ProvinceCityId + "\",\"CompanyName\":\"" + model.CompanyName + "\",\"ShortName\":\"" + model.ShortName + "\"}";
}
}
}
catch (Exception ex)
{
error = ex.Message;
}
if (!string.IsNullOrEmpty(error))
{
MessageBox.Messager(Page, error, MessageContent.AlertTitle_Ex_Error, "error");
}
}
public List <PropertyCompanyInfo> GetList(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms)
{
string cmdText = @"select count(*) from PropertyCompany ";
if (!string.IsNullOrEmpty(sqlWhere))
{
cmdText += "where 1=1 " + sqlWhere;
}
totalRecords = (int)SqlHelper.ExecuteScalar(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, cmdParms);
int startIndex = (pageIndex - 1) * pageSize + 1;
int endIndex = pageIndex * pageSize;
cmdText = @"select * from(select row_number() over(order by LastUpdatedDate) as RowNumber,
Id,CompanyName,ShortName,Province,ProvinceCityId,City,District,LastUpdatedDate
from PropertyCompany " ;
if (!string.IsNullOrEmpty(sqlWhere))
{
cmdText += "where 1=1 " + sqlWhere;
}
cmdText += ")as objTable where RowNumber between " + startIndex + " and " + endIndex + " ";
List <PropertyCompanyInfo> list = new List <PropertyCompanyInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, cmdParms))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
PropertyCompanyInfo model = new PropertyCompanyInfo();
model.Id = reader.GetGuid(1);
model.CompanyName = reader.GetString(2);
model.ShortName = reader.GetString(3);
model.Province = reader.GetString(4);
model.ProvinceCityId = reader.GetGuid(5);
model.City = reader.GetString(6);
model.District = reader.GetString(7);
model.LastUpdatedDate = reader.GetDateTime(8);
list.Add(model);
}
}
}
return(list);
}
/// <summary>
/// 修改数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdatePropertyCompany(PropertyCompanyInfo model)
{
PropertyCompany bll = new PropertyCompany();
return(bll.Update(model));
}
/// <summary>
/// 添加数据到数据库
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int InsertPropertyCompany(PropertyCompanyInfo model)
{
PropertyCompany bll = new PropertyCompany();
return(bll.Insert(model));
}
/// <summary>
/// 修改数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Update(PropertyCompanyInfo model)
{
return(dal.Update(model));
}
/// <summary>
/// 添加数据到数据库
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(PropertyCompanyInfo model)
{
return(dal.Insert(model));
}
