protected void UnMarkClick_Event(object sender, DirectEventArgs e)
{
TasksGrid grid = Ext.Net.Utilities.ControlUtils.FindControls<TasksGrid>(this.Page)[0];
int[] ids = JSON.Deserialize<int[]>(e.ExtraParams["ids"]);
int categoryID = int.Parse(e.ExtraParams["categoryID"]);
grid.ToggleStatus(ids, false, categoryID, e.ExtraParams["filter"]);
}
void AddClick_Event(object sender, DirectEventArgs e)
{
WebRequest request = WebRequest.Create(this.feedUrl.SelectedItem.Value);
WebResponse response = request.GetResponse();
StreamReader reader = new StreamReader(response.GetResponseStream(), Encoding.GetEncoding("ISO-8859-1"));
XmlDocument doc = new XmlDocument();
doc.LoadXml(reader.ReadToEnd());
XmlNodeList channels = doc.SelectNodes("rss/channel");
if ( channels != null && channels.Count>0)
{
string title = this.feedUrl.SelectedItem.Value;
XmlNode titleNode = channels[0].SelectSingleNode("title");
if (titleNode != null && titleNode.InnerText.IsNotEmpty() )
{
title = titleNode.InnerText;
}
this.FireEvent("validfeed", new { url = this.feedUrl.SelectedItem.Value, text = title });
this.Hide();
}
else
{
e.Success = false;
}
}
private void DeleteFeedClick(object sender, DirectEventArgs e)
{
SubmittedNode node = ((DefaultSelectionModel) this.SelectionModel[0]).SelectedNode;
if (node != null && node.NodeID.IsNotEmpty())
{
this.RemoveFeed(node.NodeID);
}
}
private void OnRemoveFeedClick(object sender, DirectEventArgs e)
{
string nodeId = e.ExtraParams["nodeId"];
this.RemoveFeed(nodeId);
}
protected void btnTiepNhan_Click(object sender, DirectEventArgs e)
{
}
protected void btnEdit_Click(object sender, DirectEventArgs e)
{
try
{
SPChannelWrapper channelWrapper = ChannelID;
channelWrapper.Name = this.txtName.Text.Trim();
channelWrapper.Code = this.txtCode.Text.Trim();
channelWrapper.Description = this.txtDescription.Text.Trim();
channelWrapper.DataOkMessage = this.txtDataOkMessage.Text.Trim();
channelWrapper.DataFailedMessage = this.txtDataFailedMessage.Text.Trim();
if (channelWrapper.ChannelType == DictionaryConst.Dictionary_ChannelType_IVRChannel_Key)
{
channelWrapper.IVRFeeTimeType = cmbIVRType.SelectedItem.Value;
channelWrapper.IVRTimeFormat = this.txtIVRTimeFormat.Text.Trim();
}
channelWrapper.IsStateReport = !fsIsStateReport.Collapsed;
if (channelWrapper.IsStateReport)
{
channelWrapper.StateReportType = ((CheckboxBase)(rdgStateReportType.CheckedItems[0])).InputValue;
channelWrapper.StateReportParamName = this.txtStateReportParamName.Text.Trim();
channelWrapper.StateReportParamValue = this.txtStateReportParamValue.Text.Trim();
channelWrapper.ReportOkMessage = this.txtReportOkMessage.Text.Trim();
channelWrapper.ReportFailedMessage = this.txtReportFailedMessage.Text.Trim();
if (channelWrapper.StateReportType == DictionaryConst.Dictionary_ChannelStateReportType_SendTwiceTypeRequest_Key)
{
channelWrapper.RequestTypeParamName = this.txtRequestTypeParamName.Text.Trim();
channelWrapper.RequestTypeParamDataReportValue = this.txtRequestTypeParamDataReportValue.Text.Trim();
channelWrapper.RequestTypeParamStateReportValue = this.txtRequestTypeParamStateReportValue.Text.Trim();
}
}
channelWrapper.IsAutoLinkID = this.chkIsAutoLinkID.Checked;
if (channelWrapper.IsAutoLinkID)
{
channelWrapper.AutoLinkIDFields = this.txtAutoLinkIDFields.Text.Trim();
}
channelWrapper.IsDisable = false;
channelWrapper.IsLogRequest = this.chkIsLogRequest.Checked;
channelWrapper.IsMonitorRequest = this.chkIsMonitorRequest.Checked;
channelWrapper.IsParamsConvert = this.chkIsParamsConvert.Checked;
channelWrapper.HasFilters = this.chkHasFilters.Checked;
SPChannelWrapper.Update(channelWrapper);
}
catch (Exception ex)
{
ResourceManager.AjaxSuccess = false;
ResourceManager.AjaxErrorMessage = "错误信息:" + ex.Message;
return;
}
}
/// <summary>
/// Quay trở lại trang danh sách bảng lương
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnBack_Click(object sender, DirectEventArgs e)
{
Response.Redirect("~/Modules/Salary/SalaryBoardList.aspx");
}
protected void SaveNewRecord(object sender, DirectEventArgs e)
{
//Getting the id to check if it is an Add or an edit as they are managed within the same form.
string id = e.ExtraParams["id"];
string obj = e.ExtraParams["values"];
BiometricDevice b = JsonConvert.DeserializeObject <BiometricDevice>(obj);
b.recordId = id;
// Define the object to add or edit as null
if (string.IsNullOrEmpty(id))
{
try
{
//New Mode
//Step 1 : Fill The object and insert in the store
PostRequest <BiometricDevice> request = new PostRequest <BiometricDevice>();
request.entity = b;
PostResponse <BiometricDevice> r = _timeAttendanceService.ChildAddOrUpdate <BiometricDevice>(request);
b.recordId = r.recordId;
//check if the insert failed
if (!r.Success)//it maybe be another condition
{
//Show an error saving...
X.MessageBox.ButtonText.Ok = Resources.Common.Ok;
X.Msg.Alert(Resources.Common.ErrorSavingRecord, r.Summary).Show();
return;
}
else
{
//Add this record to the store
this.Store1.Insert(0, b);
//Display successful notification
Notification.Show(new NotificationConfig
{
Title = Resources.Common.Notification,
Icon = Icon.Information,
Html = Resources.Common.RecordSavingSucc
});
this.EditRecordWindow.Close();
RowSelectionModel sm = this.GridPanel1.GetSelectionModel() as RowSelectionModel;
sm.DeselectAll();
sm.Select(b.recordId.ToString());
}
}
catch (Exception ex)
{
//Error exception displaying a messsage box
X.MessageBox.ButtonText.Ok = Resources.Common.Ok;
X.Msg.Alert(Resources.Common.ErrorSavingRecord, ex.Message).Show();
}
}
else
{
//Update Mode
try
{
int index = Convert.ToInt32(id);//getting the id of the record
PostRequest <BiometricDevice> request = new PostRequest <BiometricDevice>();
request.entity = b;
PostResponse <BiometricDevice> r = _timeAttendanceService.ChildAddOrUpdate <BiometricDevice>(request); //Step 1 Selecting the object or building up the object for update purpose
//Step 2 : saving to store
//Step 3 : Check if request fails
if (!r.Success)//it maybe another check
{
X.MessageBox.ButtonText.Ok = Resources.Common.Ok;
X.Msg.Alert(Resources.Common.ErrorUpdatingRecord, r.Message).Show();
return;
}
else
{
ModelProxy record = this.Store1.GetById(index);
BasicInfoTab.UpdateRecord(record);
record.Commit();
Notification.Show(new NotificationConfig
{
Title = Resources.Common.Notification,
Icon = Icon.Information,
Html = Resources.Common.RecordUpdatedSucc
});
this.EditRecordWindow.Close();
}
}
catch (Exception ex)
{
X.MessageBox.ButtonText.Ok = Resources.Common.Ok;
X.Msg.Alert(Resources.Common.ErrorUpdatingRecord, ex.Message).Show();
}
}
}
protected void ChangGroup(object sender, DirectEventArgs e)
{
GridPanelBind();
}
protected void DelClick_Event(object sender, DirectEventArgs e)
{
TasksGrid grid = Ext.Net.Utilities.ControlUtils.FindControls<TasksGrid>(this.Page)[0];
int[] ids = JSON.Deserialize<int[]>(e.ExtraParams["ids"]);
grid.DeleteTasks(ids);
}
/// <summary>
/// 添加车道信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void AddLane(object sender, DirectEventArgs e)
{
if (string.IsNullOrEmpty(HideStation.Value.ToString()))
{
Notice("提示", "请选择左侧监测点！");
return;
}
try
{
Window window = new Window();
window.ID = "LimitAdd";
window.Title = GetLangStr("TGSLimitSpeed36", "限速设置");
window.Width = Unit.Pixel(400);
window.Height = Unit.Pixel(320);
window.Maximizable = false;
window.Resizable = false;
window.Hidden = true;
window.Layout = "Fit";
window.AutoLoad.Mode = LoadMode.Merge;
Ext.Net.FormPanel tab = new Ext.Net.FormPanel();
tab.Title = GetLangStr("TGSLimitSpeed20", "限速信息");
tab.Header = false;
tab.Padding = 5;
tab.DefaultAnchor = "98%";
tab.AnchorVertical = "100%";
tab.MonitorValid = true;
tab.Listeners.ClientValidation.Handler = "butSaveLimit.setDisabled(!valid);";
/* switch (HideLimitType.Value as string)
* {
* case "1":
* tab.Items.Add(CommonExt.AddComboBox("cmdLDirection", GetLangStr("TGSLimitSpeed21", "所属方向"), "StoreDirDev", GetLangStr("TGSLimitSpeed22", "请选择所属方向"), true));
* tab.Items.Add(CommonExt.AddTextField("txtLLane", GetLangStr("TGSLimitSpeed23", "车道编号")));
* X.GetCmp<ComboBox>("cmdLDirection").Hidden = true;
* X.GetCmp<TextField>("txtLLane").Hidden = false;
* break;
*
* case "2":
* tab.Items.Add(CommonExt.AddComboBox("cmdLDirection", GetLangStr("TGSLimitSpeed21", "所属方向"), "StoreDirDev", GetLangStr("TGSLimitSpeed22", "请选择所属方向"), false));
* tab.Items.Add(CommonExt.AddTextField("txtLLane", GetLangStr("TGSLimitSpeed23", "车道编号")));
* X.GetCmp<TextField>("txtLLane").Hidden = false;
*
* break;
*
* case "3":
* tab.Items.Add(CommonExt.AddComboBox("cmdLDirection", GetLangStr("TGSLimitSpeed21", "所属方向"), "StoreDirDev", GetLangStr("TGSLimitSpeed22", "请选择所属方向"), false));
* tab.Items.Add(CommonExt.AddTextField("txtLLane", GetLangStr("TGSLimitSpeed23", "车道编号"), false, "例:[1]"));
* break;
*
* default:
* tab.Items.Add(CommonExt.AddTextField("txtLLane", GetLangStr("TGSLimitSpeed23", "车道编号"), false, "例:[1]"));
* break;
* }
*/
tab.Items.Add(CommonExt.AddTextField("txtLLane", GetLangStr("TGSLimitSpeed23", "车道编号"), false, "例:[1]"));
tab.Items.Add(CommonExt.AddTextField("sfEBSpeed", GetLangStr("TGSLimitSpeed11", "大车限速"), false, "例:[60]"));
tab.Items.Add(CommonExt.AddTextField("sfESSpeed", GetLangStr("TGSLimitSpeed12", "小车限速"), false, "例:[80]"));
tab.Items.Add(CommonExt.AddTextField("sfEBASpeed", GetLangStr("TGSLimitSpeed13", "大车标牌限速"), false, "例:[65]"));
tab.Items.Add(CommonExt.AddTextField("sfESASpeed", GetLangStr("TGSLimitSpeed14", "小车标牌限速"), false, "例:[85]"));
tab.Items.Add(CommonExt.AddTextField("sfEBLSpeed", GetLangStr("TGSLimitSpeed15", "大车限低速"), false, "例:[40]"));
tab.Items.Add(CommonExt.AddTextField("sfESLSpeed", GetLangStr("TGSLimitSpeed16", "小车限低速"), false, "例:[50]"));
window.Buttons.Add(CommonExt.AddButton("butSaveLimit", GetLangStr("TGSLimitSpeed24", "保存"), "Disk", "TGSLimitSpeed.InfoLimitSave()"));
window.Buttons.Add(CommonExt.AddButton("butCancelLimit", GetLangStr("TGSLimitSpeed25", "取消"), "Cancel", window.ClientID + ".hide()"));
X.GetCmp <TextField>("sfEBSpeed").Text = "80";
X.GetCmp <TextField>("sfESSpeed").Text = "80";
X.GetCmp <TextField>("sfEBASpeed").Text = "65";
X.GetCmp <TextField>("sfESASpeed").Text = "85";
X.GetCmp <TextField>("sfEBLSpeed").Text = "10";
X.GetCmp <TextField>("sfESLSpeed").Text = "10";
X.GetCmp <TextField>("sfEBASpeed").Hidden = true;
X.GetCmp <TextField>("sfESASpeed").Hidden = true;
window.Items.Add(tab);
window.Render(this.Form);
window.Show();
}
catch (Exception ex)
{
ILog.WriteErrorLog(ex);
logManager.InsertLogError("TGSLimitSpeed.aspx-AddLane", ex.Message + "；" + ex.StackTrace, "AddLane has an exception");
}
}
protected void YeniKayitYap(object sender, DirectEventArgs e)
{
using (BaglantiCumlesi db = new BaglantiCumlesi())
{
if (TreePanel1.CheckedNodes != null)
{
foreach (var i in TreePanel1.CheckedNodes)
{
tbl_dosyalar_kategori ta = new tbl_dosyalar_kategori();
ta.tip = (int)Class.Sabitler.Dosya.Resim;
ta.kategori_id = int.Parse(i.NodeID);
ta.ad = Class.Fonksiyonlar.Genel.StringIslemleri(Class.Sabitler.StringIslemleri.StringIslemTipleri.SQLTemizle, Ekle_TextFieldKategori.Text.Trim());
if (Ekle_TextAreaAciklama.Text != null)
{
if (!string.IsNullOrEmpty(Class.Fonksiyonlar.Genel.StringIslemleri(Class.Sabitler.StringIslemleri.StringIslemTipleri.SQLTemizle, Ekle_TextAreaAciklama.Text.Trim())))
{
ta.aciklama = Class.Fonksiyonlar.Genel.StringIslemleri(Class.Sabitler.StringIslemleri.StringIslemTipleri.SQLTemizle, Ekle_TextAreaAciklama.Text.Trim());
}
else
{
ta.aciklama = null;
}
}
ta.admin_id_ek = Class.Fonksiyonlar.Admin.Genel.AdminID();
db.AddTotbl_dosyalar_kategori(ta);
db.SaveChanges();
#region Admin İşlem Log
Class.Fonksiyonlar.Admin.Log.Islemler(Class.Fonksiyonlar.Admin.Genel.AdminID(), ((EntityObject)(ta)).EntityKey.EntitySetName.ToString(), ta.id, (int)Class.Sabitler.AdminLog.Islemler.Insert);
#endregion
}
}
else
{
tbl_dosyalar_kategori ta = new tbl_dosyalar_kategori();
ta.kategori_id = 0;
ta.tip = (int)Class.Sabitler.Dosya.Resim;
ta.ad = Class.Fonksiyonlar.Genel.StringIslemleri(Class.Sabitler.StringIslemleri.StringIslemTipleri.SQLTemizle, Ekle_TextFieldKategori.Text.Trim());
if (Ekle_TextAreaAciklama.Text != null)
{
if (!string.IsNullOrEmpty(Class.Fonksiyonlar.Genel.StringIslemleri(Class.Sabitler.StringIslemleri.StringIslemTipleri.SQLTemizle, Ekle_TextAreaAciklama.Text.Trim())))
{
ta.aciklama = Class.Fonksiyonlar.Genel.StringIslemleri(Class.Sabitler.StringIslemleri.StringIslemTipleri.SQLTemizle, Ekle_TextAreaAciklama.Text.Trim());
}
else
{
ta.aciklama = null;
}
}
ta.admin_id_ek = Class.Fonksiyonlar.Admin.Genel.AdminID();
db.AddTotbl_dosyalar_kategori(ta);
db.SaveChanges();
#region Admin İşlem Log
Class.Fonksiyonlar.Admin.Log.Islemler(Class.Fonksiyonlar.Admin.Genel.AdminID(), ((EntityObject)(ta)).EntityKey.EntitySetName.ToString(), ta.id, (int)Class.Sabitler.AdminLog.Islemler.Insert);
#endregion
}
}
RSM.ClearSelections();
Store1.DataBind();
TreePanel1.ReloadAsyncNode("0", null);
WindowEkle.Hide();
}
protected void AddNewContactWindowPanel_BeforeHide(object sender, DirectEventArgs e)
{
NewContact_ContactName.Text = null;
NewContact_ContactNumber.Text = null;
NewContact_ContactType.Select(0);
}
protected void CancelNewContactButton_Click(object sender, DirectEventArgs e)
{
AddNewContactWindowPanel.Hide();
}
protected void AddNewAddressBookContact_Click(object sender, DirectEventArgs e)
{
AddNewContactWindowPanel.Show();
}
protected void RejectImportChanges_DirectEvent(object sender, DirectEventArgs e)
{
ImportContactsFromHistoryGrid.GetStore().RejectChanges();
}
private void AddFeedClick(object sender, DirectEventArgs e)
{
ControlUtils.FindControl<FeedWindow>(this.Page).Show();
}
protected void AddressbookTabsPanel_TabChange(object send, DirectEventArgs e)
{
AddressBookGrid.GetStore().Reload();
ImportContactsFromHistoryGrid.GetStore().Reload();
ImportContactsFromOutlookGrid.GetStore().Reload();
}
/// <summary>
/// Save Button Click
/// </summary>
protected void SaveBtn_Click(object sender, DirectEventArgs e)
{
try {
var cacheKey = WebUtility.GetCacheKeyName(UserData, "kpi-report-012");
var result = HttpRuntime.Cache[cacheKey] as List <Report012Entity>;
if (result == null)
{
result = AddDataToCache();
}
if (result == null)
{
WebUtility.ShowMessage(EnmErrType.Warning, "获取数据时发生错误，导出失败！");
return;
}
var datas = new DataTable();
datas.Columns.Add(new DataColumn("序号", typeof(Int32)));
datas.Columns.Add(new DataColumn("Lsc名称", typeof(String)));
datas.Columns.Add(new DataColumn("开关电源一次下电告警总时长（分钟）", typeof(Double)));
datas.Columns.Add(new DataColumn("开关电源累计运行总时长（分钟）", typeof(Int32)));
datas.Columns.Add(new DataColumn("直流系统可用度", typeof(String)));
DataRow row;
for (int i = 0; i < result.Count; i++)
{
var devcnt = 0; var fm = 0d; var interval = 0d;
if (result[i].LscID == -100)
{
devcnt = result.Sum(r => r.Devices.Count) / (result.Count - 1);
fm = devcnt * result[i].EndTime.Subtract(result[i].BeginTime).TotalMinutes;
interval = result.Sum(r => r.Alarms.Sum(alarm => (alarm.EndTime == WebUtility.DefaultDateTime ? result[i].EndTime : alarm.EndTime).Subtract(alarm.StartTime).TotalMinutes)) / (result.Count - 1);
}
else
{
devcnt = result[i].Devices.Count;
fm = devcnt * result[i].EndTime.Subtract(result[i].BeginTime).TotalMinutes;
interval = result[i].Alarms.Sum(alarm => (alarm.EndTime == WebUtility.DefaultDateTime ? result[i].EndTime : alarm.EndTime).Subtract(alarm.StartTime).TotalMinutes);
}
row = datas.NewRow();
row["序号"] = i + 1;
row["Lsc名称"] = result[i].LscName;
row["开关电源一次下电告警总时长（分钟）"] = Math.Round(interval, 2);
row["开关电源累计运行总时长（分钟）"] = Math.Round(fm, 2);
row["直流系统可用度"] = String.Format("{0:P2}", fm != 0 ? (1 - interval / fm) : 1);
datas.Rows.Add(row);
}
var fileName = "KPI-Report012.xls";
var sheetName = "传输机房直流系统可用度";
var title = "动力环境监控中心系统 传输机房直流系统可用度报表";
var subtitle = String.Format("值班员:{0} 日期:{1}", Page.User.Identity.Name, WebUtility.GetDateString(DateTime.Now));
var xls = WebUtility.ExportDataToExcel(fileName, sheetName, title, subtitle, datas);
if (xls != null)
{
xls.Send();
}
} catch (Exception err) {
WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name);
WebUtility.ShowMessage(EnmErrType.Error, err.Message);
}
}
/// <summary>
/// Save Button Click
/// </summary>
protected void SaveBtn_Click(object sender, DirectEventArgs e)
{
try {
var cacheKey = WebUtility.GetCacheKeyName(UserData, "kpi-report-103");
var result = HttpRuntime.Cache[cacheKey] as List <Report103Entity>;
if (result == null)
{
result = AddDataToCache();
}
if (result == null)
{
WebUtility.ShowMessage(EnmErrType.Warning, "获取数据时发生错误，导出失败！");
return;
}
var colNames = e.ExtraParams["ColumnNames"];
var names = new XmlDocument();
names.LoadXml(colNames);
var datas = new XmlDocument();
var root = datas.CreateElement("records");
datas.AppendChild(root);
for (int i = 0; i < result.Count; i++)
{
var parent_Node = datas.CreateElement("record");
root.AppendChild(parent_Node);
var ID_Node = datas.CreateElement("ID");
ID_Node.InnerText = (i + 1).ToString();
parent_Node.AppendChild(ID_Node);
var LscID_Node = datas.CreateElement("LscID");
LscID_Node.InnerText = result[i].Station.LscID.ToString();
parent_Node.AppendChild(LscID_Node);
var LscName_Node = datas.CreateElement("LscName");
LscName_Node.InnerText = result[i].Station.LscName;
parent_Node.AppendChild(LscName_Node);
var Area1Name_Node = datas.CreateElement("Area1Name");
Area1Name_Node.InnerText = result[i].Station.Area1Name;
parent_Node.AppendChild(Area1Name_Node);
var Area2Name_Node = datas.CreateElement("Area2Name");
Area2Name_Node.InnerText = result[i].Station.Area2Name;
parent_Node.AppendChild(Area2Name_Node);
var Area3ID_Node = datas.CreateElement("Area3ID");
Area3ID_Node.InnerText = result[i].Station.Area3Name;
parent_Node.AppendChild(Area3ID_Node);
var Area3Name_Node = datas.CreateElement("Area3Name");
Area3Name_Node.InnerText = result[i].Station.Area3Name;
parent_Node.AppendChild(Area3Name_Node);
var BuildingID_Node = datas.CreateElement("BuildingID");
BuildingID_Node.InnerText = result[i].Station.BuildingID.ToString();
parent_Node.AppendChild(BuildingID_Node);
var BuildingName_Node = datas.CreateElement("BuildingName");
BuildingName_Node.InnerText = result[i].Station.BuildingName == WebUtility.DefaultString ? "--" : result[i].Station.BuildingName;
parent_Node.AppendChild(BuildingName_Node);
var CurrentCapacity_Node = datas.CreateElement("CurrentCapacity");
CurrentCapacity_Node.InnerText = Math.Round(result[i].CurrentCapacity, 2).ToString();
parent_Node.AppendChild(CurrentCapacity_Node);
var DesignCapacity_Node = datas.CreateElement("DesignCapacity");
DesignCapacity_Node.InnerText = result[i].DesignCapacity.ToString();
parent_Node.AppendChild(DesignCapacity_Node);
var Rate_Node = datas.CreateElement("Rate");
Rate_Node.InnerText = String.Format("{0:P2}", result[i].DesignCapacity != 0 ? (result[i].CurrentCapacity / result[i].DesignCapacity) : 1);
parent_Node.AppendChild(Rate_Node);
}
var fileName = "KPI-Report103.xls";
var sheetName = "交流不间断系统负载率";
var title = "动力环境监控中心系统 交流不间断系统负载率报表";
var subTitle = String.Format("值班员:{0} 日期:{1}", Page.User.Identity.Name, WebUtility.GetDateString(DateTime.Now));
var xls = WebUtility.ExportNodesToExcel(fileName, sheetName, title, subTitle, names, datas, false);
if (xls != null)
{
xls.Send();
}
} catch (Exception err) {
WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name);
WebUtility.ShowMessage(EnmErrType.Error, err.Message);
}
}
public void btnReset_Click(object sender, DirectEventArgs e)
{
ClearData();
}
protected void cmdADD(object sender, DirectEventArgs e)
{
this.btnSave.Disabled = false;
this.btnCANCEL.Disabled = false;
this.btnAdd.Disabled = true;
}
///// <summary>
///// GridListHawb 删除事件
///// </summary>
//#region btnDeleteHawb_Click() 删除事件 Author： Micro (2011-09-06)
//protected void btnDeleteHawb_Click(object sender, DirectEventArgs e)
//{
// string RowID = e.ExtraParams["RowID"];
// bool b = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirImport_Joblist_SP", new List<IFields>() { dal.CreateIFields().Append("Option", "DeleteMAWB").Append("air_ROWID", RowID) }).Update();
// if (b)
// X.Msg.Alert("Status", " Deleted successful !!! ").Show();
// else
// X.Msg.Alert("Status", " Deleted failed !!! ").Show();
// GridListBinder();
//}
//#endregion
///// <summary>
///// GridListInvoice 删除事件
///// </summary>
//#region btnDeleteInvoice_Click() 删除事件 Author： Micro (2011-09-06)
//protected void btnDeleteInvoice_Click(object sender, DirectEventArgs e)
//{
// string RowID = e.ExtraParams["RowID"];
// bool b = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirImport_Invoice_SP", new List<IFields>() { dal.CreateIFields().Append("Option", "DeleteActive").Append("inv_ROWID", RowID) }).Update();
// if (b)
// X.Msg.Alert("prompt", " Deleted successful !!! ").Show();
// else
// X.Msg.Alert("prompt", " Deleted failed !!! ").Show();
// GridListBinder();
//}
//#endregion
///// <summary>
///// GridListFlight 删除事件
///// </summary>
//#region btnDeleteFlight_Click() 删除事件 Author： Micro (2011-09-06)
//protected void btnDeleteFlight_Click(object sender, DirectEventArgs e)
//{
// string RowID = e.ExtraParams["RowID"];
// bool b = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirImport_ShipmentRoute_SP", new List<IFields>() { dal.CreateIFields().Append("Option", "Delete").Append("sr_ROWID", RowID) }).Update();
// if (b)
// X.Msg.Alert("prompt", " Deleted successful !!! ").Show();
// else
// X.Msg.Alert("prompt", " Deleted failed !!! ").Show();
// GridListBinder();
//}
//#endregion
#endregion
#region Button 事件处理 Author： Micro (2011-09-06)
/// <summary>
/// Button 事件 保存新增
/// </summary>
#region btnNext_Click() 保存新增 Author：Micro (2011-09-05)
protected void btnNext_Click(object sender, DirectEventArgs e)
{
btnSave_Click(sender, e);
X.Redirect("mawb.aspx");
}
/// <summary>
/// Tạo bảng tính lương
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ChooseSalaryBoardList_Click(Object sender, DirectEventArgs e)
{
if (!string.IsNullOrEmpty(hdfSalaryBoardListID.Text))
{
hdfSalaryBoardId.Text = hdfSalaryBoardListID.Text;
//Lay danh sach bang luong
var boardList = sal_PayrollServices.GetById(Convert.ToInt32(hdfSalaryBoardListID.Text));
if (boardList != null)
{
//TH chua ton tai bang luong thi di tao moi bang luong
var salaryBoard = SalaryBoardInfoController.GetAllBoardInfo(hdfSalaryBoardListID.Text);
if (salaryBoard != null && salaryBoard.Count <= 0)
{
//Lay danh sach nhan vien cua don vi can tinh bang luong
//var listRecordId = TimeSheetCodeController.GetAll(null, null, boardList.DepartmentId, null,
// null, true, null, null, null, null);
//foreach (var item in listRecordId)
//{
// //Tao moi bang tinh luong
// var salaryInfo = new hr_SalaryBoardInfo()
// {
// SalaryBoardId = boardList.Id,
// RecordId = item.RecordId,
// CreatedDate = DateTime.Now,
// };
// //Lay tu timeSheet
// GetDataFromTimeSheet(boardList, salaryInfo);
// //Lay tu sal_SalaryDecision
// GetDataFromSalary(item, salaryInfo);
// hr_SalaryBoardInfoServices.Create(salaryInfo);
//}
}
else
{
if (chk_IsUpdateTimeSheet.Checked)
{
//Truong hop da co bang luong, thi cap nhat lai du lieu tu cham cong cho moi recordId
foreach (var salary in salaryBoard)
{
var salaryInfo = hr_SalaryBoardInfoServices.GetById(salary.Id);
//Lay tu timeSheet
GetDataFromTimeSheet(boardList, salaryInfo);
//Update
hr_SalaryBoardInfoServices.Update(salaryInfo);
}
}
if (chk_IsUpdateSalary.Checked)
{
//Truong hop da co bang luong, thi cap nhat lai du lieu tu luong cho moi recordId
foreach (var salary in salaryBoard)
{
var salaryInfo = hr_SalaryBoardInfoServices.GetById(salary.Id);
//Lay tu sal_SalaryDecision
EditDataSalary(salary.RecordId, salaryInfo);
//Update
hr_SalaryBoardInfoServices.Update(salaryInfo);
}
}
}
}
//Lay danh sach bang luong
Response.Redirect("SalaryBoardInfo.aspx?id=" + hdfSalaryBoardListID.Text);
//Reset
chk_IsUpdateTimeSheet.Checked = false;
}
}
/// <summary>
/// Button 事件 修改保存
/// </summary>
#region btnSave_Click() 修改保存 Author：Micro (2011-09-05)
protected void btnSave_Click(object sender, DirectEventArgs e)
{
object ETA = ControlBinder.getDate(string.IsNullOrEmpty(txtETA.RawText.Trim()) ? DBNull.Value : (object)txtETA.RawText);
object ETD = ControlBinder.getDate(string.IsNullOrEmpty(txtETD.RawText.Trim()) ? DBNull.Value : (object)txtETD.RawText);
object ATD = ControlBinder.getDate(string.IsNullOrEmpty(txtATD.RawText.Trim()) ? DBNull.Value : (object)txtATD.RawText);
object ATA = ControlBinder.getDate(string.IsNullOrEmpty(txtATA.RawText.Trim()) ? DBNull.Value : (object)txtATA.RawText);
if (!string.IsNullOrEmpty(ETA.ToString()) && !string.IsNullOrEmpty(ETD.ToString()) && Convert.ToDateTime(ETD) > Convert.ToDateTime(ETA))
{
ControlBinder.pageTitleMsg(false, "AI:M" + labLotNo.Text, "<p class=\"error\">Status : Saved failed , Error message: ETD Not more than ETA .</p>", div_bottom);
txtETD.Focus(true);
return;
}
if (!string.IsNullOrEmpty(ATD.ToString()) && !string.IsNullOrEmpty(ATA.ToString()) && Convert.ToDateTime(ATD) > Convert.ToDateTime(ATA))
{
ControlBinder.pageTitleMsg(false, "AI:M" + labLotNo.Text, "<p class=\"error\">Status : Saved failed , Error message: ATD Not more than ATA .</p>", div_bottom);
txtATD.Focus(true);
return;
}
DataTable dt = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirImport_Joblist_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "UpdateMAWB")
.Append("air_ROWID", hidRowID.Text.Trim())
.Append("air_MAWB", txtMawb.Text.Replace(" ", "").Trim().ToUpper())
.Append("air_aeLotNo", labAeLotNo.Text.ToUpper())
.Append("air_CompanyReferance", txtReference.Text.Trim().ToUpper())
.Append("imp_Clearance", txtClearence.Text.Trim().ToUpper())
.Append("air_CoLoader", CmbCarrierCode.Value)
.Append("air_Shipper", CmbShipperCode.Value)
.Append("air_Consignee", CmbConsigneeCode.Value)
.Append("air_PartyA", CmbNotify1Code.Value)
.Append("air_PartyB", CmbNotify2Code.Value)
.Append("air_Broker", CmbDischargeCode.Value)
.Append("air_IsDirect", chbDirect.Checked?"1":"0")
.Append("air_Sales", chbDirect.Checked?CmbSalesman.Value.ToUpper():"")
.Append("air_GWT", string.IsNullOrEmpty(txtGWT.Text.Trim())?DBNull.Value:(object)txtGWT.Text)
.Append("air_VWT", string.IsNullOrEmpty(txtVWT.Text.Trim())?DBNull.Value:(object)txtVWT.Text)
.Append("air_CWT", string.IsNullOrEmpty(txtCWT.Text.Trim())?DBNull.Value:(object)txtCWT.Text)
.Append("air_Piece", string.IsNullOrEmpty(txtPiece.Text.Trim())?DBNull.Value:(object)txtPiece.Text)
.Append("air_Unit", CmbUnit.Value)
.Append("air_Pallet", string.IsNullOrEmpty(txtPallet.Text.Trim())?DBNull.Value:(object)txtPallet.Text)
.Append("air_Carrier", CmbCarrierRight.Value)
.Append("air_Flight", txtFlightRight.Text.Trim().ToUpper())
.Append("air_LocLoad", CmbFromRight.Value)
.Append("air_LocDischarge", CmbToRight.Value)
.Append("air_Remark", txtRemark.Text.Trim())
.Append("air_ETD", ControlBinder.getDate(string.IsNullOrEmpty(txtETD.RawText.Trim())?DBNull.Value:(object)txtETD.RawText))
.Append("air_ETA", ControlBinder.getDate(string.IsNullOrEmpty(txtETA.RawText.Trim())?DBNull.Value:(object)txtETA.RawText))
.Append("air_ATD", ControlBinder.getDate(string.IsNullOrEmpty(txtATD.RawText.Trim())?DBNull.Value:(object)txtATD.RawText))
.Append("air_ATA", ControlBinder.getDate(string.IsNullOrEmpty(txtATA.RawText.Trim())?DBNull.Value:(object)txtATA.RawText))
.Append("LastUser", FSecurityHelper.CurrentUserDataGET()[0].ToString())
.Append("air_Seed", hidSeed.Text.Trim())
.Append("air_STAT", FSecurityHelper.CurrentUserDataGET()[12].ToString())
// .Append("air_SYS",FSecurityHelper.CurrentUserDataGET()[11].ToString())
.Append("air_SYS", "AI")
.Append("User", FSecurityHelper.CurrentUserDataGET()[0].ToString())
.Append("code", FSecurityHelper.CurrentUserDataGET()[4].ToString() + "AI")
}).GetTable();
if (dt != null && dt.Rows.Count > 0 && !string.IsNullOrEmpty(dt.Rows[0][1].ToString()))
{
hidSeed.Text = dt.Rows[0][1].ToString();
}
//X.AddScript("saveCost('" + hidSeed.Text + "');");
ucCost.costseed = hidSeed.Text;
ucCost.btnCostEvent(sender, e);
#region///获取FlightRouting列表数据
var ShipmentRoute = JSON.Deserialize <List <ShipmentRoute> >(e.ExtraParams["p_safety_l"]);
#region /// 先Delete 在Update
string rowID = "0,";
for (int i = 0; i < ShipmentRoute.Count; ++i)
{
rowID += ShipmentRoute[i].RowID + ",";
}
rowID = rowID.Substring(0, rowID.Length - 1);
bool d = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirImport_ShipmentRoute_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "Delete")
.Append("sr_ToMaster", hidSeed.Text)
.Append("ROWID", rowID)
}).Update();
List <IFields> list = new List <IFields>();
for (int i = 0; i < ShipmentRoute.Count; ++i)
{
list.Add(dal.CreateIFields().Append("Option", "UpdateList").
Append("sr_Stat", FSecurityHelper.CurrentUserDataGET()[12].ToString()).
Append("sr_ToMaster", hidSeed.Text).
Append("sr_ShipKind", CmbShipperCode.Text).
Append("sr_Carrier", CmbCarrierCode.Text).
Append("sr_OrderID", i).
Append("sr_Vessel", "").
Append("sr_Voyage", "").
Append("User", FSecurityHelper.CurrentUserDataGET()[0].ToString()).
Append("sr_Flight", ShipmentRoute[i].FlightNo.ToUpper()).
Append("sr_From", ShipmentRoute[i].From).
Append("sr_To", ShipmentRoute[i].To).
Append("sr_ETD", ControlBinder.getDate(ShipmentRoute[i].ETD.ToString().StartsWith("0001") ? DBNull.Value : (object)ShipmentRoute[i].ETD)).
Append("sr_ETA", ControlBinder.getDate(ShipmentRoute[i].ETA.ToString().StartsWith("0001") ? DBNull.Value : (object)ShipmentRoute[i].ETA)).
Append("sr_ATD", ControlBinder.getDate(ShipmentRoute[i].ATD.ToString().StartsWith("0001") ? DBNull.Value : (object)ShipmentRoute[i].ATD)).
Append("sr_ATA", ControlBinder.getDate(ShipmentRoute[i].ATA.ToString().StartsWith("0001") ? DBNull.Value : (object)ShipmentRoute[i].ATA)).
Append("sr_ROWID", ShipmentRoute[i].RowID));
}
bool b = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirImport_ShipmentRoute_SP", list).Update();
#endregion
#endregion
#region ///Update HAWB List
var hawbList = JSON.Deserialize <List <HawbList> >(e.ExtraParams["p_safety_3"]);
rowID = "0,";
for (int i = 0; i < hawbList.Count; ++i)
{
rowID += hawbList[i].RowID + ",";
}
rowID = rowID.Substring(0, rowID.Length - 1);
bool h = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirImport_Joblist_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "DeleteMAWB")
.Append("air_ToMAWB", hidSeed.Text)
.Append("str", rowID)
}).Update();
#endregion
#region ///Update Local Invoice
//var InvocieList = JSON.Deserialize<List<Invocie>>(e.ExtraParams["p_safety_4"]);
//rowID = "0,";
//for (int i = 0; i < InvocieList.Count; ++i)
//{
// rowID += InvocieList[i].RowID + ",";
//}
//rowID = rowID.Substring(0, rowID.Length - 1);
//bool inv = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirImport_Invoice_SP", new List<IFields>() { dal.CreateIFields().Append("Option", "DeleteActive")
// .Append("inv_ToMaster",hidSeed.Text)
// .Append("str",rowID)}).Update();
#endregion
if (dt != null)
{
//update cost(Qty,unit,total)
//ControlBinder.UpdateCostData(hidSeed.Text, "AI", "MAWB");
if (ControlBinder.IsDisplayLotNo(ControlBinder.getDate(string.IsNullOrEmpty(txtETA.RawText.Trim()) ? DBNull.Value : (object)txtETA.RawText).ToString(), hidLotNo.Text))
{
btnUpdateLotNo.Show();
}
else
{
btnUpdateLotNo.Hide();
}
txtMawb.Focus(true);
ControlBinder.pageTitleMsg(true, "AI-M:" + labLotNo.Text, "<p class=\"success\">Status : Record Saved with Lot No. <span>" + labLotNo.Text + "</span> </p>", div_bottom);
if (dt != null && dt.Rows.Count > 0 && !string.IsNullOrEmpty(dt.Rows[0][1].ToString()))
{
X.Redirect("mawb.aspx?seed=" + dt.Rows[0][1]);
}
}
else
{
ControlBinder.pageTitleMsg(false, "AI-M:" + labLotNo.Text, "<p class=\"error\">Status : Saved failed ! ! ! </p>", div_bottom);
}
}
/// <summary>
/// Save Button Click
/// </summary>
protected void SaveBtn_Click(object sender, DirectEventArgs e)
{
try {
var cacheKey = WebUtility.GetCacheKeyName(UserData, "alarm-masking-report");
var nodes = HttpRuntime.Cache[cacheKey] as List <AlmMaskEntity>;
if (nodes == null)
{
nodes = AddDataToCache();
}
if (nodes == null)
{
WebUtility.ShowMessage(EnmErrType.Warning, "获取数据时发生错误，导出失败！");
return;
}
var colNames = e.ExtraParams["ColumnNames"];
var names = new XmlDocument();
names.LoadXml(colNames);
var datas = new XmlDocument();
var root = datas.CreateElement("records");
datas.AppendChild(root);
for (int i = 0; i < nodes.Count; i++)
{
var parent_Node = datas.CreateElement("record");
root.AppendChild(parent_Node);
var ID_Node = datas.CreateElement("ID");
ID_Node.InnerText = (i + 1).ToString();
parent_Node.AppendChild(ID_Node);
var LscName_Node = datas.CreateElement("LscName");
LscName_Node.InnerText = nodes[i].LscName;
parent_Node.AppendChild(LscName_Node);
var Area1Name_Node = datas.CreateElement("Area1Name");
Area1Name_Node.InnerText = nodes[i].Area1Name;
parent_Node.AppendChild(Area1Name_Node);
var Area2Name_Node = datas.CreateElement("Area2Name");
Area2Name_Node.InnerText = nodes[i].Area2Name;
parent_Node.AppendChild(Area2Name_Node);
var Area3Name_Node = datas.CreateElement("Area3Name");
Area3Name_Node.InnerText = nodes[i].Area3Name;
parent_Node.AppendChild(Area3Name_Node);
var StaName_Node = datas.CreateElement("StaName");
StaName_Node.InnerText = nodes[i].StaName;
parent_Node.AppendChild(StaName_Node);
var MaskType_Node = datas.CreateElement("MaskType");
MaskType_Node.InnerText = nodes[i].MaskType;
parent_Node.AppendChild(MaskType_Node);
var MaskName_Node = datas.CreateElement("MaskName");
MaskName_Node.InnerText = nodes[i].MaskName;
parent_Node.AppendChild(MaskName_Node);
var MaskTime_Node = datas.CreateElement("MaskTime");
MaskTime_Node.InnerText = nodes[i].MaskTime;
parent_Node.AppendChild(MaskTime_Node);
}
var fileName = "AlarmMaskingReport.xls";
var sheetName = "AlarmMaskingReport";
var title = "动力环境监控中心系统 告警屏蔽报表";
var subTitle = String.Format("值班员:{0} 日期:{1}", Page.User.Identity.Name, WebUtility.GetDateString(DateTime.Now));
var xls = WebUtility.ExportDataToExcel(fileName, sheetName, title, subTitle, names, datas);
if (xls != null)
{
xls.Send();
}
} catch (Exception err) {
WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name);
WebUtility.ShowMessage(EnmErrType.Error, err.Message);
}
}
protected void btnCancel_Click(object sender, DirectEventArgs e)
{
DataBindList();
X.AddScript("BindingCost();");
}
/// <summary>
/// Save Button Click
/// </summary>
protected void SaveBtn_Click(object sender, DirectEventArgs e)
{
try {
var cacheKey = WebUtility.GetCacheKeyName(UserData, "kpi-report-008");
var result = HttpRuntime.Cache[cacheKey] as List <Report008Entity>;
if (result == null)
{
result = AddDataToCache();
}
if (result == null)
{
WebUtility.ShowMessage(EnmErrType.Warning, "获取数据时发生错误，导出失败！");
return;
}
var colNames = e.ExtraParams["ColumnNames"];
var names = new XmlDocument();
names.LoadXml(colNames);
var datas = new XmlDocument();
var root = datas.CreateElement("records");
datas.AppendChild(root);
for (int i = 0; i < result.Count; i++)
{
var parent_Node = datas.CreateElement("record");
root.AppendChild(parent_Node);
var ID_Node = datas.CreateElement("ID");
ID_Node.InnerText = (i + 1).ToString();
parent_Node.AppendChild(ID_Node);
var LscID_Node = datas.CreateElement("LscID");
LscID_Node.InnerText = result[i].LscID.ToString();
parent_Node.AppendChild(LscID_Node);
var LscName_Node = datas.CreateElement("LscName");
LscName_Node.InnerText = result[i].LscName;
parent_Node.AppendChild(LscName_Node);
var ThisCount_Node = datas.CreateElement("ThisCount");
ThisCount_Node.InnerText = result[i].ThisCount.ToString();
parent_Node.AppendChild(ThisCount_Node);
var LastCount_Node = datas.CreateElement("LastCount");
LastCount_Node.InnerText = result[i].LastCount.ToString();
parent_Node.AppendChild(LastCount_Node);
var Rate_Node = datas.CreateElement("Rate");
Rate_Node.InnerText = String.Format("{0:P2}", result[i].LastCount != 0 ? (double)result[i].ThisCount / (double)result[i].LastCount : 1);
parent_Node.AppendChild(Rate_Node);
}
var fileName = "KPI-Report008.xls";
var sheetName = "开关电源带载率";
var title = "动力环境监控中心系统 开关电源带载率报表";
var subTitle = String.Format("值班员:{0} 日期:{1}", Page.User.Identity.Name, WebUtility.GetDateString(DateTime.Now));
var xls = WebUtility.ExportNodesToExcel(fileName, sheetName, title, subTitle, names, datas, false);
if (xls != null)
{
xls.Send();
}
} catch (Exception err) {
WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name);
WebUtility.ShowMessage(EnmErrType.Error, err.Message);
}
}
protected void btnSave_Click(object sender, DirectEventArgs e)
{
if (string.IsNullOrEmpty(CmbReceipt.Value.Trim()))
{
div_bottom.Html = "<p class='error'> Save failed, From can't be empty!</p>";
CmbReceipt.Focus();
return;
}
if (string.IsNullOrEmpty(CmbFinalDest.Value.Trim()))
{
div_bottom.Html = "<p class='error'> Save failed, To can't be empty!</p>";
CmbFinalDest.Focus();
return;
}
if (string.IsNullOrEmpty(txtEst.RawText.Trim()))
{
div_bottom.Html = "<p class='error'> Save failed, Est Receipt can't be empty!</p>";
txtEst.Focus(true);
return;
}
if (string.IsNullOrEmpty(CmbShipperCode.Value.Trim()))
{
div_bottom.Html = "<p class='error'> Save failed, Shipper can't be empty!</p>";
CmbShipperCode.Focus();
return;
}
if (string.IsNullOrEmpty(CmbConsignee.Value.Trim()))
{
div_bottom.Html = "<p class='error'> Save failed, Consignee can't be empty!</p>";
CmbConsignee.Focus();
return;
}
if (string.IsNullOrEmpty(CmbSalesman.Value.Trim()))
{
div_bottom.Html = "<p class='error'> Save failed, Salesman can't be empty!</p>";
CmbSalesman.Focus();
return;
}
if (string.IsNullOrEmpty(txtPiece.Text.Trim()))
{
div_bottom.Html = "<p class='error'> Save failed, Piece(s) can't be empty!</p>";
txtPiece.Focus(true);
return;
}
List <IFields> UpdateHAWB = new List <IFields>();
UpdateHAWB.Add(dal.CreateIFields().Append("Option", "Update")
.Append("air_Seed", hidSeed.Text == ""?null:hidSeed.Text)
.Append("air_ToMAWB", hidMAWB.Text == ""?null:hidMAWB.Text)
.Append("air_HAWB", txtHawb.Text.Trim().ToUpper())
.Append("air_CompanyReferance", txtReference.Text.Trim().ToUpper())
.Append("air_SpecicalDeal", chkSpecial.Checked ? "Y" : "N")
.Append("air_LocReceived", CmbReceipt.Value)
.Append("air_LocFinal", CmbFinalDest.Value)
.Append("air_EReceipt", ControlBinder.getDate(txtEst.RawText.Trim().ToUpper().StartsWith("0001") ? DBNull.Value : (object)txtEst.RawText.Trim()))
.Append("air_AReceipt", ControlBinder.getDate(txtAct.RawText.Trim().ToUpper().StartsWith("0001") ? DBNull.Value : (object)txtAct.RawText.Trim()))
.Append("air_Sales", CmbSalesman.Value)
//.Append("air_CSMode",txtCS.Text)
.Append("air_NP", CmbNP.SelectedItem.Value)
.Append("air_Shipper", CmbShipperCode.Value)
//.Append("air_Shipper", CmbShipperName.SelectedItem.Value)
.Append("air_Consignee", CmbConsignee.Value)
//.Append("air_Consignee", CmbConsigneeName.SelectedItem.Value)
.Append("air_PartyA", CmbNotify1.Value)
//.Append("air_PartyA", CmbNotify1Name.SelectedItem.Value)
.Append("air_PartyB", CmbNotify2.Value)
//.Append("air_PartyB", CmbNotify2Name.SelectedItem.Value)
.Append("air_GWT", string.IsNullOrEmpty(txtGWT.Text) ? DBNull.Value : (object)txtGWT.Text)
.Append("air_VWT", string.IsNullOrEmpty(txtVWT.Text) ? DBNull.Value : (object)txtVWT.Text)
.Append("air_CWT", string.IsNullOrEmpty(txtCWT.Text) ? DBNull.Value : (object)txtCWT.Text)
.Append("air_Piece", string.IsNullOrEmpty(txtPiece.Text) ? DBNull.Value : (object)txtPiece.Text)
.Append("air_Unit", CmbUnit.Value)
.Append("air_Pallet", string.IsNullOrEmpty(txtPallet.Text) ? DBNull.Value : (object)txtPallet.Text)
.Append("air_CBM", string.IsNullOrEmpty(txtCbf.Text) ? DBNull.Value : (object)txtCbf.Text)
.Append("code", FSecurityHelper.CurrentUserDataGET()[4].ToString() + sys)
.Append("code1", FSecurityHelper.CurrentUserDataGET()[4].ToString() + sys + "SN")
.Append("air_STAT", FSecurityHelper.CurrentUserDataGET()[12].ToString())
.Append("air_SYS", sys)
.Append("User", FSecurityHelper.CurrentUserDataGET()[0].ToString())
);
try
{
DataSet ds = GetDs("FW_AirExport_SubShipment_SP", UpdateHAWB);
hidSeed.Text = ds.Tables[0].Rows[0][0].ToString();
string newFlag = ds.Tables[0].Rows[0][1].ToString();
#region HAWBList
var HAWBList = JSON.Deserialize <List <HAWBList> >(e.ExtraParams["p_safety_2"]);
List <IFields> HAWBLists = new List <IFields>();
string RowID = "";
for (int i = 0; i < HAWBList.Count; ++i)
{
HAWBLists.Add(dal.CreateIFields().Append("Option", "UpdateEmptyHAWB").
Append("air_ROWID", HAWBList[i].RowID)
.Append("air_ToHAWB", hidSeed.Text));
RowID += "," + HAWBList[i].RowID.ToString();
}
bool result = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirExport_SubShipment_SP", new List <IFields> {
dal.CreateIFields().Append("Option", "AddSubShipmentByIDList")
.Append("str", RowID).Append("User", FSecurityHelper.CurrentUserDataGET()[0].ToString()).Append("air_ToHAWB", hidSeed.Text)
}).Update();
dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirExport_SubShipment_SP", HAWBLists).Update();
#endregion
#region Costing
//X.AddScript("saveCost('" + hidSeed.Text + "');");
ucCost.costseed = hidSeed.Text;
ucCost.btnCostEvent(sender, e);
#endregion
#region LocalInvoice
//var InvocieList = JSON.Deserialize<List<Invocie>>(e.ExtraParams["p_safety_invoice"]);
//string InvoiceID = "";
//for (int i = 0; i < InvocieList.Count; ++i)
//{
// InvoiceID += "," + InvocieList[i].RowID;
//}
//if (InvoiceID.Length > 1)
//{
// InvoiceID = InvoiceID.Substring(1, InvoiceID.Length - 1);
//}
//bool inv = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirExport_SubShipment_SP", new List<IFields>() { dal.CreateIFields().Append("Option", "DeleteInvoice")
//.Append("air_ToHAWB",hidSeed.Text)
//.Append("str",InvoiceID)}).Update();
#endregion
//update cost(Qty,unit,total)
//ControlBinder.UpdateCostData(hidSeed.Text, "AE", "HAWB");
if (newFlag == "N")
{
DataBindList();
X.AddScript("if(window.opener!=null){if(typeof(window.opener.RefreshList)!='undefined'){window.opener.RefreshList();}}");
ControlBinder.pageTitleMsg(false, "AE-H:" + hidLotNo.Text, "<p class=\"success\">Status : Save successfully ! </p>", div_bottom);
}
else
{
X.AddScript("if(window.opener!=null){if(typeof(window.opener.RefreshList)!='undefined'){window.opener.RefreshList();}}");
ControlBinder.pageTitleMsg(false, "AE-H:" + hidLotNo.Text, "<p class=\"success\">Status : Save successfully ! </p>", div_bottom);
X.Redirect("List.aspx?seed=" + ds.Tables[0].Rows[0][0] + "&MAWB=" + hidMAWB.Value);
}
}
catch
{
ControlBinder.pageTitleMsg(false, "AE-H:" + hidLotNo.Text, "<p class=\"error\">Status : Save failed, please check the data !</p>", div_bottom);
}
}
void OpenClick_Event(object sender, DirectEventArgs e)
{
int[] ids = JSON.Deserialize<int[]>(e.ExtraParams["ids"]);
foreach (int id in ids)
{
new TaskWindow(id).Render();
}
}
protected void btnNext_Click(object sender, DirectEventArgs e)
{
btnSave_Click(sender, e);
X.Redirect("list.aspx?MAWB=" + hidMAWB.Value);
}
void ShowPreview_Toggle(object sender, DirectEventArgs e)
{
GridView view = ControlUtils.FindControl<FeedGrid>(this.Page).View[0];
view.Set("showPreview", bool.Parse(e.ExtraParams["pressed"]));
view.Refresh();
}
void OpenClick_Event(object sender, DirectEventArgs e)
{
int[] ids = JSON.Deserialize<int[]>(e.ExtraParams["ids"]);
foreach (int id in ids)
{
new TaskWindow(id).Render(this.Page.Form.ClientID, RenderMode.RenderTo);
}
}
protected void btnShowReport_Click(object sender, DirectEventArgs e)
{
try
{
var whereList = new List <WhereClause>();
var sql = "(";
if (!string.IsNullOrEmpty(e.ExtraParams["SQL"]))
{
var filter = e.ExtraParams["SQL"].Split(';');
whereList.AddRange(from item in filter
where !string.IsNullOrEmpty(item)
select item.Split('=')
into pair
select new WhereClause
{
WhereField = pair[0],
WhereValue = pair[1]
});
var lastWhere = whereList.OrderBy(t => t.WhereField).FirstOrDefault().WhereField;
foreach (var item in whereList.OrderBy(t => t.WhereField))
{
if (item.WhereField == lastWhere)
{
sql += " " + item.WhereField + " = N'" + item.WhereValue + "' or";
}
else
{
if (sql.EndsWith("or"))
{
sql = sql.Remove(sql.LastIndexOf("or"));
sql += ") and (";
}
else if (sql.EndsWith("and"))
{
sql = sql.Remove(sql.LastIndexOf("and"));
sql += " ) ";
}
sql += " " + item.WhereField + " = N'" + item.WhereValue + "' or";
}
lastWhere = item.WhereField;
}
sql = sql.Remove(sql.LastIndexOf(" ")) + ")";
}
else
{
sql = "1 = 1";
}
var reportFilter = new ReportFilter()
{
ReportTitle = txtReportTitle.Text.Trim(),
RecordId = int.Parse("0" + hdfChonCanBo.Text),
Note = htmlNote.Value.ToString(),
WhereClause = sql,
Reporter = CurrentUser.User.DisplayName,
Gender = cbGender.SelectedItem.Value,
LoaiCanBo = cbCanBo.SelectedItem.Value,
SelectedDepartment = hdfSelectedDepartmentIdList.Text,
SessionDepartment = CurrentUser.DepartmentsTree[0].Id.ToString(),
StartMonth = ReportController.GetInstance().GetStartMonth(cbMonth.SelectedItem.Value),
EndMonth = ReportController.GetInstance().GetEndMonth(cbMonth.SelectedItem.Value),
MinSeniority = int.Parse("0" + txtSeniorityMin.Text),
MaxSeniority = int.Parse("0" + txtSeniorityMax.Text),
MinAge = int.Parse("0" + txtAgeMin.Text),
MaxAge = int.Parse("0" + txtAgeMax.Text),
Title1 = txttieudechuky1.Text,
Title2 = txttieudechuky2.Text,
Title3 = txttieudechuky3.Text,
Name1 = txtnguoiky1.Text,
Name2 = txtnguoiky2.Text,
Name3 = txtnguoiky3.Text,
ReportedDate = dfReportDate.SelectedDate,
BirthPlaceWard = hdfBirthPlaceWardId.Text,
BirthPlaceDistrict = hdfBirthPlaceDistrictId.Text,
BirthPlaceProvince = hdfBirthPlaceProvinceId.Text,
HopDong = cb_HopDong.SelectedItem.Value,
LoginDepartment = string.Join(",", CurrentUser.Departments.Select(d => d.Id)),
TimeSheetReportId = int.Parse("0" + hdfTimeSheetReport.Text),
};
var tbl = hr_RecordServices.GetById(reportFilter.RecordId);
if (tbl != null)
{
reportFilter.EmployeeCode = tbl.EmployeeCode;
}
if (!Util.GetInstance().IsDateNull(dfStartDate.SelectedDate))
{
reportFilter.StartDate = dfStartDate.SelectedDate;
}
if (!Util.GetInstance().IsDateNull(dfEndDate.SelectedDate))
{
reportFilter.EndDate = dfEndDate.SelectedDate;
}
reportFilter.Year = string.IsNullOrEmpty(spfyear.Text) ? DateTime.Now.Year : int.Parse(spfyear.Text);
if (string.IsNullOrEmpty(reportFilter.Gender))
{
reportFilter.Gender = "";
}
var tinhTrang = cbWorkingStatus.SelectedItems.ValuesToJsonArray();
var split = tinhTrang.Split('[', ']', ' ', '"');
tinhTrang = split.Where(item => item.Trim() != "").Aggregate("", (current, item) => current + item);
reportFilter.WorkingStatus = tinhTrang;
Session["rp"] = reportFilter;
var s = Util.GetInstance().RemoveSpaceAndVietnamese(hdfTitle.Text);
RM.RegisterClientScriptBlock("addTabReport",
string.Format(
"addTabReport(pnTabReport,hdfReportID.getValue(),'BaoCao_Main.aspx?type={0}',hdfTitle.getValue());",
s.Replace(",", "")));
RM.RegisterClientScriptBlock("RemoveAndAddNewTab", "RemoveAndAddNewTab('" + hdfReportID.Text + "')");
}
catch (Exception ex)
{
X.MessageBox.Alert("Có lỗi xảy ra", ex.Message).Show();
}
}
protected void btnBack_Click(object sender, DirectEventArgs e)
{
Response.Redirect("~/Modules/Salary/PayrollConfig.aspx");
}
void RowDblClick_Event(object sender, DirectEventArgs e)
{
new TaskWindow(int.Parse(e.ExtraParams["taskId"])).Render(this.Page.Form.ClientID, RenderMode.RenderTo);
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void SendEmailHappyBirthday(object sender, DirectEventArgs e)
{
try
{
var selecteds = RowSelectionModel3.SelectedRows;
var mailto = string.Empty;
var error = "";
//var dt = DataController.DataHandler.GetInstance().ExecuteDataTable("sp_GetAllEmailHappyBirthDayMonth");
var condition = " [BirthDate] IS NOT NULL AND MONTH([BirthDate])='{0}'".FormatWith(DateTime.Now.Month) +
" AND [WorkStatusId] = (SELECT TOP 1 Id FROM cat_WorkStatus WHERE [Name] LIKE N'%Đang làm việc%')";
var dt = RecordController.GetAll(condition);
if (e.ExtraParams["All"] == "True")
{
foreach (var record in dt)
{
if (!string.IsNullOrEmpty(record.WorkEmail))
{
mailto += record.WorkEmail + ", ";
}
else if (!string.IsNullOrEmpty(record.PersonalEmail))
{
mailto += record.PersonalEmail + ", ";
}
else
{
error += record.FullName + " ";
}
}
}
else
{
foreach (var item in selecteds)
{
var maCb = item.RecordID;
foreach (var record in dt)
{
if (record.EmployeeCode != maCb)
{
continue;
}
if (!string.IsNullOrEmpty(record.WorkEmail))
{
mailto += record.WorkEmail + ", ";
}
else if (!string.IsNullOrEmpty(record.PersonalEmail))
{
mailto += record.PersonalEmail + ", ";
}
else
{
Dialog.ShowError("Không tìm thấy email");
return;
}
}
}
}
if (!string.IsNullOrEmpty(error.Trim()))
{
Dialog.ShowError("Một số cán bộ không có email :" + error);
}
}
catch (Exception ex)
{
Dialog.ShowError("Lỗi xảy ra " + ex.Message);
}
}
void Command_Event(object sender, DirectEventArgs e)
{
string command = e.ExtraParams["command"];
switch (command)
{
case "togglestatus":
int taskId = int.Parse(e.ExtraParams["taskId"]);
int categoryID = int.Parse(e.ExtraParams["categoryID"]);
this.ToggleStatus(new int[] { taskId }, null, categoryID, e.ExtraParams["filter"]);
break;
}
}
/// <summary>
/// Query Button Click
/// </summary>
protected void QueryBtn_Click(object sender, DirectEventArgs e)
{
try {
string[] cols = null;
var countType = CountTypeComboBox.SelectedItem.Value;
if (countType.Equals("0"))
{
cols = new string[] { "序号", "Lsc名称" };
}
else if (countType.Equals("1"))
{
cols = new string[] { "序号", "Lsc名称", "地区" };
}
else if (countType.Equals("2"))
{
cols = new string[] { "序号", "Lsc名称", "地区", "县市" };
}
else if (countType.Equals("3"))
{
cols = new string[] { "序号", "Lsc名称", "地区", "县市", "局站" };
}
else
{
return;
}
var grid = MainGridPanel;
var store = grid.GetStore();
store.RemoveFields();
grid.ColumnModel.Columns.Clear();
for (int i = 0; i < cols.Length; i++)
{
var dataIndex = String.Format("Data{0}", i);
store.AddField(new RecordField(dataIndex, RecordFieldType.String), false);
var col = new Column();
col.Header = cols[i];
col.DataIndex = dataIndex;
col.CustomConfig.Add(new ConfigItem("DblClickEnabled", "0", ParameterMode.Value));
col.CustomConfig.Add(new ConfigItem("TitleStyle", cols.Length.ToString(), ParameterMode.Value));
col.Groupable = false;
col.Locked = true;
grid.ColumnModel.Columns.Add(col);
}
//Create Columns
var columns = new String[] { "告警数量" };
var plen = cols.Length;
var nlen = columns.Length;
if (columns.Length > 0)
{
for (int i = 0; i < nlen; i++)
{
var dataIndex = String.Format("Data{0}", plen + i);
store.AddField(new RecordField(dataIndex, RecordFieldType.String), false);
var col = new Column();
col.Header = columns[i];
col.DataIndex = dataIndex;
col.CustomConfig.Add(new ConfigItem("DblClickEnabled", "1", ParameterMode.Value));
col.CustomConfig.Add(new ConfigItem("TitleStyle", cols.Length.ToString(), ParameterMode.Value));
col.Groupable = false;
grid.ColumnModel.Columns.Add(col);
}
}
store.ClearMeta();
grid.Reconfigure();
AddDataToCache();
} catch (Exception err) {
WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name);
WebUtility.ShowMessage(EnmErrType.Error, err.Message);
}
}
protected void btnSaveSystemConfig_Click(object sender, DirectEventArgs e)
{
try
{
SystemConfigWrapper obj = SystemConfigWrapper.FindById(int.Parse(hidSystemConfigID.Text.Trim()));
if (this.cmbGroup.SelectedItem != null)
{
obj.ConfigGroupID = SystemConfigGroupWrapper.FindById(int.Parse(this.cmbGroup.SelectedItem.Value));
}
else
{
obj.ConfigGroupID = null;
}
string configValue = this.txtConfigValue.Text.Trim();
if (this.cmbDataType.SelectedItem.Value.ToString() == DictionaryConst.Dictionary_System_DataType_int_Key)
{
try
{
int.Parse(configValue);
}
catch (Exception ex)
{
ResourceManager.AjaxSuccess = false;
ResourceManager.AjaxErrorMessage = "请输入整数：" + ex.Message;
return;
}
}
else if (this.cmbDataType.SelectedItem.Value.ToString() == DictionaryConst.Dictionary_System_DataType_datetime_Key)
{
try
{
DateTime.Parse(configValue);
}
catch (Exception ex)
{
ResourceManager.AjaxSuccess = false;
ResourceManager.AjaxErrorMessage = "请输入日期时间：" + ex.Message;
return;
}
}
else if (this.cmbDataType.SelectedItem.Value.ToString() == DictionaryConst.Dictionary_System_DataType_bool_Key)
{
try
{
bool.Parse(configValue);
}
catch (Exception ex)
{
ResourceManager.AjaxSuccess = false;
ResourceManager.AjaxErrorMessage = "请输入布尔值：" + ex.Message;
return;
}
}
else if (this.cmbDataType.SelectedItem.Value.ToString() == DictionaryConst.Dictionary_System_DataType_decimal_Key)
{
try
{
decimal.Parse(configValue);
}
catch (Exception ex)
{
ResourceManager.AjaxSuccess = false;
ResourceManager.AjaxErrorMessage = "请输入小数：" + ex.Message;
return;
}
}
obj.ConfigDataType = this.cmbDataType.SelectedItem.Value;
obj.ConfigValue = this.txtConfigValue.Text.Trim();
obj.ConfigDescription = this.txtConfigDescription.Text.Trim();
obj.SortIndex = 1;
SystemConfigWrapper.Update(obj);
winSystemConfigEdit.Hide();
ResourceManager.AjaxSuccess = true;
}
catch (Exception ex)
{
ResourceManager.AjaxSuccess = false;
ResourceManager.AjaxErrorMessage = string.Format(GetGlobalResourceObject("GlobalResource", "msgShowError").ToString(), ex.Message);
return;
}
}
protected void AddSoft(object sender, DirectEventArgs e)
{
EditSoft(true, e);
}
