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;
}
