private void Bind(ref string myDataAppend)
{
string error = "";
try
{
if (!Id.Equals(Guid.Empty))
{
Page.Title = "编辑物业公司信息";
ComplainRepair bll = new ComplainRepair();
ComplainRepairInfo model = bll.GetModel(Id);
if (model != null)
{
myDataAppend += "{ \"Id\":\"" + model.Id + "\",\"SysEnumId\":\"" + model.SysEnumId + "\",\"Phone\":\"" + model.Phone + "\",\"Address\":\"" + model.Address + "\",\"Descri\":\"" + model.Descri + "\"}";
}
}
}
catch (Exception ex)
{
error = ex.Message;
}
if (!string.IsNullOrEmpty(error))
{
MessageBox.Messager(Page, error, MessageContent.AlertTitle_Ex_Error, "error");
}
}
public int Update(ComplainRepairInfo model)
{
string cmdText = @"update ComplainRepair set UserId = @UserId,SysEnumId = @SysEnumId,Phone = @Phone,Address = @Address,Descri = @Descri,Status = @Status,LastUpdatedDate = @LastUpdatedDate
where Id = @Id" ;
SqlParameter[] parms =
{
new SqlParameter("@Id", SqlDbType.UniqueIdentifier),
new SqlParameter("@UserId", SqlDbType.UniqueIdentifier),
new SqlParameter("@SysEnumId", SqlDbType.UniqueIdentifier),
new SqlParameter("@Phone", SqlDbType.VarChar, 20),
new SqlParameter("@Address", SqlDbType.NVarChar, 50),
new SqlParameter("@Descri", SqlDbType.NVarChar, 1000),
new SqlParameter("@Status", SqlDbType.TinyInt),
new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime)
};
parms[0].Value = model.Id;
parms[1].Value = model.UserId;
parms[2].Value = model.SysEnumId;
parms[3].Value = model.Phone;
parms[4].Value = model.Address;
parms[5].Value = model.Descri;
parms[6].Value = model.Status;
parms[7].Value = model.LastUpdatedDate;
return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parms));
}
public List <ComplainRepairInfo> GetList(string sqlWhere, params SqlParameter[] cmdParms)
{
string cmdText = @"select Id,UserId,SysEnumId,Phone,Address,Descri,Status,LastUpdatedDate
from ComplainRepair";
if (!string.IsNullOrEmpty(sqlWhere))
{
cmdText += " where 1=1 " + sqlWhere;
}
List <ComplainRepairInfo> list = new List <ComplainRepairInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, cmdParms))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
ComplainRepairInfo model = new ComplainRepairInfo();
model.Id = reader.GetGuid(0);
model.UserId = reader.GetGuid(1);
model.SysEnumId = reader.GetGuid(2);
model.Phone = reader.GetString(3);
model.Address = reader.GetString(4);
model.Descri = reader.GetString(5);
model.Status = reader.GetByte(6);
model.LastUpdatedDate = reader.GetDateTime(7);
list.Add(model);
}
}
}
return(list);
}
public List <ComplainRepairInfo> GetList()
{
string cmdText = @"select Id,UserId,SysEnumId,Phone,Address,Descri,Status,LastUpdatedDate
from ComplainRepair
order by LastUpdatedDate desc " ;
List <ComplainRepairInfo> list = new List <ComplainRepairInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
ComplainRepairInfo model = new ComplainRepairInfo();
model.Id = reader.GetGuid(0);
model.UserId = reader.GetGuid(1);
model.SysEnumId = reader.GetGuid(2);
model.Phone = reader.GetString(3);
model.Address = reader.GetString(4);
model.Descri = reader.GetString(5);
model.Status = reader.GetByte(6);
model.LastUpdatedDate = reader.GetDateTime(7);
list.Add(model);
}
}
}
return(list);
}
public ComplainRepairInfo GetModel(object Id)
{
ComplainRepairInfo model = null;
string cmdText = @"select top 1 Id,UserId,SysEnumId,Phone,Address,Descri,Status,LastUpdatedDate
from ComplainRepair
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 ComplainRepairInfo();
model.Id = reader.GetGuid(0);
model.UserId = reader.GetGuid(1);
model.SysEnumId = reader.GetGuid(2);
model.Phone = reader.GetString(3);
model.Address = reader.GetString(4);
model.Descri = reader.GetString(5);
model.Status = reader.GetByte(6);
model.LastUpdatedDate = reader.GetDateTime(7);
}
}
}
return(model);
}
/// <summary>
/// 保存企业投诉保修
/// </summary>
/// <param name="username"></param>
/// <param name="address"></param>
/// <param name="phone"></param>
/// <param name="descri"></param>
/// <returns></returns>
public string SaveHouseOwnerComplainRepair(string username, string address, string phone, string descri)
{
try
{
if (string.IsNullOrWhiteSpace(address))
{
return(string.Format("<Rsp><IsOK>{0}</IsOK><RtMsg>{1}</RtMsg></Rsp>", false, "住址为必填项"));
}
if (string.IsNullOrWhiteSpace(phone))
{
return(string.Format("<Rsp><IsOK>{0}</IsOK><RtMsg>{1}</RtMsg></Rsp>", false, "联系号码为必填项"));
}
if (string.IsNullOrWhiteSpace(descri))
{
return(string.Format("<Rsp><IsOK>{0}</IsOK><RtMsg>{1}</RtMsg></Rsp>", false, "描述为必填项"));
}
WebSecurityService wsClient = new WebSecurityService();
object userId = wsClient.GetUserId(username);
if (userId == null)
{
return(string.Format("<Rsp><IsOK>{0}</IsOK><RtMsg>{1}</RtMsg></Rsp>", false, "用户【" + username + "】不存在或已被删除"));
}
SysEnum seBll = new SysEnum();
var seModel = seBll.GetModel(SysEnumHelper.GetEnumNameForComplainRepairType(SysEnumHelper.ComplainRepairType.ResidentFamily));
if (seModel == null)
{
return(string.Format("<Rsp><IsOK>{0}</IsOK><RtMsg>{1}</RtMsg></Rsp>", false, "找不到投诉保修类型，待系统管理员设定后再使用"));
}
ComplainRepairInfo model = new ComplainRepairInfo();
model.UserId = Guid.Parse(userId.ToString());
model.LastUpdatedDate = DateTime.Now;
model.Phone = phone.Trim();
model.Descri = descri.Trim();
model.SysEnumId = Guid.Parse(seModel.Id.ToString());
model.Status = (byte)SysEnumHelper.ComplainRepairStatus.受理中;
model.Address = address.Trim();
ComplainRepair bll = new ComplainRepair();
int effect = bll.Insert(model);
if (effect == 110)
{
return(string.Format("<Rsp><IsOK>{0}</IsOK><RtMsg>{1}</RtMsg></Rsp>", false, "已存在相同数据记录，请勿重复提交！"));
}
if (effect < 1)
{
return(string.Format("<Rsp><IsOK>{0}</IsOK><RtMsg>{1}</RtMsg></Rsp>", false, "操作失败，请正确操作！"));
}
else
{
return(string.Format("<Rsp><IsOK>{0}</IsOK><RtMsg>{1}</RtMsg></Rsp>", true, "保存成功，我们会尽快处理！"));
}
}
catch (Exception ex)
{
return(string.Format("<Rsp><IsOK>{0}</IsOK><RtMsg>{1}</RtMsg></Rsp>", false, "异常：" + ex.Message));
}
}
public List <ComplainRepairInfo> GetList(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms)
{
string cmdText = @"select count(*) from ComplainRepair ";
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 desc) as RowNumber,
Id,UserId,SysEnumId,Phone,Address,Descri,Status,LastUpdatedDate
from ComplainRepair " ;
if (!string.IsNullOrEmpty(sqlWhere))
{
cmdText += "where 1=1 " + sqlWhere;
}
cmdText += ")as objTable where RowNumber between " + startIndex + " and " + endIndex + " ";
List <ComplainRepairInfo> list = new List <ComplainRepairInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, cmdParms))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
ComplainRepairInfo model = new ComplainRepairInfo();
model.Id = reader.GetGuid(1);
model.UserId = reader.GetGuid(2);
model.SysEnumId = reader.GetGuid(3);
model.Phone = reader.GetString(4);
model.Address = reader.GetString(5);
model.Descri = reader.GetString(6);
model.Status = reader.GetByte(7);
model.LastUpdatedDate = reader.GetDateTime(8);
list.Add(model);
}
}
}
return(list);
}
public IList <ComplainRepairInfo> GetListByJoin(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms)
{
string cmdText = string.Format(@"select count(*)
from ComplainRepair cr
left join {0}aspnet_Users u on u.UserId = cr.UserId
left join Sys_Enum se on se.Id = cr.SysEnumId
", ConfigHelper.AspnetDbDbo);
if (!string.IsNullOrEmpty(sqlWhere))
{
cmdText += " where 1=1 " + sqlWhere;
}
totalRecords = (int)SqlHelper.ExecuteScalar(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, cmdParms);
if (totalRecords == 0)
{
return(null);
}
int startIndex = (pageIndex - 1) * pageSize + 1;
int endIndex = pageIndex * pageSize;
cmdText = string.Format(@"select * from(select row_number() over(order by cr.LastUpdatedDate desc) as RowNumber,
cr.Id,cr.UserId,cr.SysEnumId,cr.Phone,cr.Address,cr.Descri,cr.Status,cr.LastUpdatedDate,
se.EnumValue, u.UserName
from ComplainRepair cr
left join {0}aspnet_Users u on u.UserId = cr.UserId
left join Sys_Enum se on se.Id = cr.SysEnumId
", ConfigHelper.AspnetDbDbo);
if (!string.IsNullOrEmpty(sqlWhere))
{
cmdText += "where 1=1 " + sqlWhere;
}
cmdText += ")as objTable where RowNumber between " + startIndex + " and " + endIndex + " ";
IList <ComplainRepairInfo> list = new List <ComplainRepairInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, cmdParms))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
ComplainRepairInfo model = new ComplainRepairInfo();
model.Id = reader.GetGuid(1);
model.UserId = reader.GetGuid(2);
model.SysEnumId = reader.GetGuid(3);
model.Phone = reader.GetString(4);
model.Address = reader.GetString(5);
model.Descri = reader.GetString(6);
model.Status = reader.GetByte(7);
model.LastUpdatedDate = reader.GetDateTime(8);
model.StatusName = reader.IsDBNull(9) ? "" : reader.GetString(9);
model.UserName = reader.IsDBNull(10) ? "" : reader.GetString(10);
list.Add(model);
}
}
}
return(list);
}
/// <summary>
/// 修改数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Update(ComplainRepairInfo model)
{
return(dal.Update(model));
}
/// <summary>
/// 添加数据到数据库
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(ComplainRepairInfo model)
{
return(dal.Insert(model));
}
