public void AreaEdit(AreaInfo areainfo) { try { if (base.sqlcon.State == ConnectionState.Closed) { base.sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("AreaEdit", base.sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam7 = new SqlParameter(); sprmparam7 = sccmd.Parameters.Add("@areaId", SqlDbType.Decimal); sprmparam7.Value = areainfo.AreaId; sprmparam7 = sccmd.Parameters.Add("@areaName", SqlDbType.VarChar); sprmparam7.Value = areainfo.AreaName; sprmparam7 = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam7.Value = areainfo.Narration; sprmparam7 = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime); sprmparam7.Value = areainfo.ExtraDate; sprmparam7 = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam7.Value = areainfo.Extra1; sprmparam7 = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam7.Value = areainfo.Extra2; sccmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { base.sqlcon.Close(); } }
public void OpenWindow(AreaInfo areaInfo) { areaName.text = areaInfo.areaName; areaDiscription.text = areaInfo.areaDescription; StartCoroutine(OpenWindow()); StartCoroutine(CloseWindow()); }
public AreaInfo AreaFill(decimal decAreaId) { AreaInfo infoArea = new AreaInfo(); SqlDataReader sdrreader = null; try { if (base.sqlcon.State == ConnectionState.Closed) { base.sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("AreaWithNarrationView", base.sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam2 = new SqlParameter(); sprmparam2 = sccmd.Parameters.Add("@areaId", SqlDbType.Decimal); sprmparam2.Value = decAreaId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { infoArea.AreaId = Convert.ToDecimal(((DbDataReader)sdrreader)[0].ToString()); infoArea.AreaName = ((DbDataReader)sdrreader)[1].ToString(); infoArea.Narration = ((DbDataReader)sdrreader)[2].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); base.sqlcon.Close(); } return(infoArea); }
/// <summary> /// add /// </summary> /// <param name="AreaInfo"></param> /// <returns></returns> public int Add(AreaInfo model) { var str = GetInsertStr(model) + " select @@identity"; var dict = GetParameters(model); return(Convert.ToInt32(SqlHelperHere.ExecuteScalar(str, dict))); }
public decimal AreaAddWithIdentity(AreaInfo areainfo) { decimal decAreaId = 0m; try { if (base.sqlcon.State == ConnectionState.Closed) { base.sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("AreaAdd", base.sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam5 = new SqlParameter(); sprmparam5 = sccmd.Parameters.Add("@areaName", SqlDbType.VarChar); sprmparam5.Value = areainfo.AreaName; sprmparam5 = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam5.Value = areainfo.Narration; sprmparam5 = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam5.Value = areainfo.Extra1; sprmparam5 = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam5.Value = areainfo.Extra2; object objAreaId = sccmd.ExecuteScalar(); decAreaId = ((objAreaId == null) ? 0m : decimal.Parse(objAreaId.ToString())); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { base.sqlcon.Close(); } return(decAreaId); }
public AddMember() { Task.Factory.StartNew(() => { var _machineInfo = Global.MachineSettings.MachineInformations; AreaInfoParams _params = new AreaInfoParams() { PID = 1, StoreId = _machineInfo.StoreId, MachineSn = _machineInfo.MachineSn, CID = _machineInfo.CompanyId }; var result = ApiManager.Post <AreaInfoParams, ApiRetrunResult <IEnumerable <AreaInfo> > >(@"api/GetAreas", _params); Application.Current.Dispatcher.Invoke(new Action(() => { if (result.Code == "200") { Provinces = new AreaInfo[] { new AreaInfo() { Title = "请选择省份", AreaID = -1 } }.Concat(result.Result.OrderBy(o => o.OrderNum)); } else { Provinces = new AreaInfo[] { new AreaInfo() { Title = "请选择省份" } }; } })); }); }
private bool PrintRow(AreaInfo area, int iPrintQty, ref string sPrintCode) { string strOnce = ""; if (area.AreaType == 2) { strOnce = Print_Func.GetTempAreaPrintStr(area.AreaNo); } else { strOnce = Print_Func.GetAreaPrintStr(area.AreaNo); } if (string.IsNullOrEmpty(strOnce)) { return(Common.Common_Func.ErrorMessage("货位标签 " + area.AreaName + " 打印失败", "打印失败")); } string strContent = string.Empty; for (int i = 1; i <= iPrintQty; i++) { strContent += strOnce; } sPrintCode += strContent; return(true); }
/// <summary> /// area grid cell double click for update /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgvArea_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { try { if (e.RowIndex != -1) { string strArea = dgvArea.CurrentRow.Cells["dgvtxtarea"].Value.ToString(); if (strArea != "NA") { AreaInfo infoArea = new AreaInfo(); AreaSP spArea = new AreaSP(); infoArea = spArea.AreaFill(Convert.ToDecimal(dgvArea.CurrentRow.Cells[1].Value.ToString())); txtAreaName.Text = infoArea.AreaName; txtNarration.Text = infoArea.Narration; btnSave.Text = "Update"; btnDelete.Enabled = true; txtAreaName.Focus(); decAreaId = Convert.ToDecimal(dgvArea.CurrentRow.Cells[1].Value.ToString()); } else { Messages.WarningMessage("NA Area cannot update or delete"); Clear(); } } } catch (Exception ex) { MessageBox.Show("AR16" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// 添加省/市/区信息 /// </summary> /// <param name="area"></param> /// <returns></returns> public int InsertProArea(AreaInfo area) { string sql = ""; string strGUID = System.Guid.NewGuid().ToString().ToUpper(); try { sql = "INSERT INTO AreaInfo(Area,CreateTime,Pid,CityType,ProID,City_code,Aguid)VALUES(@Area,GETDATE(),@Pid,@CityType,@ProID,@City_code,@Aguid);select @@Identity;"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@Area", area.Area), new SqlParameter("@Pid", area.Pid), new SqlParameter("@CityType", area.CityType), new SqlParameter("@ProID", area.ProID), new SqlParameter("@City_code", area.City_code), new SqlParameter("@Aguid", strGUID) }; int result = Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.DBConnStr, CommandType.Text, sql, param)); return(result); } catch (Exception ex) { Logger.ErrorLog(ex, new Dictionary <string, string>() { { "Function", "SystemDAL.InsertProArea(AreaInfo area)" }, { "SQL", sql } }); throw ex; } }
public static async Task <bool> TakeQuestReward(AreaInfo area, TownNpc npc, string dialog, string questId = null, string book = null) { if (area.IsCurrentArea) { if (book != null && PlayerHasQuestItem(book)) { if (!await UseQuestItem(book)) { ErrorManager.ReportError(); } } else { var reward = questId != null?Settings.Instance.GetRewardForQuest(questId) : null; if (!await npc.TakeReward(reward, dialog)) { ErrorManager.ReportError(); } } return(false); } await Travel.To(area); return(true); }
private int CreateMagicArea(Vector3 position, float radius, string title = "-1", string description = "-1", bool enabled = true) { int id = -1; if (position != Vector3.zero) { AreaInfo Area = new AreaInfo(); Area.iID = GetRandomNumber(0, 25); if (title == "-1") { title = "Area" + Area.iID.ToString(); } Area.tTitle = title; Area.tDescription = description; Area.uEnabled = enabled; Area.iCount = 0; Area.fMinX = position.x; Area.fMinY = position.y; Area.fMinZ = position.z; Area.fRadius = radius; Area.bGod = false; Area.tKit = ""; Area.bCanResearch = false; Area.bResetInv = true; Area.bRemoveEntities = true; Area.iEntityExpire = Convert.ToInt32(Config["Settings", "DefaultExpire"]); id = Area.iID; MAData.Areas.Add(Area.iID, Area); SaveData(); } return(id); }
// GET api/<controller> public Hashtable Get() { Hashtable res = new Hashtable(); List <Hashtable> ls = new List <Hashtable>(); int admin = UserInfo.GetUserIdFromCookie(HttpContext.Current); string auth = UserInfo.GetAuthFromCookie(HttpContext.Current); AreaInfo ai = new AreaInfo(); if (auth.Equals("root")) { foreach (area_admin i in ai.GetAreaInfo(0, 10, admin)) // admin = 1 { Hashtable ht = new Hashtable(); ht.Add("id", i.id_area_admin); ht.Add("name", i.area_name); ls.Add(ht); } } else { Hashtable ht = new Hashtable(); ht.Add("id", admin); ht.Add("name", ai.GetAreaName(admin)); ls.Add(ht); } res.Add("code", 20000); res.Add("data", ls); return(res); }
/// <summary> /// update /// </summary> /// <param name="AreaInfo"></param> /// <returns></returns> public void Update(AreaInfo model) { var str = GetUpdateStr(model); var dict = GetParameters(model); SqlHelper.Instance.ExcuteNon(str, dict); }
// GET api/<controller>/5 public Hashtable Get(int id) { Hashtable ht = new Hashtable(); Hashtable data = new Hashtable(); AreaInfo ai = new AreaInfo(); if (ai.HasUsed(id)) { ht.Add("code", 40000); data.Add("message", "部门已被使用,无法删除"); } else { try { if (ai.DeleteOne(id)) { ht.Add("code", 20000); data.Add("status", "success"); } else { ht.Add("code", 40000); data.Add("message", "failed"); } } catch (Exception e) { ht.Add("code", 40000); data.Add("message", e.Message); } } ht.Add("data", data); return(ht); }
/// <summary> /// 添加一级信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnAddOne_Click(object sender, EventArgs e) { string pName = this.txtOne.Text.Trim(); string pChar = this.txtChar.Text.Trim(); if (pName.Length == 0 || pChar.Length == 0) { ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('名称和字符信息不能为空!');", true); return; } AreaInfo item = new AreaInfo(); item.areaName = pName; item.charIndex = pChar; item.parentId = 0; item.status = 0; item.remark = ""; int num = AreaInfoService.Add(item); if (num > 0) { ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('添加成功!');", true); } LoadOneInfo(); }
public void Load(int?sysNo, EventHandler <RestClientEventArgs <AreaInfoVM> > callback) { string relativeUrl = "/CommonService/Area/Load/" + sysNo; if (sysNo.HasValue) { restClient.Query <AreaInfo>(relativeUrl, (obj, args) => { if (args.FaultsHandle()) { return; } AreaInfo entity = args.Result; AreaInfoVM _viewModel = null; if (entity == null) { _viewModel = new AreaInfoVM(); } else { _viewModel = entity.Convert <AreaInfo, AreaInfoVM>(); } callback(obj, new RestClientEventArgs <AreaInfoVM>(_viewModel, restClient.Page)); }); } else { callback(new Object(), new RestClientEventArgs <AreaInfoVM>(new AreaInfoVM(), restClient.Page)); } }
/// <summary> /// 插入 /// </summary> /// <param name="areainfo"></param> /// <returns>是否成功</returns> public string GetInsertStr(AreaInfo areainfo) { StringBuilder part1 = new StringBuilder(); StringBuilder part2 = new StringBuilder(); if (areainfo.areaName != null) { part1.Append("areaName,"); part2.Append("@areaName,"); } if (areainfo.shortName != null) { part1.Append("shortName,"); part2.Append("@shortName,"); } if (areainfo.remark != null) { part1.Append("remark,"); part2.Append("@remark,"); } StringBuilder sql = new StringBuilder(); sql.Append("insert into areainfo(").Append(part1.ToString().Remove(part1.Length - 1)).Append(") values (").Append(part2.ToString().Remove(part2.Length - 1)).Append(")"); return(sql.ToString()); }
private bool SaveData() { bsArea.EndEdit(); _area.AreaNo = string.Format("{0}-{1}", txtAreaNoLeft.Text, txtAreaNoRight.Text); _area.AreaName = txtAreaName.Text; if (!CheckInput()) { return(false); } //_area.AreaStatus = 1; //_area.IsDel = 1; _area.CreateTime = DateTime.Today; string strErr = string.Empty; if (Basic_Func.SaveArea(ref _area, ref strErr)) { Common.Common_Func.ErrorMessage("货位保存成功!", "保存成功"); bsArea.DataSource = _area; InitForm(); _back = Common.Common_Func.ConvertToModel <AreaInfo>(_area); return(true); } else { Common.Common_Func.ErrorMessage(strErr, "保存失败"); bsArea.DataSource = _area; return(false); } }
public int Insert(AreaInfo areaInfo) { using (var conn = GetConnection()) { conn.Open(); using (var trans = conn.BeginTransaction()) { try { var parentAreaInfo = GetAreaInfo(areaInfo.ParentId); InsertWithTrans(parentAreaInfo, areaInfo, trans); trans.Commit(); } catch { trans.Rollback(); throw; } } } AreaManager.ClearCache(); return(areaInfo.Id); }
public static int Insert(AreaInfo areaInfo) { string sqlString = $@"INSERT INTO {TableName} ({nameof(AreaInfo.DeliveryId)}, {nameof(AreaInfo.Cities)}, {nameof(AreaInfo.StartStandards)}, {nameof(AreaInfo.StartFees)}, {nameof(AreaInfo.AddStandards)}, {nameof(AreaInfo.AddFees)}) VALUES (@{nameof(AreaInfo.DeliveryId)}, @{nameof(AreaInfo.Cities)}, @{nameof(AreaInfo.StartStandards)}, @{nameof(AreaInfo.StartFees)}, @{nameof(AreaInfo.AddStandards)}, @{nameof(AreaInfo.AddFees)})"; var parameters = new List <IDataParameter> { Context.DatabaseApi.GetParameter(nameof(areaInfo.DeliveryId), areaInfo.DeliveryId), Context.DatabaseApi.GetParameter(nameof(areaInfo.Cities), areaInfo.Cities), Context.DatabaseApi.GetParameter(nameof(areaInfo.StartStandards), areaInfo.StartStandards), Context.DatabaseApi.GetParameter(nameof(areaInfo.StartFees), areaInfo.StartFees), Context.DatabaseApi.GetParameter(nameof(areaInfo.AddStandards), areaInfo.AddStandards), Context.DatabaseApi.GetParameter(nameof(areaInfo.AddFees), areaInfo.AddFees) }; return(Context.DatabaseApi.ExecuteNonQueryAndReturnId(TableName, nameof(AreaInfo.Id), Context.ConnectionString, sqlString, parameters.ToArray())); }
public int AddNewArea(AreaInfo areaInfo) { string strSQL = "INSERT INTO Areas VALUES(@AreaID, @AreaName, @Note)"; int nRow = 0; try { nRow = dB.ExecuteNonQuery(CommandType.Text, strSQL, new SqlParameter { ParameterName = "@AreaID", Value = areaInfo.AreaID }, new SqlParameter { ParameterName = "@AreaName", Value = areaInfo.AreaName }, new SqlParameter { ParameterName = "@Note", Value = areaInfo.Note } ); } catch (SqlException ex) { throw ex; } return(nRow); }
private AreaInfo FindArea() { MapInfo maps = ExtraMap(); AreaInfo area = maps.list.Find(a => (a.isNew || a.order == 1) && ((a.stock > 0 && a.status == 1) || a.status == 0)); return(area); }
private static AreaInfo GetAreaInfo(IDataRecord rdr) { if (rdr == null) { return(null); } var areaInfo = new AreaInfo(); var i = 0; areaInfo.Id = rdr.IsDBNull(i) ? 0 : rdr.GetInt32(i); i++; areaInfo.DeliveryId = rdr.IsDBNull(i) ? 0 : rdr.GetInt32(i); i++; areaInfo.Cities = rdr.IsDBNull(i) ? string.Empty : rdr.GetString(i); i++; areaInfo.StartStandards = rdr.IsDBNull(i) ? 0 : rdr.GetInt32(i); i++; areaInfo.StartFees = rdr.IsDBNull(i) ? 0 : rdr.GetDecimal(i); i++; areaInfo.AddStandards = rdr.IsDBNull(i) ? 0 : rdr.GetInt32(i); i++; areaInfo.AddFees = rdr.IsDBNull(i) ? 0 : rdr.GetDecimal(i); return(areaInfo); }
public JsonResult Add(AreaInfo model) { if (string.IsNullOrEmpty(model.Owner) || string.IsNullOrEmpty(model.Owner)) { return(Json(new ResponseMessage() { IsSuccess = false, ErrorCode = (int)ResponseIntValue.Fail, Message = "请输入必填字段" })); } model.CreateUser = UserSession.Current.UserCode; model.CreateTime = DateTime.Now; model.LastModifiedUser = UserSession.Current.UserCode; model.LastModifiedTime = DateTime.Now; var result = (new YhAreainfoManager()).Add(model); if (result > 0) { return(Json(new ResponseMessage() { IsSuccess = true })); } else { return(Json(new ResponseMessage() { IsSuccess = false, ErrorCode = (int)result, Message = "新增失败" })); } }
void LoadRandomStage() { AreaInfo SaveAreaInfo = new AreaInfo(); if (!Isbonus) { for (int i = 0; i < 4; i++) { StageInfo SaveStage = RandomStagesInfos[SaveRandomIndex[i]]; if (SaveAreaInfo.StageInfos.Contains(SaveStage)) { while (SaveAreaInfo.StageInfos.Contains(SaveStage)) { SaveStage = RandomStagesInfos[UnityEngine.Random.Range(0, RandomStagesInfos.Count)]; } } SaveStage.StageNum = i; SaveAreaInfo.AreaNumber = ClearedStandCount; SaveAreaInfo.StageInfos.Add(SaveStage); } } else { StageInfo SaveStage = RandomBonusStagesInfos[SaveRandomIndex[0]]; SaveStage.StageNum = 0; SaveAreaInfo.AreaNumber = ClearedBonusCount; SaveAreaInfo.StageInfos.Add(SaveStage); } CurrentArea = SaveAreaInfo; }
public static List <AreaInfo> Areas <T>(this IList <T> list, Func <T, int> getPosition, Func <T, double> getValue) { var anonArea = new AreaInfo { Start = getPosition(list[0]), Stop = getPosition(list[0]), Area = 0 }; var areas = new List <AreaInfo>() { anonArea }; list.Aggregate((p, n) => { var nValue = getValue(n); var nPosition = getPosition(n); if (nValue.Sign() == getValue(p).Sign()) { var area = areas.LastBC(); area.Area += nValue; area.Stop = nPosition; } else { areas.Add(new AreaInfo(nPosition, nPosition, nValue)); } return(n); }); return(areas); }
/// <summary> /// 编辑省/市/区信息 /// </summary> /// <param name="area"></param> /// <returns></returns> public bool UpdateProArea(AreaInfo area) { string sql = ""; try { sql = "UPDATE AreaInfo SET Area = @Area,City_code=@City_code WHERE ID=@ID"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@Area", area.Area), new SqlParameter("@ID", area.ID), new SqlParameter("@City_code", area.City_code) }; int result = SqlHelper.ExecuteNonQuery(SqlHelper.DBConnStr, CommandType.Text, sql, param); return(result > 0 ? true : false); } catch (Exception ex) { Logger.ErrorLog(ex, new Dictionary <string, string>() { { "Function", "SystemDAL.UpdateProArea(AreaInfo area)" }, { "SQL", sql } }); throw ex; } }
/// <summary> /// 通过地区编号删除数据库对应地区。 /// </summary> /// <param name="ai">设置好AreaNum属性的AreaInfo对象</param> /// <param name="returnMessage">返回的操作信息</param> /// <returns></returns> public bool DeleteAreaInfo(AreaInfo ai, out string returnMessage) { if (areaInfoList.Count == 0) { returnMessage = "数据库为空,删除失败"; return(false); } foreach (AreaInfo a in areaInfoList) { if (a.AreaNum == ai.AreaNum) { if (new AreaInfoDal().DeleteAreaInfoByAreaNum(ai)) { returnMessage = "删除成功"; areaInfoList = new AreaInfoDal().GetAreaInfoList(); return(true); } else { returnMessage = "删除异常,请稍后再试"; return(false); } } } returnMessage = "要删除的对象不存在"; return(false); }
public bool AreaUpdate(AreaInfo areainfo) { bool isEdit = false; try { if (base.sqlcon.State == ConnectionState.Closed) { base.sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("AreaEditParticularField", base.sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam4 = new SqlParameter(); sprmparam4 = sccmd.Parameters.Add("@areaId", SqlDbType.Decimal); sprmparam4.Value = areainfo.AreaId; sprmparam4 = sccmd.Parameters.Add("@areaName", SqlDbType.VarChar); sprmparam4.Value = areainfo.AreaName; sprmparam4 = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam4.Value = areainfo.Narration; int inAffectedRows = sccmd.ExecuteNonQuery(); isEdit = (inAffectedRows > 0 && true); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { base.sqlcon.Close(); } return(isEdit); }
public void QueryCurrentAreaStructure_Old(int sysNo, out AreaInfo currentAreaInfo, out List <AreaInfo> proviceList, out List <AreaInfo> cityList, out List <AreaInfo> districtList) { #region asseign default value currentAreaInfo = null; proviceList = null; cityList = null; districtList = null; #endregion asseign default value currentAreaInfo = this.OldLoad(sysNo); proviceList = this.QueryProvinceAreaList(); if (currentAreaInfo != null) { if (currentAreaInfo.ProvinceSysNo == null && currentAreaInfo.CitySysNo == null) { cityList = this.QueryCityAreaListByProvinceSysNo(currentAreaInfo.SysNo.GetValueOrDefault()); districtList = new List <AreaInfo>(); } else if (currentAreaInfo.ProvinceSysNo != null && currentAreaInfo.CitySysNo == null) { cityList = this.QueryCityAreaListByProvinceSysNo(currentAreaInfo.ProvinceSysNo.GetValueOrDefault()); districtList = this.QueryDistrictAreaListByCitySysNo(currentAreaInfo.SysNo.GetValueOrDefault()); } else if (currentAreaInfo.ProvinceSysNo != null && currentAreaInfo.CitySysNo != null) { cityList = this.QueryCityAreaListByProvinceSysNo(currentAreaInfo.ProvinceSysNo.GetValueOrDefault()); districtList = this.QueryDistrictAreaListByCitySysNo(currentAreaInfo.CitySysNo.GetValueOrDefault()); } } }
public TableReportInfo() { //-- Object of area selection this._AreaSelection = new AreaInfo(); //-- Object of TP selection this._TimePeriodSelection = new TimePeriodInfo(); //-- Object of source selection this._SourceSelection = new SourceInfo(); }
/// <summary> /// 获取区域信息 /// </summary> /// <param name="gameId"></param> /// <param name="areaId"></param> /// <returns></returns> public RemotingInterface.AreaInfo GetAreaInfo(int gameId, int areaId) { RemotingInterface.AreaInfo areaInfo = new AreaInfo(); areaInfo.Clear(); IList<RemotingInterface.AreaInfo> _list = new List<AreaInfo>(); _list = GetAreaList(gameId); _list = (from row in _list where row.AreaId == areaId select row).ToList<RemotingInterface.AreaInfo>(); if (_list.Count == 1) { areaInfo = _list[0]; } return areaInfo; }
public static AreaInfo CreateSYAreaInfo(DataRow row) { var entity = new AreaInfo(); entity.AreaID = DBConvert.GetInt32(row, "AreaID"); entity.ParentAreaID = DBConvert.GetInt32(row, "ParentAreaID"); entity.Language = DBConvert.GetString(row, "Language"); entity.PathCode = DBConvert.GetString(row, "PathCode"); entity.AreaCode = DBConvert.GetString(row, "AreaCode"); entity.AreaName = DBConvert.GetString(row, "AreaName"); entity.Grade = DBConvert.GetInt32(row, "Grade"); entity.PhoneCode = DBConvert.GetString(row, "PhoneCode"); entity.Comments = DBConvert.GetString(row, "Comments"); entity.CreateUser = DBConvert.GetInt32(row, "CreateUser"); entity.CreateTime = DBConvert.GetDateTime(row, "CreateTime"); entity.ModifyUser = DBConvert.GetInt32(row, "ModifyUser"); entity.ModifyTime = DBConvert.GetDateTime(row, "ModifyTime"); return entity; }
protected void btnSave_Click(object sender, EventArgs e) { AreaInfo areainfo = new AreaInfo(); if (areaid == null) { areainfo.AreaID = Guid.Empty; } else { areainfo.AreaID = new Guid(areaid); } areainfo.OrderNO = Convert.ToInt32(tbOrderNo.Text); areainfo.AreaName = tbAreaName.Text; areainfo.DeleteFlag = false; dalArea.Save(areainfo); Session[WebHint.Web_Hint] = new WebHint("保存成功", "/Shop/Default.aspx", HintFlag.跳转); Response.Redirect(WebHint.HintURL); }
public void RecomputeAreas() { // Compute areas lock (m_areas) { foreach (AreaInfo infoArea in m_areas.Values) { infoArea.Deleted = true; infoArea.Servers = 0; infoArea.Users = -1; infoArea.Bandwidth = 0; infoArea.BandwidthMax = 0; } List<string> areasWhiteList = Storage.GetList("areas.whitelist"); List<string> areasBlackList = Storage.GetList("areas.blacklist"); foreach (ServerInfo server in m_servers.Values) { string countryCode = server.CountryCode; AreaInfo infoArea = null; if (m_areas.ContainsKey(countryCode)) { infoArea = m_areas[countryCode]; infoArea.Deleted = false; } if (infoArea == null) { // Create infoArea = new AreaInfo(); infoArea.Code = countryCode; infoArea.Name = CountriesManager.GetNameFromCode(countryCode); infoArea.Deleted = false; m_areas[countryCode] = infoArea; } if (server.BandwidthMax != 0) { infoArea.Bandwidth += server.Bandwidth; infoArea.BandwidthMax += server.BandwidthMax; } if (server.Users >= 0) { if (infoArea.Users == -1) infoArea.Users = 0; infoArea.Users += server.Users; } infoArea.Servers++; } for (;;) { bool restart = false; foreach (AreaInfo infoArea in m_areas.Values) { if (infoArea.Deleted) { m_areas.Remove(infoArea.Code); restart = true; break; } } if (restart == false) break; } // White/black list foreach (AreaInfo infoArea in m_areas.Values) { string code = infoArea.Code; if (areasWhiteList.Contains(code)) infoArea.UserList = AreaInfo.UserListType.WhiteList; else if (areasBlackList.Contains(code)) infoArea.UserList = AreaInfo.UserListType.BlackList; else infoArea.UserList = AreaInfo.UserListType.None; } } }
/// <summary> /// area grid cell double click for update /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgvArea_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { try { if (e.RowIndex != -1) { string strArea = dgvArea.CurrentRow.Cells["dgvtxtarea"].Value.ToString(); if (strArea != "NA") { AreaInfo infoArea = new AreaInfo(); AreaBll BllArea = new AreaBll(); infoArea = BllArea.AreaFill(Convert.ToDecimal(dgvArea.CurrentRow.Cells[1].Value.ToString())); txtAreaName.Text = infoArea.AreaName; txtNarration.Text = infoArea.Narration; btnSave.Text = "Update"; btnDelete.Enabled = true; txtAreaName.Focus(); decAreaId = Convert.ToDecimal(dgvArea.CurrentRow.Cells[1].Value.ToString()); } else { Messages.WarningMessage("NA Area cannot update or delete"); Clear(); } } } catch (Exception ex) { MessageBox.Show("AR16" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Checking the invalid entries fro save or update /// </summary> public void SaveOrEdit() { try { if (txtAreaName.Text.Trim() == string.Empty) { Messages.InformationMessage("Enter area name"); txtAreaName.Focus(); } else { AreaInfo infoArea = new AreaInfo(); AreaBll BllArea = new AreaBll(); infoArea.AreaName = txtAreaName.Text.Trim(); infoArea.Narration = txtNarration.Text.Trim(); infoArea.Extra1 = string.Empty; infoArea.Extra2 = string.Empty; infoArea.AreaId = decAreaId; if (btnSave.Text == "Save") { if (Messages.SaveConfirmation()) { if (BllArea.AreaNameCheckExistence(txtAreaName.Text.Trim(), 0) == false) { decAreaId = BllArea.AreaAddWithIdentity(infoArea); AreaGridfill(); Messages.SavedMessage(); Clear(); decIdForOtherForms = decAreaId; if (frmRouteObj != null) { this.Close(); } if (frmCustomerobj != null) { this.Close(); } if (frmSupplierobj != null) { this.Close(); } } else { Messages.InformationMessage("Area name already exist"); txtAreaName.Focus(); } } } else { if (Messages.UpdateConfirmation()) { if (BllArea.AreaNameCheckExistence(txtAreaName.Text.Trim(), decAreaId) == false) { infoArea.AreaId = decAreaId; if (BllArea.AreaUpdate(infoArea)) { AreaGridfill(); Messages.UpdatedMessage(); Clear(); } } else { Messages.InformationMessage("Area name already exist"); txtAreaName.Focus(); } } } } } catch (Exception ex) { MessageBox.Show("AR3" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// AreaID, Areaname, SelectedSeriesName/ IUS, DisplayInfo/data value, timeperiod, [TODO source] on the basis on area ID /// </summary> /// <param name="areaID"></param> /// <param name="selectedThemeID">if hatch and color theme is not exist then consider selected theme ID</param> /// <returns></returns> public string GetAreaInfo(string areaID) { string RetVal = string.Empty; string TempFileWPath = Path.Combine(HttpContext.Current.Request.PhysicalApplicationPath + Constants.FolderName.TempCYV, DateTime.Now.Ticks.ToString() + ".xml"); string AbsoluteTempFile = HttpContext.Current.Request.Url.AbsoluteUri; string MapFolder = string.Empty; Map diMap = null; Theme theme = null; string SelectedSeriesName = string.Empty; try { //step To load map from session/ NewMap/ From preserved file diMap = this.GetSessionMapObject(); theme = diMap.Themes.GetActiveTheme(); if (theme == null) { foreach (Theme thm in diMap.Themes) { if (thm.Type != ThemeType.Hatch && thm.Type != ThemeType.Color) { theme = thm; break; } } } if (theme.Type != ThemeType.Chart && theme.SelectedSeriesID.Split(',').Length == 1) { SelectedSeriesName = diMap.SeriesData[theme.SelectedSeriesID].SeriesName; } else { //TODo SelectedSeriesName = string.Empty; } //Format //Area Name (Area ID) [****] //Data Value (Time Period)[****] //Series Caption[****] //Source AreaInfo areaInfo = new AreaInfo(); if (theme.AreaIndexes[areaID] != null) { areaInfo = (AreaInfo)theme.AreaIndexes[areaID]; RetVal += areaInfo.AreaName + " (" + areaID + ") " + Constants.Delimiters.ParamDelimiter; if (theme.Type == ThemeType.Hatch || theme.Type == ThemeType.Color) { RetVal += areaInfo.DisplayInfo + Constants.Delimiters.ParamDelimiter; RetVal += SelectedSeriesName + Constants.Delimiters.ParamDelimiter; RetVal += areaInfo.Source; } else { RetVal += "" + Constants.Delimiters.ParamDelimiter; RetVal += "" + Constants.Delimiters.ParamDelimiter; RetVal += ""; } } else if (diMap.Layers[areaID] != null) { Hashtable AreaNames = diMap.Layers[areaID].AreaNames; if (AreaNames.ContainsKey(areaID)) { RetVal += (string)AreaNames[areaID] + " (" + areaID + ") " + Constants.Delimiters.ParamDelimiter; RetVal += "N/A" + Constants.Delimiters.ParamDelimiter; RetVal += SelectedSeriesName + Constants.Delimiters.ParamDelimiter; RetVal += ""; } } else { RetVal = "false"; } } catch (Exception ex) { //Global.WriteErrorsInLog("From GetAreaInfo ->" + ex.Message); RetVal = "false" + Constants.Delimiters.ParamDelimiter + ex.Message; Global.CreateExceptionString(ex, null); } finally { } return RetVal; }
private static AreaInfo CreateSYAreaInfo(IDataReader rdr) { AreaInfo mySYAreaInfo = new AreaInfo(); mySYAreaInfo.AreaID = DBConvert.GetInt32(rdr, "AreaID"); mySYAreaInfo.ParentAreaID = DBConvert.GetInt32(rdr, "ParentAreaID"); mySYAreaInfo.Language = DBConvert.GetString(rdr, "Language"); mySYAreaInfo.PathCode = DBConvert.GetString(rdr, "PathCode"); mySYAreaInfo.AreaCode = DBConvert.GetString(rdr, "AreaCode"); mySYAreaInfo.AreaName = DBConvert.GetString(rdr, "AreaName"); mySYAreaInfo.Grade = DBConvert.GetInt32(rdr, "Grade"); mySYAreaInfo.PhoneCode = DBConvert.GetString(rdr, "PhoneCode"); mySYAreaInfo.Comments = DBConvert.GetString(rdr, "Comments"); mySYAreaInfo.CreateUser = DBConvert.GetInt32(rdr, "CreateUser"); mySYAreaInfo.CreateTime = DBConvert.GetDateTime(rdr, "CreateTime"); mySYAreaInfo.ModifyUser = DBConvert.GetInt32(rdr, "ModifyUser"); mySYAreaInfo.ModifyTime = DBConvert.GetDateTime(rdr, "ModifyTime"); return mySYAreaInfo; }
private void BindArea() { IList<AreaInfo> ais = dalArea.GetAreas(); ddlarea.DataTextField = "AreaName"; ddlarea.DataValueField = "AreaID"; ddlarea.DataSource = ais; ddlarea.DataBind(); ai = dalArea.GetByAreaID(new Guid(areaid)); tbOrderNo.Text = ai.OrderNO.ToString(); tbAreaName.Text = ai.AreaName; BindAreaUsers(); }
/// <summary> /// Touch areas can be used to check only a special area for touch activities. Gestures will be checked for each area independently. /// If areas overlap then the area with the highest value of priority will be choosen for a touch /// </summary> public int AddTouchArea(Rect theRect, int thePriority = 0, string theName = "Unnamed") { // get max id int aMaxID = -1; foreach (int aKey in itsTouchAreas.Keys) { if (aKey > aMaxID) aMaxID = aKey; } int aNewKey = aMaxID + 1; itsTouchAreas[aNewKey] = new AreaInfo(theRect, thePriority,theName); return aNewKey; }
//------------------------------------------------------------------------------- #region -readDefFile DEFファイル読み込み //------------------------------------------------------------------------------- // private static async Task<BaseInfo> readDefFile(StorageFile defFile) { BaseInfo info = new BaseInfo(); try { using (Stream st = (await defFile.OpenReadAsync()).AsStream()) using (TextReader reader = new StreamReader(st, Encoding.GetEncoding("shift_jis"))) { string line = reader.ReadLine(); string curr = ""; while (line != null) { if (line.Length == 0 || line.StartsWith("#")) { } else if (line.StartsWith("*")) { // tag start curr = line.Substring(1); } else { // data start if (curr.Equals("Comiket")) { string[] data = line.Split('\t'); info.No = int.Parse(data[0]); info.EventName = data[1]; } else if (curr.Equals("cutInfo")) { string[] data = line.Split('\t'); info.CircleCutInfo.Rect.Width = int.Parse(data[0]); info.CircleCutInfo.Rect.Height = int.Parse(data[1]); info.CircleCutInfo.Rect.X = int.Parse(data[2]); info.CircleCutInfo.Rect.Y = int.Parse(data[3]); info.CircleCutInfo.OffsetX = int.Parse(data[4]); info.CircleCutInfo.OffsetY = int.Parse(data[5]); } else if (curr.Equals("mapTableInfo")) { string[] data = line.Split('\t'); info.MapTableInfo.Width = int.Parse(data[0]); info.MapTableInfo.Height = int.Parse(data[1]); info.MapTableInfo.X = int.Parse(data[2]); info.MapTableInfo.Y = int.Parse(data[3]); } else if (curr.Equals("ComiketDate")) { string[] data = line.Split('\t'); DateTime dt = new DateTime(int.Parse(data[0]), int.Parse(data[1]), int.Parse(data[2])); info.DateInfo.Add(Tuple.Create(dt, int.Parse(data[4]))); } else if (curr.Equals("ComiketMap")) { string[] data = line.Split('\t'); MapInfo mInfo = new MapInfo(); mInfo.MapName = data[0]; mInfo.MapFileWord = data[1]; mInfo.PrintRange.X = int.Parse(data[2]); mInfo.PrintRange.Y = int.Parse(data[3]); mInfo.PrintRange.Width = int.Parse(data[4]); mInfo.PrintRange.Height = int.Parse(data[5]); mInfo.LightMapFileWord = data[6]; mInfo.HighResoPrintRange.X = int.Parse(data[7]); mInfo.HighResoPrintRange.Y = int.Parse(data[8]); mInfo.HighResoPrintRange.Width = int.Parse(data[9]); mInfo.HighResoPrintRange.Height = int.Parse(data[10]); mInfo.RayoutVerticalMirrorFlag = (int.Parse(data[11]) == 1); info.MapInfo.Add(mInfo); } else if (curr.Equals("ComiketArea")) { string[] data = line.Split('\t'); AreaInfo aInfo = new AreaInfo(); aInfo.AreaName = data[0]; aInfo.MapName = data[1]; aInfo.BlockNames = data[2]; aInfo.PrintRange.X = int.Parse(data[3]); aInfo.PrintRange.Y = int.Parse(data[4]); aInfo.PrintRange.Width = int.Parse(data[5]); aInfo.PrintRange.Height = int.Parse(data[6]); if (data.Length > 7) { aInfo.LightMapFileWord = data[7]; aInfo.HighResoPrintRange.X = int.Parse(data[8]); aInfo.HighResoPrintRange.Y = int.Parse(data[9]); aInfo.HighResoPrintRange.Width = int.Parse(data[10]); aInfo.HighResoPrintRange.Height = int.Parse(data[11]); } info.AreaInfo.Add(aInfo); } else if (curr.Equals("ComiketGenre")) { string[] data = line.Split('\t'); info.GenreInfo.Add(Tuple.Create(int.Parse(data[0]), data[1])); } } line = reader.ReadLine(); } } } catch (Exception e) { } return info; }