public void ProcessRequest(HttpContext context)
{
int id = 0;
if (!string.IsNullOrEmpty(context.Request.Form["id"]))
{
id = int.Parse(context.Request.Form["id"]);
}
BLL.AreaBll cb = new BLL.AreaBll();
StringBuilder sb = new StringBuilder();
List <Model.Area> cm = cb.CityList(id);
sb.Append("[");
if (cm.Count > 0)
{
for (int i = 0; i < cm.Count; i++)
{
Model.Area model = cm[i];
sb.Append("{");
sb.AppendFormat(@"""c_name"":""{0}"",", model.title);
sb.AppendFormat(@"""c_code"":""{0}""", model.id);
sb.Append("}");
if (i < cm.Count - 1)
{
sb.Append(",");
}
}
}
sb.Append("]");
// System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
System.Web.HttpContext.Current.Response.Write(sb.ToString());
context.Response.End();
}
private void btnAddUpdate_Click(object sender, System.Windows.RoutedEventArgs e)
{
string areaName = txtAreaName.Text.Trim();
if (string.IsNullOrEmpty(areaName))
{
MessageBox.Show("Ingrese el nombre del área", "Información", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
else if (_isUpdateArea)
{
_selectedArea.Name = areaName;
if (Controllers.BusinessController.Instance.Update<Model.Area>(_selectedArea))
this.Close();
else
MessageBox.Show("No se pudo actualizar el área", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
else
{
Model.Area areaToAdd = new Model.Area()
{
Name = areaName,
CreatedDate = DateTime.Now,
IsDeleted = false
};
if (Controllers.BusinessController.Instance.Add<Model.Area>(areaToAdd))
this.Close();
else
MessageBox.Show("No se pudo agregar el área", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
/// <summary>
/// 转换为地区数据传输对象
/// </summary>
/// <param name="area">地区</param>
public static AreaDto ToDto(this Model.Area area)
{
if (area == null)
{
return(new AreaDto());
}
return(new AreaDto
{
Id = area.Id,
RegionalismCode = area.RegionalismCode,
GeographicalRegion = area.GeographicalRegion,
EconomicRegion = area.EconomicRegion,
Name = area.Name,
ShortName = area.ShortName,
Pinyin = area.Pinyin,
ShortPinyin = area.ShortPinyin,
FirstPinyin = area.FirstPinyin,
AreaCode = area.AreaCode,
ZipCode = area.ZipCode,
Longitude = area.Longitude,
Latitude = area.Latitude,
IsAdministrativeCenter = area.IsAdministrativeCenter,
ParentId = area.ParentId,
Level = area.Level,
SortId = area.SortId,
});
}
public void Add(Model.Area r)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("insert into Area values({0},{1},{2},{3},{4},{5},{6},{7},{8})", "@Id", "@Latitude", "@Level", "@Longitude", "@Name", "@Pid", "@Position", "@ShortName", "@Sort");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4),
new SqlParameter("@Latitude", SqlDbType.Char, 15),
new SqlParameter("@Level", SqlDbType.Int, 4),
new SqlParameter("@Longitude", SqlDbType.Char, 15),
new SqlParameter("@Name", SqlDbType.VarChar, 50),
new SqlParameter("@Pid", SqlDbType.Int, 4),
new SqlParameter("@Position", SqlDbType.VarChar, 100),
new SqlParameter("@ShortName", SqlDbType.VarChar, 50),
new SqlParameter("@Sort", SqlDbType.Int, 4)
};
parameters[0].Value = r.Id;
parameters[1].Value = r.Latitude;
parameters[2].Value = r.Level;
parameters[3].Value = r.Longitude;
parameters[4].Value = r.Name;
parameters[5].Value = r.Pid;
parameters[6].Value = r.Position;
parameters[7].Value = r.ShortName;
parameters[8].Value = r.Sort;
DbHelperSQL.ExecuteSql(sb.ToString(), parameters);
}
/// <summary>
/// 增加一条数据,及其子表数据
/// </summary>
public int Add(Model.Area model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dt_Area(");
strSql.Append("title,parent,code,sort)");
strSql.Append(" values (");
strSql.Append("@title,@parent,@code,@sort)");
strSql.Append(";set @ReturnValue= @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@title", SqlDbType.NVarChar, 100),
new SqlParameter("@parent", SqlDbType.Int, 4),
new SqlParameter("@code", SqlDbType.NVarChar, 50),
new SqlParameter("@sort", SqlDbType.NVarChar, 50),
new SqlParameter("@ReturnValue", SqlDbType.Int)
};
parameters[0].Value = model.title;
parameters[1].Value = model.parent;
parameters[2].Value = model.code;
parameters[3].Value = model.sort;
parameters[4].Direction = ParameterDirection.Output;
List <CommandInfo> sqllist = new List <CommandInfo>();
CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters);
sqllist.Add(cmd);
DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist);
return((int)parameters[4].Value);
}
public ManageDiagnosticsWindow(Model.Area selectedArea)
{
this.InitializeComponent();
_selectedArea = selectedArea;
lblAreaName.ToolTip = lblAreaName.Content = selectedArea.Name;
UpdateGrid();
}
private void ShowInfo(int _id)
{
DAL.AreaDal bll = new DAL.AreaDal();
Model.Area model = bll.GetModel(_id);
txtTitle.Text = model.title;
txtSortId.Text = model.sort;
ddlParent.SelectedValue = model.parent.ToString();
txtCode.Text = model.code;
}
public AddEditAreaModal(Model.Area selectedArea)
{
this.InitializeComponent();
_selectedArea = selectedArea;
_isUpdateArea = selectedArea != null;
if (_isUpdateArea)
PrepareWindowForUpdates();
}
public void UpdateArea(Model.Area area)
{
using (var db = new LiteDatabase(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "MyData.db")))
{
var col = db.GetCollection <Model.Area>("Area");
var data = col.FindById(area.Id);
data.Description = area.Description;
data.DateUpdated = DateTime.Now;
data.Title = area.Title;
col.Upsert(data);
}
}
public AddEditDiagnosticModal(Model.Diagnostic selectedDiagnostic, Model.Area selectedArea)
{
this.InitializeComponent();
_selectedArea = selectedArea;
_selectedDiagnostic = selectedDiagnostic;
_isUpdateDiagnostic = selectedDiagnostic != null;
btnSearchImage1.Tag = btnRemoveImage1.Tag = diagnosticImage1;
btnSearchImage2.Tag = btnRemoveImage2.Tag = diagnosticImage2;
if (_isUpdateDiagnostic)
PrepareWindowForUpdates();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Area GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from dt_Area ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Model.Area model = new Model.Area();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
#region 父表信息
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]["title"] != null && ds.Tables[0].Rows[0]["title"].ToString() != "")
{
model.title = ds.Tables[0].Rows[0]["title"].ToString();
}
if (ds.Tables[0].Rows[0]["parent"] != null && ds.Tables[0].Rows[0]["parent"].ToString() != "")
{
model.parent = int.Parse(ds.Tables[0].Rows[0]["parent"].ToString());
}
if (ds.Tables[0].Rows[0]["code"] != null && ds.Tables[0].Rows[0]["code"].ToString() != "")
{
model.code = ds.Tables[0].Rows[0]["code"].ToString();
}
if (ds.Tables[0].Rows[0]["sort"] != null && ds.Tables[0].Rows[0]["sort"].ToString() != "")
{
model.sort = ds.Tables[0].Rows[0]["sort"].ToString();
}
#endregion 父表信息end
return(model);
}
else
{
return(null);
}
}
private bool DoEdit(int _id)
{
bool result = true;
DAL.AreaDal bll = new DAL.AreaDal();
Model.Area model = bll.GetModel(_id);
model.title = txtTitle.Text.Trim();
model.sort = txtSortId.Text.Trim();
model.parent = int.Parse(ddlParent.SelectedValue.Trim());
model.code = txtCode.Text.Trim();
if (!bll.Update(model))
{
result = false;
}
return(result);
}
private bool DoAdd()
{
bool result = true;
Model.Area model = new Model.Area();
DAL.AreaDal bll = new DAL.AreaDal();
model.title = txtTitle.Text.Trim();
model.sort = txtSortId.Text.Trim();
model.parent = int.Parse(ddlParent.SelectedValue.Trim());
model.code = txtCode.Text.Trim();
if (bll.Add(model) < 1)
{
result = false;
}
return(result);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.Area model)
{
using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update dt_Area set ");
strSql.Append("title=@title,");
strSql.Append("parent=@parent,");
strSql.Append("code=@code,");
strSql.Append("sort=@sort");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@title", SqlDbType.NVarChar, 100),
new SqlParameter("@parent", SqlDbType.Int, 4),
new SqlParameter("@code", SqlDbType.NVarChar, 50),
new SqlParameter("@sort", SqlDbType.NVarChar, 50),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.title;
parameters[1].Value = model.parent;
parameters[2].Value = model.code;
parameters[3].Value = model.sort;
parameters[4].Value = model.id;
DbHelperSQL.ExecuteSql(conn, trans, strSql.ToString(), parameters);
trans.Commit();
}
catch
{
trans.Rollback();
return(false);
}
}
}
return(true);
}
public List <Model.Area> CityList(int code)
{
Model.Area model = new Model.Area();
List <Model.Area> list = new List <Model.Area>();
DataTable dt = cd.GetDatalistpageByParentID(code).Tables[0];;
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Model.Area cm = new Model.Area();
cm.id = int.Parse(dt.Rows[i]["id"].ToString());
cm.title = dt.Rows[i]["title"].ToString();
cm.code = dt.Rows[i]["code"].ToString();
list.Add(cm);
}
}
return(list);
}
public int Update(Model.Area r)
{
if (null == r)
{
throw new NullReferenceException("null obj,the parameter rs is null");
}
StringBuilder sb = new StringBuilder();
sb.Append("update Area set Name=@Name,Pid=@Pid,Latitude=@Latitude,Longitude=@Longitude,Level=@Level,Position=@Position,ShortName=@ShortName,Sort=@Sort");
sb.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4),
new SqlParameter("@Latitude", SqlDbType.Char, 15),
new SqlParameter("@Level", SqlDbType.Int, 4),
new SqlParameter("@Longitude", SqlDbType.Char, 15),
new SqlParameter("@Name", SqlDbType.VarChar, 50),
new SqlParameter("@Pid", SqlDbType.Int, 4),
new SqlParameter("@Position", SqlDbType.VarChar, 100),
new SqlParameter("@ShortName", SqlDbType.VarChar, 50),
new SqlParameter("@Sort", SqlDbType.Int, 4)
};
parameters[0].Value = r.Id;
parameters[1].Value = r.Latitude;
parameters[2].Value = r.Level;
parameters[3].Value = r.Longitude;
parameters[4].Value = r.Name;
parameters[5].Value = r.Pid;
parameters[6].Value = r.Position;
parameters[7].Value = r.ShortName;
parameters[8].Value = r.Sort;
return(DbHelperSQL.ExecuteSql(sb.ToString(), parameters));
}
public string GetA(string id)
{
string AreaName = string.Empty;
string cityName = string.Empty;
if (!string.IsNullOrEmpty(id))
{
AreaDal dal = new AreaDal();
Model.Area model = new Model.Area();
model = dal.GetModel(int.Parse(id));
if (model != null)
{
AreaName = model.title;
int partentID = model.parent;
Model.Area City = dal.GetModel(partentID);
if (City != null)
{
cityName = City.title;
}
}
}
return(cityName + "-" + AreaName);
}
public static int?fnc_getAreaId(string areaName, bool add, bool notifNotExist)
{
if (string.IsNullOrEmpty(areaName))
{
return(null);
}
//if (areaName == "واگن بدون بار") return -1;
using (var entityLogistic = new Model.logisticEntities())
{
var entryArea = entityLogistic.Areas.FirstOrDefault(o => o.areaName == areaName);
if (entryArea == null)
{
string strNotif = "";
if (notifNotExist)
{
strNotif = "areaName = " + areaName + " does not exist in Areas table." + (add ? "? It will be created" : "");
}
if (add)
{
entryArea = new Model.Area();
entryArea.areaName = areaName;
entityLogistic.Areas.Add(entryArea);
entityLogistic.SaveChanges();
return(entryArea.Id);
}
else
{
return(null);
}
}
else
{
return(entryArea.Id);
}
}
}
/// <summary>
/// 保存数据字典数据
/// </summary>
/// <returns></returns>
public ActionResult Save(Model.Area model)
{
JsonObject json = new JsonObject();
StringBuilder sbErro = new StringBuilder();
if (string.IsNullOrEmpty(model.AreaName))
{
sbErro.Append(",区域名称不能为空");
}
if (sbErro.Length > 0)
{
json.Status = JsonObject.STATUS_FAIL;
json.ErroMessage = sbErro.ToString().Substring(1);
return(Json(json));
}
//如果ID为空，则是添加
if (string.IsNullOrEmpty(model.AreaID))
{
//DepartmentName 唯一
List <Model.Area> modelExistsList = BLL.GetModelList("AreaName='" + model.AreaName + "'");
if (modelExistsList != null && modelExistsList.Count > 0)
{
json.Status = JsonObject.STATUS_FAIL;
json.ErroMessage = "添加失败,此数据已存在";
return(Json(json));
}
model.CreateTime = DateTime.Now;
model.CreateBy = CurrentUser.User.Userinfo.UserID;
model.AreaID = Guid.NewGuid().ToString();
bool res = BLL.Add(model);
if (res)
{
json.Status = JsonObject.STATUS_SUCCESS;
json.Message = "添加成功";
return(Json(json));
}
else
{
json.Status = JsonObject.STATUS_FAIL;
json.ErroMessage = "添加失败";
return(Json(json));
}
}
else
{
//value 和 type 唯一确定一个text值
List <Model.Area> modelExistsList = BLL.GetModelList("AreaName='" + model.AreaName + "' and AreaID!='" + model.AreaID + "'");
if (modelExistsList != null && modelExistsList.Count > 0)
{
json.Status = JsonObject.STATUS_FAIL;
json.ErroMessage = "添加失败,此数据已存在";
return(Json(json));
}
Model.Area modelOld = BLL.GetModel(model.AreaID);
if (modelOld == null)
{
json.Status = JsonObject.STATUS_FAIL;
json.ErroMessage = "数据不存在";
return(Json(json));
}
modelOld.AreaName = model.AreaName;
modelOld.OrderBy = model.OrderBy;
modelOld.Remark = model.Remark;
modelOld.UpdateTime = DateTime.Now;
modelOld.UpdateBy = CurrentUser.User.Userinfo.UserID;
bool res = BLL.Update(modelOld);
if (res)
{
json.Status = JsonObject.STATUS_SUCCESS;
json.Message = "修改成功";
return(Json(json));
}
else
{
json.Status = JsonObject.STATUS_FAIL;
json.ErroMessage = "修改失败";
return(Json(json));
}
}
}
/// <summary>
/// DAL_GetAddress():读取Area表
/// </summary>
/// <returns>存放已赋过值的泛型集合</returns>
public List<Model.Area> GetAddress()
{
DataTable dt = SqlHelper.ExecuteDataTable("select * from Area");
List<Model.Area> areaList = new List<Model.Area>();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i]; //遍历DataTable表中的每一行
Model.Area modelArea = new Model.Area(); //创建实体类对象
modelArea.ID = Convert.ToInt32(dr[0]); //第一列：ID
modelArea.Name = dr[1].ToString(); //第二列：Name
modelArea.UID = Convert.ToInt32(dr[2]); //第三列：UID
//把赋过值的实体类对象modelArea，存到泛型集合areaList中：
areaList.Add(modelArea);
}
}
return areaList;
}
private void LoadNoteBook(int ID)
{
AreaDal dal = new AreaDal();
Model.Area modelArea = new Model.Area();
Model.dt_feedback Model = bllNot.GetModel(ID);
chkPointValue.Value = Model.user_Function;
if (Model.user_Function == "是")
{
chkPoint.Checked = true;
}
else
{
chkPoint.Checked = false;
}
lblName.Text = Model.user_name;
lblsex.Text = Model.user_qq;
lblPhone.Text = Model.user_tel;
lbluser_tel.Text = Model.title;
lblEmail.Text = Model.user_email;
lblContent.Text = Model.content;
lblZhuZhi.Text = Model.zhuzhi;
string DiDian = Model.user_Address;
string Address = string.Empty;
if (!string.IsNullOrEmpty(DiDian))
{
if (DiDian.IndexOf('|') > 0)
{
string[] addList = DiDian.Split('|');
for (int i = 0; i < addList.Length; i++)
{
if (!string.IsNullOrEmpty(addList[i].ToString()))
{
int AreaID = int.Parse(addList[i].ToString());
modelArea = dal.GetModel(AreaID);
if (modelArea != null)
{
if (i > 0)
{
Address += "-";
}
Address += modelArea.title;
}
}
}
}
}
lblAdress.Text = Address;
lblClassName.Text = Model.user_Class;
//lblFunction.Text = Model.user_Function;
lblMoney.Text = Model.user_Money.ToString();
lblMianJi.Text = Model.user_MianJi.ToString();
if (Model.zhuzhi == "介紹房屋出售")
{
p1.Visible = true;
}
else
{
p1.Visible = false;
}
lblReplayContent.Text = Model.reply_content;
}
public JsonObject Import(DataTable dt, DataTable dtTemplate)
{
JsonObject json = new JsonObject();
if (dt == null || dt.Rows.Count == 0)
{
json.Status = JsonObject.STATUS_FAIL;
json.ErroMessage = "数据为空";
return(json);
}
if (dtTemplate == null)
{
json.Status = JsonObject.STATUS_FAIL;
json.ErroMessage = "数据导入失败，模板错误，请联系管理员";
return(json);
}
string checkTemplate = CommonHelper.Matching(dt, dtTemplate);
if (checkTemplate != "")
{
json.Status = JsonObject.STATUS_FAIL;
json.ErroMessage = "数据导入失败，" + checkTemplate + ",请下载最新模板";
return(json);
}
StringBuilder sbErro = new StringBuilder();
List <Model.Area> list = new List <Model.Area>();
int parmInt = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i < dtTemplate.Rows.Count)
{
//模板前几列不执行
continue;
}
bool checkNul = true;;
for (int j = 0; j < dt.Columns.Count; j++)
{
if (dt.Rows[i][j] != null && dt.Rows[i][j].ToString() != "")
{
checkNul = false;
break;
}
}
if (checkNul)
{//如果行数据为空则忽略
continue;
}
StringBuilder sbErroI = new StringBuilder();
//如果第一列为~开头，则为示例数据，不导入
if (dt.Rows[i][0] != null && dt.Rows[i][0].ToString() != "" && dt.Rows[i][0].ToString().Substring(0, 1) == "~")
{
continue;
}
Model.Area model = new Model.Area();
if (dt.Rows[i]["区域名称"] != null && dt.Rows[i]["区域名称"].ToString().Trim() != "")
{
model.AreaName = dt.Rows[i]["区域名称"].ToString().Trim();
}
else
{
sbErroI.Append(",区域名称不能为空");
}
if (dt.Rows[i]["排序"] != null && dt.Rows[i]["排序"].ToString().Trim() != "")
{
if (int.TryParse(dt.Rows[i]["排序"].ToString().Trim(), out parmInt))
{
model.OrderBy = parmInt;
}
else
{
sbErroI.Append(",排序[" + dt.Rows[i]["排序"].ToString().Trim() + "]必须为数字");
}
}
if (dt.Rows[i]["备注"] != null && dt.Rows[i]["备注"].ToString().Trim() != "")
{
model.Remark = dt.Rows[i]["备注"].ToString().Trim();
}
if (sbErroI.Length > 0)
{
sbErro.Append(",第" + (i + 2) + "行数据：" + sbErroI.ToString().Substring(1));
}
list.Add(model);
}
//如果有错误信息
if (sbErro.Length > 0)
{
json.Status = JsonObject.STATUS_FAIL;
json.ErroMessage = sbErro.ToString().Substring(1);
return(json);
}
if (list.Count == 0)
{
json.Status = JsonObject.STATUS_FAIL;
json.ErroMessage = "数据为空";
return(json);
}
try
{
int addCount = 0;
int updateCount = 0;
string userId = CurrentUser.User.Userinfo.UserID;
DateTime timeNow = DateTime.Now;
for (int i = 0; i < list.Count; i++)
{
List <Model.Area> modelExistsList = BLL.GetModelList("AreaName='" + list[i].AreaName + "' ");
if (modelExistsList != null && modelExistsList.Count > 0)
{
list[i].AreaID = modelExistsList[0].AreaID;
list[i].AreaName = modelExistsList[0].AreaName;
list[i].CreateBy = modelExistsList[0].CreateBy;
list[i].CreateTime = modelExistsList[0].CreateTime;
list[i].UpdateBy = userId;
list[i].UpdateTime = timeNow;
BLL.Update(list[i]);
updateCount++;
}
else
{
list[i].CreateBy = userId;
list[i].CreateTime = timeNow;
list[i].AreaID = Guid.NewGuid().ToString();
BLL.Add(list[i]);
addCount++;
}
}
json.Status = JsonObject.STATUS_SUCCESS;
json.Message = "导入成功";
if (addCount > 0)
{
json.Message += "，添加" + addCount + "条数据";
}
if (updateCount > 0)
{
json.Message += "，修改" + updateCount + "条数据";
}
return(json);
}
catch (Exception ex)
{
json.Status = JsonObject.STATUS_FAIL;
json.ErroMessage = "导入失败，失败原因：" + ex.Message;
return(json);
}
finally
{
}
}
