public ProvinceCityInfo GetModel(string name) { ProvinceCityInfo model = null; string cmdText = @"select top 1 Id,Named,Pinyin,FirstChar,ParentId,Sort,Remark,LastUpdatedDate from ProvinceCity where Named = @Named " ; SqlParameter parm = new SqlParameter("@Named", SqlDbType.NVarChar, 50); parm.Value = name; using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parm)) { if (reader != null) { while (reader.Read()) { model = new ProvinceCityInfo(); model.Id = reader.GetGuid(0); model.Named = reader.GetString(1); model.Pinyin = reader.GetString(2); model.FirstChar = reader.GetString(3); model.ParentId = reader.GetGuid(4); model.Sort = reader.GetInt32(5); model.Remark = reader.GetString(6); model.LastUpdatedDate = reader.GetDateTime(7); } } } return(model); }
public List <ProvinceCityInfo> GetList(string sqlWhere, params SqlParameter[] cmdParms) { string cmdText = @"select Id,Named,Pinyin,FirstChar,ParentId,Sort,Remark,LastUpdatedDate from ProvinceCity "; if (!string.IsNullOrEmpty(sqlWhere)) { cmdText += "where 1=1 " + sqlWhere; } List <ProvinceCityInfo> list = new List <ProvinceCityInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { ProvinceCityInfo model = new ProvinceCityInfo(); model.Id = reader.GetGuid(0); model.Named = reader.GetString(1); model.Pinyin = reader.GetString(2); model.FirstChar = reader.GetString(3); model.ParentId = reader.GetGuid(4); model.Sort = reader.GetInt32(5); model.Remark = reader.GetString(6); model.LastUpdatedDate = reader.GetDateTime(7); list.Add(model); } } } return(list); }
public List <ProvinceCityInfo> GetList() { string cmdText = @"select Id,Named,Pinyin,FirstChar,ParentId,Sort,Remark,LastUpdatedDate from ProvinceCity order by LastUpdatedDate " ; List <ProvinceCityInfo> list = new List <ProvinceCityInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText)) { if (reader != null && reader.HasRows) { while (reader.Read()) { ProvinceCityInfo model = new ProvinceCityInfo(); model.Id = reader.GetGuid(0); model.Named = reader.GetString(1); model.Pinyin = reader.GetString(2); model.FirstChar = reader.GetString(3); model.ParentId = reader.GetGuid(4); model.Sort = reader.GetInt32(5); model.Remark = reader.GetString(6); model.LastUpdatedDate = reader.GetDateTime(7); list.Add(model); } } } return(list); }
public int Insert(ProvinceCityInfo model) { if (IsExist(model.Named, model.ParentId, null)) { return(110); } StringBuilder sb = new StringBuilder(250); sb.Append(@"insert into ProvinceCity (Named,Pinyin,FirstChar,ParentId,Sort,Remark,LastUpdatedDate) values (@Named,@Pinyin,@FirstChar,@ParentId,@Sort,@Remark,@LastUpdatedDate) " ); SqlParameter[] parms = { new SqlParameter("@Named", SqlDbType.NVarChar, 30), new SqlParameter("@Pinyin", SqlDbType.VarChar, 30), new SqlParameter("@FirstChar", SqlDbType.Char, 1), new SqlParameter("@ParentId", SqlDbType.UniqueIdentifier), new SqlParameter("@Sort", SqlDbType.Int), new SqlParameter("@Remark", SqlDbType.NVarChar, 300), new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime) }; parms[0].Value = model.Named; parms[1].Value = model.Pinyin; parms[2].Value = model.FirstChar; parms[3].Value = model.ParentId; parms[4].Value = model.Sort; parms[5].Value = model.Remark; parms[6].Value = model.LastUpdatedDate; return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlProviderConnString, CommandType.Text, sb.ToString(), parms)); }
public ProvinceCityInfo GetModel(object Id) { ProvinceCityInfo model = null; StringBuilder sb = new StringBuilder(300); sb.Append(@"select top 1 Id,Named,Pinyin,FirstChar,ParentId,Sort,Remark,LastUpdatedDate from ProvinceCity 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, sb.ToString(), parm)) { if (reader != null) { while (reader.Read()) { model = new ProvinceCityInfo(); model.Id = reader.GetGuid(0); model.Named = reader.GetString(1); model.Pinyin = reader.GetString(2); model.FirstChar = reader.GetString(3); model.ParentId = reader.GetGuid(4); model.Sort = reader.GetInt32(5); model.Remark = reader.GetString(6); model.LastUpdatedDate = reader.GetDateTime(7); } } } return(model); }
public int Update(ProvinceCityInfo model) { if (IsExist(model.Named, model.ParentId, model.Id)) { return(110); } StringBuilder sb = new StringBuilder(250); sb.Append(@"update ProvinceCity set Named = @Named,Pinyin = @Pinyin,FirstChar = @FirstChar,ParentId = @ParentId,Sort = @Sort,Remark = @Remark,LastUpdatedDate = @LastUpdatedDate where Id = @Id " ); SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.UniqueIdentifier), new SqlParameter("@Named", SqlDbType.NVarChar, 30), new SqlParameter("@Pinyin", SqlDbType.VarChar, 30), new SqlParameter("@FirstChar", SqlDbType.Char, 1), new SqlParameter("@ParentId", SqlDbType.UniqueIdentifier), new SqlParameter("@Sort", SqlDbType.Int), new SqlParameter("@Remark", SqlDbType.NVarChar, 300), new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime) }; parms[0].Value = model.Id; parms[1].Value = model.Named; parms[2].Value = model.Pinyin; parms[3].Value = model.FirstChar; parms[4].Value = model.ParentId; parms[5].Value = model.Sort; parms[6].Value = model.Remark; parms[7].Value = model.LastUpdatedDate; return(SqlHelper.ExecuteNonQuery(SqlHelper.GzxySiteDbConnString, CommandType.Text, sb.ToString(), parms)); }
public int Update(ProvinceCityInfo model) { string cmdText = @"update ProvinceCity set Named = @Named,Pinyin = @Pinyin,FirstChar = @FirstChar,ParentId = @ParentId,Sort = @Sort,Remark = @Remark,LastUpdatedDate = @LastUpdatedDate where Id = @Id" ; SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.UniqueIdentifier), new SqlParameter("@Named", SqlDbType.NVarChar, 30), new SqlParameter("@Pinyin", SqlDbType.VarChar, 30), new SqlParameter("@FirstChar", SqlDbType.Char, 1), new SqlParameter("@ParentId", SqlDbType.UniqueIdentifier), new SqlParameter("@Sort", SqlDbType.Int), new SqlParameter("@Remark", SqlDbType.NVarChar, 300), new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime) }; parms[0].Value = model.Id; parms[1].Value = model.Named; parms[2].Value = model.Pinyin; parms[3].Value = model.FirstChar; parms[4].Value = model.ParentId; parms[5].Value = model.Sort; parms[6].Value = model.Remark; parms[7].Value = model.LastUpdatedDate; return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parms)); }
/// <summary> /// 获取对应的数据 /// </summary> /// <param name="Id"></param> /// <returns></returns> public string GetProvinceCityModel(object Id) { ProvinceCity bll = new ProvinceCity(); ProvinceCityInfo model = bll.GetModel(Id); if (model == null) { return("[]"); } return(JsonConvert.SerializeObject(model)); }
public string GetProvinceCityModel(Guid Id) { StringBuilder sb = new StringBuilder(); ProvinceCity bll = new ProvinceCity(); ProvinceCityInfo model = bll.GetModel(Id); if (model == null) { return("[]"); } return(sb.ToString()); }
public string SaveProvinceCity(ProvinceCityInfo model) { if (string.IsNullOrWhiteSpace(model.Named)) { return(MessageContent.Submit_Params_InvalidError); } if (string.IsNullOrWhiteSpace(model.Pinyin)) { return(MessageContent.Submit_Params_InvalidError); } if (string.IsNullOrWhiteSpace(model.FirstChar)) { return(MessageContent.Submit_Params_InvalidError); } Guid gId = Guid.Empty; Guid.TryParse(model.Id.ToString(), out gId); model.Id = gId; Guid parentId = Guid.Empty; Guid.TryParse(model.ParentId.ToString(), out parentId); model.ParentId = parentId; model.LastUpdatedDate = DateTime.Now; ProvinceCity bll = new ProvinceCity(); int effect = -1; if (!gId.Equals(Guid.Empty)) { effect = bll.Update(model); } else { effect = bll.Insert(model); } if (effect == 110) { return(MessageContent.Submit_Exist); } if (effect > 0) { return("1"); } else { return(MessageContent.Submit_Error); } }
public List <ProvinceCityInfo> GetList(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms) { string cmdText = @"select count(*) from ProvinceCity "; 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,Named,Pinyin,FirstChar,ParentId,Sort,Remark,LastUpdatedDate from ProvinceCity " ; if (!string.IsNullOrEmpty(sqlWhere)) { cmdText += "where 1=1 " + sqlWhere; } cmdText += ")as objTable where RowNumber between " + startIndex + " and " + endIndex + " "; List <ProvinceCityInfo> list = new List <ProvinceCityInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { ProvinceCityInfo model = new ProvinceCityInfo(); model.Id = reader.GetGuid(1); model.Named = reader.GetString(2); model.Pinyin = reader.GetString(3); model.FirstChar = reader.GetString(4); model.ParentId = reader.GetGuid(5); model.Sort = reader.GetInt32(6); model.Remark = reader.GetString(7); model.LastUpdatedDate = reader.GetDateTime(8); list.Add(model); } } } return(list); }
/// <summary> /// 获取所有省份列表 /// </summary> /// <returns></returns> public string GetProvince() { ProvinceCity bll = new ProvinceCity(); ProvinceCityInfo parentModel = bll.GetModel("中国"); if (parentModel == null) { return("[]"); } SqlParameter parm = new SqlParameter("@ParentId", SqlDbType.UniqueIdentifier); parm.Value = parentModel.Id; List <ProvinceCityInfo> list = bll.GetList("and ParentId = @ParentId", parm); if (list == null || list.Count == 0) { return("[]"); } return(JsonConvert.SerializeObject(list)); }
public string GetProvince() { StringBuilder sb = new StringBuilder(); ProvinceCity bll = new ProvinceCity(); ProvinceCityInfo parentModel = bll.GetModel("中国"); if (parentModel == null) { return("[]"); } SqlParameter parm = new SqlParameter("@ParentId", SqlDbType.UniqueIdentifier); parm.Value = parentModel.Id; List <ProvinceCityInfo> list = bll.GetList("and ParentId = @ParentId", parm); if (list == null || list.Count == 0) { return("[]"); } return(sb.ToString()); }
/// <summary> /// 修改数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int UpdateProvinceCity(ProvinceCityInfo model) { ProvinceCity bll = new ProvinceCity(); return(bll.Update(model)); }
/// <summary> /// 添加数据到数据库 /// </summary> /// <param name="model"></param> /// <returns></returns> public int InsertProvinceCity(ProvinceCityInfo model) { ProvinceCity bll = new ProvinceCity(); return(bll.Insert(model)); }
/// <summary> /// 添加数据到数据库 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Insert(ProvinceCityInfo model) { return(dal.Insert(model)); }
/// <summary> /// 修改数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Update(ProvinceCityInfo model) { return(dal.Update(model)); }
public string SaveProvinceCity(ProvinceCityInfo model) { string errorMsg = string.Empty; try { if (string.IsNullOrWhiteSpace(model.Named)) { return(MC.Submit_Params_InvalidError); } if (string.IsNullOrWhiteSpace(model.Pinyin)) { return(MC.Submit_Params_InvalidError); } if (string.IsNullOrWhiteSpace(model.FirstChar)) { return(MC.Submit_Params_InvalidError); } Guid gId = Guid.Empty; Guid.TryParse(model.Id.ToString(), out gId); model.Id = gId; Guid parentId = Guid.Empty; Guid.TryParse(model.ParentId.ToString(), out parentId); model.ParentId = parentId; model.LastUpdatedDate = DateTime.Now; ProvinceCity bll = new ProvinceCity(); int effect = -1; using (TransactionScope scope = new TransactionScope()) { if (!gId.Equals(Guid.Empty)) { effect = bll.Update(model); } else { effect = bll.Insert(model); } scope.Complete(); } if (effect == 110) { return(MC.Submit_Exist); } if (effect > 0) { return("1"); } else { return(MC.Submit_Error); } } catch (Exception ex) { errorMsg = ex.Message; } return(MC.GetString(MC.Submit_Ex_Error, errorMsg)); }