/// <summary> /// 更新一条数据 /// </summary> public bool Update(AMS.Model.AMS_Province model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update AMS_Province set "); strSql.Append("ProvinceName=@ProvinceName,"); strSql.Append("Remark=@Remark"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ProvinceName", SqlDbType.NVarChar, 50), new SqlParameter("@Remark", SqlDbType.NVarChar, 200), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.ProvinceName; parameters[1].Value = model.Remark; parameters[2].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(AMS.Model.AMS_Province model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into AMS_Province("); strSql.Append("ProvinceName,Remark)"); strSql.Append(" values ("); strSql.Append("@ProvinceName,@Remark)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@ProvinceName", SqlDbType.NVarChar, 50), new SqlParameter("@Remark", SqlDbType.NVarChar, 200) }; parameters[0].Value = model.ProvinceName; parameters[1].Value = model.Remark; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 删除地区 /// </summary> /// <param name="model"></param> /// <returns></returns> public string DeleteProvine(AMS.Model.AMS_Province model) { try { if (!dal_Province.Delete(model.ID)) { return("删除地区信息失败!"); } return(""); } catch (Exception ex) { return(ex.Message); } }
/// <summary> /// 修改地区 /// </summary> /// <param name="model"></param> /// <returns></returns> public string UpdateProvine(AMS.Model.AMS_Province model) { try { AMS.Model.AMS_Province sameModel = dal_Province.GetModel(model.ProvinceName); if (sameModel != null && sameModel.ID != model.ID) { return("该地区名称已存在!"); } if (!dal_Province.Update(model)) { return("修改地区信息失败!"); } return(""); } catch (Exception ex) { return(ex.Message); } }
/// <summary> /// 添加地址 /// </summary> /// <param name="model"></param> /// <returns></returns> public string AddNewProvine(AMS.Model.AMS_Province model) { try { AMS.Model.AMS_Province sameModel = dal_Province.GetModel(model.ProvinceName); if (sameModel != null) { return("该地区名称已存在!"); } if (dal_Province.Add(model) == 0) { return("添加地区信息失败!"); } return(""); } catch (Exception ex) { return(ex.Message); } }
/// <summary> /// 添加新的省份 /// </summary> /// <param name="model"></param> /// <returns></returns> public static string AddNewProvince(AMS.Model.AMS_Province model) { AMS.IBllService.IAdvertManageBllService bllService = AMS.ServiceConnectChannel.AdvertManageBllServiceChannel.CreateServiceChannel(); try { return(bllService.AddNewProvine(model)); } catch (EndpointNotFoundException ex) { throw new AMS.Model.CustomerException("连接服务器失败"); } catch (CommunicationException ex) { throw ex; } catch (Exception ex) { throw ex; } finally { ICommunicationObject ICommObjectService = bllService as ICommunicationObject; try { if (ICommObjectService.State == CommunicationState.Faulted) { ICommObjectService.Abort(); } else { ICommObjectService.Close(); } } catch { ICommObjectService.Abort(); } } }
/// <summary> /// 得到一个对象实体 /// </summary> public AMS.Model.AMS_Province GetModel(string ProvinceName) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,ProvinceName,Remark from AMS_Province "); strSql.Append(" where ProvinceName=@ProvinceName"); SqlParameter[] parameters = { new SqlParameter("@ProvinceName", SqlDbType.NVarChar) }; parameters[0].Value = ProvinceName; AMS.Model.AMS_Province model = new AMS.Model.AMS_Province(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } if (ds.Tables[0].Rows[0]["ProvinceName"] != null && ds.Tables[0].Rows[0]["ProvinceName"].ToString() != "") { model.ProvinceName = ds.Tables[0].Rows[0]["ProvinceName"].ToString(); } if (ds.Tables[0].Rows[0]["Remark"] != null && ds.Tables[0].Rows[0]["Remark"].ToString() != "") { model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString(); } return(model); } else { return(null); } }