public WarehouseInfo Get_WarehouseMaster_By_Id(int WarehouseId)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
WarehouseInfo WarehouseInfo = new WarehouseInfo();
sqlParams.Add(new SqlParameter("@WarehouseId", WarehouseId));
DataTable dt = _sqlHelper.ExecuteDataTable(sqlParams, StoredProcedureEnum.sp_GetWarehouseById.ToString(), CommandType.StoredProcedure);
foreach (DataRow dr in dt.Rows)
{
WarehouseInfo = Get_Warehouse_Values(dr);
}
return(WarehouseInfo);
}
// GET: WarehouseInfoes/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
WarehouseInfo warehouseInfo = db.WarehouseInfo.Find(id);
if (warehouseInfo == null)
{
return(HttpNotFound());
}
return(View(warehouseInfo));
}
public bool InsertWarehouse(WarehouseInfo warehouseInfo, UnitWarehouseInfo unitWarehouseInfo, out string strError, bool IsTran)
{
IDbTransaction tran = null;
if (IsTran)
{
tran = this.SQLHelper.CreateTransaction();
}
using (tran)
{
try
{
//1.判断重复
if (!IsExistWarehouseCode(warehouseInfo.wh_code, warehouseInfo.warehouse_id, tran))
{
strError = "编码已经存在。";
//throw (new System.Exception(strError));
return(true);
}
//插入仓库
if (!SetWarehouseInsert(warehouseInfo, tran))
{
strError = "插入仓库失败";
throw (new System.Exception(strError));
}
//插入仓库
if (!SetUnitWarehouseInsert(unitWarehouseInfo, tran))
{
strError = "插入仓库与门店关系失败";
throw (new System.Exception(strError));
}
if (IsTran)
{
tran.Commit();
}
strError = "成功";
return(true);
}
catch (Exception ex)
{
if (IsTran)
{
tran.Rollback();
}
throw (ex);
}
}
}
/// <summary>
/// 修改一个仓库
/// </summary>
/// <param name="loggingSession">当前用户的登录信息</param>
/// <param name="warehouse">仓库信息</param>
/// <returns></returns>
public bool ModifyWarehouse(WarehouseInfo warehouse)
{
//保存
UnitWarehouseInfo unit_warehouse = new UnitWarehouseInfo(warehouse.Unit, warehouse);
unit_warehouse.ID = this.NewGuid();
warehouse.ModifyUserID = loggingSessionInfo.CurrentUser.User_Id;
warehouse.ModifyUserName = loggingSessionInfo.CurrentUser.User_Name;
string strError = string.Empty;
bool bReturn = posService.ModifyWarehouse(warehouse, unit_warehouse, out strError);
return(bReturn);
}
// GET: WarehouseInfoes/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
WarehouseInfo warehouseInfo = db.WarehouseInfo.Find(id);
if (warehouseInfo == null)
{
return(HttpNotFound());
}
ViewBag.EmployeeID = new SelectList(db.Employee, "EmployeeID", "Name", warehouseInfo.EmployeeID);
return(View(warehouseInfo));
}
public void UpdateWarehouseInfo(WarehouseInfoVM vm, Action callback)
{
WarehouseInfo info = ConvertWarehouseVMToInfo(vm);
restClient.Query <WarehouseInfo>("/InventoryService/Stock/WH/Update", info, (obj, args) =>
{
if (!args.FaultsHandle())
{
Page.Context.Window.Alert("仓库信息修改成功", MessageType.Information);
}
if (callback != null)
{
callback();
}
});
}
private WarehouseInfo ConvertWarehouseVMToInfo(WarehouseInfoVM vm)
{
WarehouseInfo info = vm.ConvertVM <WarehouseInfoVM, WarehouseInfo>((v, i) =>
{
i.CreateUser = new UserInfo {
SysNo = v.CreateUserSysNo
};
i.EditUser = new UserInfo {
SysNo = v.EditUserSysNo
};
//i.OwnerInfo = new WarehouseOwnerInfo { SysNo = int.Parse(v.OwnerSysNo) };//(中蛋定制化 不需要此信息)
i.TransferRate = decimal.Round(vm.TransferRate, 2);
});
return(info);
}
private WarehouseInfo GetListRowModel(int iRowIndex)
{
string strErr = string.Empty;
WarehouseInfo warehouse = new WarehouseInfo();
warehouse.ID = lstMain[iRowIndex].ID;
if (!Basic_Func.GetWarehouseByID(ref warehouse, ref strErr))
{
Common.Common_Func.ErrorMessage(strErr, "读取失败");
GetListQueryData();
return(null);
}
return(warehouse);
}
private void save_Click(object sender, EventArgs e)
{
WarehouseInfo warehouseInfo = new WarehouseInfo();
warehouseInfo.Name = txtTen.Text;
warehouseInfo.ManagermentStaff = int.Parse(cbxQL.SelectedValue.ToString());
warehouseInfo.Contact = txtLH.Text;
warehouseInfo.Address = txtadd.Text;
warehouseInfo.Status = txtSTT.Text;
warehouseInfo.Note = txtNote.Text;;
WarehouseBUS warehouseBUS = new WarehouseBUS();
warehouseBUS.Add(warehouseInfo);
}
public ActionResult Delete(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
WarehouseInfo warehouseInfo = db.WarehouseInfo.Find(id);
if (warehouseInfo == null)
{
return(HttpNotFound());
}
db.WarehouseInfo.Remove(warehouseInfo);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void CreateWarehouseInfo(WarehouseInfoVM vm, Action callback)
{
WarehouseInfo info = ConvertWarehouseVMToInfo(vm);
restClient.Query <WarehouseInfo>("/InventoryService/Stock/WH/Create", info, (obj, args) =>
{
if (!args.FaultsHandle() && args.Result != null)
{
vm.SysNo = args.Result.SysNo;
this.Page.Context.Window.Alert("仓库信息创建成功", MessageType.Information);
}
if (callback != null)
{
callback();
}
});
}
/// <summary>
/// 新增仓库
/// </summary>
/// <param name="errText"></param>
/// <param name="warehouseInfo"></param>
/// <returns></returns>
public int InsertEntity(out string errText, WarehouseInfo warehouseInfo)
{
warehouseInfo.WarehouseId = Guid.NewGuid();
var i = _dal.InsertEntity(out errText, warehouseInfo);
if (i <= 0)
{
return(i);
}
StockInfo info = new StockInfo()
{
WarehouseId = warehouseInfo.WarehouseId, Count = 0, Capacity = warehouseInfo.Capicity, Remark = warehouseInfo.Remark
};
i = _stockDal.InsertEntity(out errText, info);
return(i);
}
//檢視
public ActionResult Detail(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
WarehouseInfo warehouseInfo = db.WarehouseInfo.Find(id);
if (warehouseInfo == null)
{
return(HttpNotFound());
}
var datas = db.WarehouseInfo.Where(w => w.WarehouseCode == id).
Select(g => new { g.WarehouseInfoOID, g.WarehouseCode, g.WarehouseName, g.Address, g.EmployeeID, g.Tel, g.Remark });
return(Json(datas, JsonRequestBehavior.AllowGet));
}
public void CopyInfo(PlayerInfo source)
{
ID = source.ID;
CharacterName = source.CharacterName;
level = source.level;
IsAlive = source.IsAlive;
IsTired = source.IsTired;
IsExhausted = source.IsExhausted;
equipments = source.equipments;
Li = source.Li;
Ti = source.Ti;
Qi = source.Qi;
Ji = source.Ji;
Min = source.Min;
HP = source.HP;
Current_HP = source.Current_HP;
MP = source.MP;
Current_MP = source.Current_MP;
Endurance = source.Endurance;
Current_Endurance = source.Current_Endurance;
BlockAmount = source.BlockAmount;
Current_BlockAmount = source.Current_BlockAmount;
NextExp = source.NextExp;
Current_Exp = source.Current_Exp;
SkillPointOne = source.SkillPointOne;
SkillPointTwo = source.SkillPointTwo;
Neili = source.Neili;
ATK = source.ATK;
DEF = source.DEF;
Hit = source.Hit;
Dodge = source.Dodge;
Crit = source.Crit;
Res_Blowed = source.Res_Blowed;
Res_Floated = source.Res_Floated;
Res_Repulsed = source.Res_Repulsed;
Res_Rigidity = source.Res_Rigidity;
Res_Stuned = source.Res_Stuned;
Res_Falled = source.Res_Falled;
//status = new List<StatuInfo>();
//buffs = source.buffs;
bag = source.bag;
warehouseInfo = source.warehouseInfo;
mount = source.mount;
//MoveSpeed = source.MoveSpeed;
}
public ActionResult Edit(WarehouseInfo warehouseInfo)
{
string message = "修改成功!!";
bool status = true;
if (ModelState.IsValid)
{
db.Entry(warehouseInfo).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { status = status, message = message, id = db.WarehouseInfo.Max(x => x.WarehouseInfoOID) }, JsonRequestBehavior.AllowGet));
}
else
{
message = "修改失敗!!";
status = false;
return(Json(new { status = status, message = message }, JsonRequestBehavior.AllowGet));
}
}
public FrmWarehouseFile(WarehouseInfo model)
{
if (model == null)
{
model = new WarehouseInfo();
}
_warehouse = model;
if (model.ID == 0)
{
SetNewModel();
}
_back = Common.Common_Func.ConvertToModel <WarehouseInfo>(_warehouse);
InitializeComponent();
bsWarehouse.DataSource = _warehouse;
}
public ActionResult Create(WarehouseInfo warehouseInfo)
{
string message = "新增成功!!";
bool status = true;
if (ModelState.IsValid)
{
db.WarehouseInfo.Add(warehouseInfo);
db.SaveChanges();
return(Json(new { status = status, message = message, id = db.WarehouseInfo.Max(x => x.WarehouseInfoOID) }, JsonRequestBehavior.AllowGet));
}
else
{
message = "新增失敗!!";
status = false;
return(Json(new { status = status, message = message }, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 插入一个仓库
/// </summary>
/// <param name="loggingSession">当前用户的登录信息</param>
/// <param name="warehouse">仓库信息</param>
/// <returns></returns>
//public bool InsertWarehouse(LoggingSessionInfo loggingSession, WarehouseInfo warehouse)
//{
// //if (string.IsNullOrEmpty(warehouse.ID))
// //{
// // warehouse.ID = this.NewGuid();
// //}
// //warehouse.CreateUserID = loggingSession.CurrentUser.User_Id;
// //warehouse.CreateUserName = loggingSession.CurrentUser.User_Name;
// //UnitWarehouseInfo unit_warehouse = new UnitWarehouseInfo(warehouse.Unit, warehouse);
// //unit_warehouse.ID = this.NewGuid();
// ////保存
// //ISqlMapper sqlMapper = cSqlMapper.Instance(loggingSession.CurrentLoggingManager);
// //try
// //{
// // sqlMapper.BeginTransaction();
// // //添加仓库
// // sqlMapper.Insert("Pos.Warehouse.Insert", warehouse);
// // //添加仓库与单位的关系
// // sqlMapper.Update("Pos.UnitWarehouse.Insert", unit_warehouse);
// // sqlMapper.CommitTransaction();
// //}
// //catch (Exception ex)
// //{
// // sqlMapper.RollBackTransaction();
// // throw ex;
// //}
// return true;
//}
//public bool InsertWarehouse(LoggingManager loggingManager, WarehouseInfo warehouse)
//{
// //if (string.IsNullOrEmpty(warehouse.ID))
// //{
// // warehouse.ID = this.NewGuid();
// //}
// //UnitWarehouseInfo unit_warehouse = new UnitWarehouseInfo(warehouse.Unit, warehouse);
// //unit_warehouse.ID = this.NewGuid();
// ////保存
// //ISqlMapper sqlMapper = cSqlMapper.Instance(loggingManager);
// //try
// //{
// // sqlMapper.BeginTransaction();
// // //添加仓库
// // sqlMapper.Insert("Pos.Warehouse.Insert", warehouse);
// // //添加仓库与单位的关系
// // sqlMapper.Update("Pos.UnitWarehouse.Insert", unit_warehouse);
// // sqlMapper.CommitTransaction();
// //}
// //catch (Exception ex)
// //{
// // sqlMapper.RollBackTransaction();
// // throw ex;
// //}
// return true;
//}
/// <summary>
/// 插入仓库信息
/// </summary>
/// <param name="warehouse"></param>
/// <returns></returns>
public bool InsertWarehouse(WarehouseInfo warehouse, bool IsTran = true)
{
if (string.IsNullOrEmpty(warehouse.warehouse_id))
{
warehouse.warehouse_id = this.NewGuid();
}
UnitWarehouseInfo unit_warehouse = new UnitWarehouseInfo(warehouse.Unit, warehouse);
unit_warehouse.ID = this.NewGuid();
string strError = string.Empty;
bool b = posService.InsertWarehouse(warehouse, unit_warehouse, out strError, IsTran);
if (!b)
{
throw (new System.Exception(strError));
}
return(b);
}
private string PreCheckWarehouseInfo(WarehouseInfo warehouseInfo)
{
StringBuilder result = new StringBuilder();
if (String.IsNullOrEmpty((warehouseInfo.WarehouseID)))
{
result.Append("仓库编号不能为空!");
}
if (String.IsNullOrEmpty((warehouseInfo.WarehouseName)))
{
result.Append("仓库名称不能为空!");
}
if (String.IsNullOrEmpty((warehouseInfo.Address)))
{
result.Append("仓库地址不能为空!");
}
if (String.IsNullOrEmpty((warehouseInfo.Contact)))
{
result.Append("联系人不能为空!");
}
if (String.IsNullOrEmpty((warehouseInfo.PhoneNumber)))
{
result.Append("联系电话不能为空!");
}
if (String.IsNullOrEmpty((warehouseInfo.ReceiveAddress)))
{
result.Append("收货地址不能为空!");
}
if (String.IsNullOrEmpty((warehouseInfo.ReceiveContact)))
{
result.Append("收货联系人不能为空!");
}
if (String.IsNullOrEmpty((warehouseInfo.ReceiveContactPhoneNumber)))
{
result.Append("收货联系电话不能为空!");
}
if (warehouseInfo.TransferRate < 0)
{
result.Append("移仓分仓系数不能小于零!");
}
return(result.ToString());
}
private void ShowFileForm(HouseInfo house)
{
WarehouseInfo warehouse = GetBelongWarehouse(house.WarehouseID);
if (warehouse == null)
{
return;
}
using (FrmHouseFile frm = new FrmHouseFile(house, warehouse))
{
frm.ShowDialog();
}
this.Refresh();
Application.DoEvents();
GetListQueryData();
}
public FrmHouseFile(HouseInfo model, WarehouseInfo warehouse)
{
if (model == null)
{
model = new HouseInfo();
}
_house = model;
_warehouse = warehouse;
if (model.ID == 0)
{
SetNewModel();
}
_back = Common.Common_Func.ConvertToModel <HouseInfo>(_house);
InitializeComponent();
bsHouse.DataSource = _house;
}
/// <summary>
/// 新增一条仓库信息
/// </summary>
/// <param name="errText"></param>
/// <param name="WarehouseInfo"></param>
/// <returns></returns>
public int InsertEntity(out string errText, WarehouseInfo WarehouseInfo)
{
errText = "";
try {
using (SqlConnection conn = new SqlConnection(SQL_CON)) {
var sql = "insert into WarehouseInfo (WarehouseId,WarehouseName,Capicity,Remark) values(@WarehouseId,@WarehouseName,@Capicity,@Remark)";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@WarehouseId", WarehouseInfo.WarehouseId);
cmd.Parameters.AddWithValue("@WarehouseName", WarehouseInfo.WarehouseName);
cmd.Parameters.AddWithValue("@Capicity", WarehouseInfo.Capicity);
cmd.Parameters.AddWithValue("@Remark", WarehouseInfo.Remark);
var i = cmd.ExecuteNonQuery();
conn.Close();
return(i);
}
} catch (Exception ex) {
errText = ex.Message;
return(0);
}
}
/// <summary>
/// 修改仓库列表
/// </summary>
/// <param name="errText"></param>
/// <param name="WarehouseInfo"></param>
/// <returns></returns>
public int UpdateEntity(out string errText, WarehouseInfo warehouseInfo)
{
errText = "";
try {
using (SqlConnection conn = new SqlConnection(SQL_CON)) {
conn.Open();
var sql = "update WarehouseInfo set WarehouseName=@WarehouseName,Capicity=@Capicity,Remark=@Remark where WarehouseId=@WarehouseId";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@WarehouseId", warehouseInfo.WarehouseId);
cmd.Parameters.AddWithValue("@WarehouseName", warehouseInfo.WarehouseName);
cmd.Parameters.AddWithValue("@Capicity", warehouseInfo.Capicity);
cmd.Parameters.AddWithValue("@Remark", warehouseInfo.Remark);
var i = cmd.ExecuteNonQuery();
conn.Close();
return(i);
}
} catch (Exception ex) {
errText = ex.Message;
return(0);
}
}
public PlayerInfo()
{
ID = 100000;
CharacterName = "大侠";
Level = 0;
IsAlive = true;
IsMounting = false;
IsTired = false;
IsExhausted = false;
Li = 5;
Ti = 5;
Qi = 5;
Ji = 5;
Min = 5;
HP = Ti * 100;
Current_HP = HP;
MP = Li * 20 + Ti * 30;
Current_MP = MP;
Endurance = Ti * 2 + Qi;
Current_Endurance = Endurance;
Neili = Qi;
ATK = Li * 3;
DEF = Qi * 3;
Hit = Ji * 0.4f;
Dodge = Min;
Crit = Ji * 0.1f;
Res_Blowed =
Res_Floated =
Res_Repulsed =
Res_Rigidity =
Res_Stuned =
Res_Falled = 0.0f;
status = new List <StatuInfo>();
//buffs = new List<BuffInfo>();
equipments = new Equipments();
bag = new BagInfo(39, 150);
warehouseInfo = new WarehouseInfo(300);
mount = null;
//MoveSpeed = 5.0f;
}
public WarehouseViewModel()
{
WarehouseInfo = new WarehouseInfo();
WarehouseInfoList = new List <WarehouseInfo>();
BranchInfoList = new List <BranchInfo>();
FriendlyMessage = new List <FriendlyMessage>();
Pager = new PaginationInfo();
AddressViewModelList = new AddressViewModel();
ContactViewModelList = new ContactViewModel();
AddressViewModelList.Address.AddressFor = AddressFor.Warehouse.ToString();
ContactViewModelList.ContactDetails.ContactFor = AddressFor.Warehouse.ToString();
WarehouseFilter = new WarehouseFilter();
}
public ActionResult Submit(Warranty record)
{
var result = false;
var list = new WarrantyList();
var model = new WarrantyModel();
var action = record.ID > 0 ? DbAction.Warranty.Modify : DbAction.Warranty.Create;
var warehouses = WarehouseInfo.FindAuthorized(UserID, Employee.ID, Employee.BussinessID, UserID, action);
record.ReceiveWarehouseID = warehouses.FirstOrDefault().ID;
model.Record = record.Save(ModelState, UserID, Employee.ID, Employee.BussinessID, Employee.Name);
if (result = model.Record != null)
{
model.SelectedProduct = ProductInfo.Get(UserID, Employee.ID, record.ProductID, false, action);
if (model.Record.OrderID.HasValue)
{
model.SelectedOrder = Export.GetOrder(UserID, Employee.ID, model.Record.OrderID.Value, false, action);
}
var login = Login.Get(UserID);
model.ViewInternalNote = login.Type == LoginType.Mechanic || login.Type == LoginType.Office || login.Username == "admin";
}
else
{
model.Record = record;
}
list.Current = model;
var message = result ? "Lưu thông tin không thành công" : null;
if (Request.IsAjaxRequest())
{
return(Json(new
{
result = result,
message = message,
html = result ? RenderPartialViewToString(Views.HistoryPartial, list) : null
}, JsonRequestBehavior.DenyGet));
}
return(RedirectToAction("History"));
}
public void SendMessageToWMS(SOInfo soInfo, WMSAction action, OPCCallBackType callBackType)
{
object mark = new object();
List <int> stockSysNoList = (from item in soInfo.Items
where item.StockSysNo.HasValue && item.ProductType != SOProductType.Coupon && item.ProductType != SOProductType.ExtendWarranty
select item.StockSysNo.Value).Distinct().ToList();
lock (mark)
{
int masterID = this.SaveOPCMaster(soInfo, action, callBackType);
foreach (int stockSysNo in stockSysNoList)
{
WarehouseInfo wareInfo = ExternalDomainBroker.GetWarehouseInfo(stockSysNo);
string stockID = wareInfo == null ? "" : wareInfo.WarehouseID;
if (String.IsNullOrEmpty(stockID))
{
BizExceptionHelper.Throw("SO_Audit_StockIsNotExist", stockSysNo.ToString());
}
int transactionID = this.SaveOPCTransaction(soInfo.SysNo.Value, stockSysNo, masterID, soInfo.CompanyCode);
WMSSOActionRequestMessage requestEntity = new WMSSOActionRequestMessage
{
SOSysNo = soInfo.SysNo.Value,
CompanyCode = soInfo.CompanyCode,
ActionDate = DateTime.Now,
ActionReason = string.Format("{0} SO", action.ToDisplayText()),
StockSysNo = stockSysNo,
TransactionSysNo = transactionID,
StockID = stockID,
Language = soInfo.BaseInfo.LanguageCode,
ActionType = WMSActionToAction(action),
ActionUser = ServiceContext.Current.UserSysNo
};
this.SaveOPCMessage(soInfo, transactionID, requestEntity);
EventPublisher.Publish <WMSSOActionRequestMessage>(requestEntity);
}
}
}
public List <SqlParameter> SetValuesInWarehouseInfo(WarehouseInfo WarhouseInfo)
{
List <SqlParameter> sqlParam = new List <SqlParameter>();
if (WarhouseInfo.Id != 0)
{
sqlParam.Add(new SqlParameter("@WarehouseId", WarhouseInfo.Id));
}
else
{
sqlParam.Add(new SqlParameter("@CreatedBy", WarhouseInfo.CreatedBy));
}
sqlParam.Add(new SqlParameter("@Warehouse", WarhouseInfo.WarehouseName));
sqlParam.Add(new SqlParameter("@BranchId", WarhouseInfo.BranchId));
sqlParam.Add(new SqlParameter("@IsActive", WarhouseInfo.IsActive));
sqlParam.Add(new SqlParameter("UpdatedBy", WarhouseInfo.UpdatedBy));
return(sqlParam);
}
/// <summary>
/// 根据仓库ID获取仓库信息
/// </summary>
public string GetWarehouseInfoById()
{
var posService = new PosService(CurrentUserInfo);
WarehouseInfo warehouse = new WarehouseInfo();
string content = string.Empty;
string key = string.Empty;
if (Request("warehouse_id") != null && Request("warehouse_id") != string.Empty)
{
key = Request("warehouse_id").ToString().Trim();
}
warehouse = posService.GetWarehouseByID(CurrentUserInfo, key);
var jsonData = new JsonData();
jsonData.totalCount = warehouse == null ? "0" : "1";
jsonData.data = warehouse;
content = jsonData.ToJSON();
return(content);
}
private void DeleteListRow(int iRowIndex)
{
WarehouseInfo warehouse = GetListRowModel(iRowIndex);
if (warehouse == null)
{
return;
}
if (MessageBox.Show(string.Format("是否确认删除仓库【{0}】?", warehouse.WarehouseName), "确认删除", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk) == DialogResult.No)
{
return;
}
try
{
if (warehouse.IsDel != 2)
{
string strErr = string.Empty;
if (!Basic_Func.DeleteWarehouseByID(warehouse, ref strErr))
{
Common.Common_Func.ErrorMessage(strErr, "删除失败");
return;
}
}
Common.Common_Func.ErrorMessage("删除仓库成功", "删除成功");
}
catch (Exception ex)
{
Common.Common_Func.ErrorMessage(ex.Message);
}
finally
{
GetListQueryData();
}
}
