protected void Page_Load(object sender, EventArgs e)
{
if (Request.Cookies["user"] == null)
{
Response.Redirect("~/Default.aspx");
}
else
{
if (!new UserSecurity().CheckFormPermission((int)Global.formSecurity.AllGLAccounts, Request.Cookies["user"]["Permission"].ToString()))
{
Response.Redirect("~/Finance_Module/UnAuthorized.aspx");
}
}
if (!IsPostBack)
{
ASPxTreeList1.DataBind();
TreeListNode firstUnread = ASPxTreeList1.FindNodeByFieldValue("IsNew", true);
// firstUnread.Focus();
ASPxTreeList1.ExpandToLevel(2);
}
GLAccount gl = new GLAccount();
DataTable dt = gl.getList();
ASPxTreeList1.DataSource = dt;
ASPxTreeList1.DataBind();
AddSubmitEvent();
if (!IsPostBack)
{
if (Request.QueryString["alert"] == "success")
{
Response.Write("<script>alert('تم الحفظ بنجاح.');</script>");
}
}
}
void SaveState()
{
const string prefix = "mycheck_";
foreach (string key in Request.Params)
{
string value = Request.Params[key];
if (key == "myradio")
{
StartNodeKey = value;
}
if (key.StartsWith(prefix) && !string.IsNullOrEmpty(value))
{
string nodeKey = key.Substring(prefix.Length);
if (value == "H")
{
HiddenNodeList.Add(nodeKey);
}
else if (value == "V")
{
HiddenNodeList.Remove(nodeKey);
}
ASPxTreeList1.DataBind();
}
}
}
protected void BayiEditPopup_WindowCallback(object source, DevExpress.Web.PopupWindowCallbackArgs e)
{
var roleGuid = e.Parameter.ToString();
Guid guid = new Guid(roleGuid);
var list2 = db.S_MenuYetkileri(3, guid).ToList();
if (list2.Count > 0)
{
ASPxTreeList1.DataSource = list2;
}
else
{
ASPxTreeList1.DataSource = null;
}
ASPxTreeList1.DataBind();
ASPxTreeList1.SettingsSelection.Recursive = true;
ASPxTreeList1.ExpandToLevel(2);
foreach (var item in list2.ToList())
{
if ((bool)item.Checkbox)
{
ASPxTreeList1.FindNodeByFieldValue("ID", item.ID).Selected = true;
}
else
{
ASPxTreeList1.FindNodeByFieldValue("ID", item.ID).Selected = false;
}
}
RoleEditPopup.JSProperties["cpEmployeeID"] = roleGuid;
RoleEditPopup.JSProperties["cpHeaderText"] = string.Format("Role Düzenle, ({0} {1})", "Guid", roleGuid);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ASPxTreeList1.DataBind();
ASPxTreeList1.ExpandToLevel(2);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack && !IsCallback)
{
ASPxTreeList1.DataBind();
ASPxTreeList1.ExpandAll();
}
}
protected override void OnInit(EventArgs e)
{
base.OnInit(e);
session = new Session();
XpoDataSource1.Session = session;
ASPxTreeList1.KeyFieldName = "Oid";
ASPxTreeList1.ParentFieldName = "Parent!Key";
ASPxTreeList1.DataBind();
}
protected void Page_Init(object sender, EventArgs e)
{
var datasource = new[]
{
new { OrganizationId = 1, ParentOrganizationId = 0, name = "Kho 1", Description = "Phòng Nhân sự", Email = "*****@*****.**", Address = "Phòng Nhân sự", PhoneNo = "123456879" },
new { OrganizationId = 2, ParentOrganizationId = 1, name = "Dãy 1.1", Description = "Phòng Kế toán", Email = "*****@*****.**", Address = "Phòng Nhân sự", PhoneNo = "123456879" },
new { OrganizationId = 3, ParentOrganizationId = 2, name = "Kệ 1.1.1", Description = "Bộ phận Kế toán tổng hợp", Email = "*****@*****.**", Address = "Bộ phận Kế toán tổng hợp", PhoneNo = "123456879" },
new { OrganizationId = 4, ParentOrganizationId = 3, name = "Học1.1.1.1", Description = "Bộ phận Kế toán nội bộ", Email = "*****@*****.**", Address = "Bộ phận Kế toán nội bộ", PhoneNo = "123456879" }
};
ASPxTreeList1.DataSource = datasource;
ASPxTreeList1.DataBind();
grdData0.DataSource =
new[] {
new { key = "123", code = "ML0001", name = "Nguyễn văn A", date = "25-07-2013", warehouse = "Kho1",
status = "Đã sắp xếp" },
new { key = "1234", code = "ML0002", name = "Nguyễn văn B", date = "25-07-2013", warehouse = "Kho2",
status = "Chưa sắp xếp" },
};
grdData0.KeyFieldName = "key";
grdData0.DataBind();
//grdData.DataSource =
// new[] {
// new { key="123", code = "MAT001", name = "Mặt hàng 1", lot="123", date="25-5-2014", reciept = "HD001",
// recieptamount="100", unit="Thùng", description = "Mặt hàng 1"
// },
// new { key="1234", code = "MAT002", name = "Mặt hàng 2", lot="1234", date="25-7-2015",reciept = "HD001",
// recieptamount="150", unit="Hộp", description = "Mặt hàng 2"
// },
// };
//grdData.KeyFieldName = "key";
//grdData.DataBind();
grdDataAccept.DataSource =
new[] {
new { key = "123", code = "MAT001", name = "Mặt hàng 1", lot = "123", reciept = "HD001", date = "25/09/2014",
sortamount = "90", realamount = "90", difamount = "10", unit = "Thùng", description = "Mặt hàng 1" },
new { key = "1234", code = "MAT002", name = "Mặt hàng 2", lot = "1234", reciept = "HD001", date = "25/09/2014",
sortamount = "130", realamount = "130", difamount = "20", unit = "Hộp", description = "Mặt hàng 2" },
};
grdDataAccept.KeyFieldName = "key";
grdDataAccept.DataBind();
ASPxGridView1.DataSource =
new[] {
new { key = "123", code = "MAT001", name = "Mặt hàng 1", lot = "123", date = "25-5-2014", reciept = "HD001",
recieptamount = "100", unit = "Thùng", description = "Mặt hàng 1", position = "Kho 1; Dãy B; Kệ 5" },
new { key = "1234", code = "MAT002", name = "Mặt hàng 2", lot = "1234", date = "25-7-2015", reciept = "HD001",
recieptamount = "150", unit = "Hộp", description = "Mặt hàng 2", position = "Kho 1; Dãy B; Kệ 6" },
};
ASPxGridView1.KeyFieldName = "key";
ASPxGridView1.DataBind();
}
protected void Page_Init(object sender, EventArgs e)
{
if (!IsPostBack)
{
Session.Clear();
}
ASPxTreeList1.DataSource = DataHelper.GetData();
ASPxTreeList1.DataBind();
ASPxTreeList1.ExpandAll();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ASPxTreeList1.DataBind();
ASPxTreeList1.ExpandAll();
if (ASPxTreeList1.FocusedNode == null)
{
ASPxTreeList1.Nodes[0].Focus();
}
ASPxTreeList1.StartEdit(ASPxTreeList1.FocusedNode.Key);
}
}
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
if (!IsPostBack)
{
ASPxTreeList1.DataBind();
ASPxTreeList1.ExpandToLevel(2);
}
if (IsPostBack)
{
SaveState();
}
}
private void BuildTree()
{
try
{
var _Catss = st.Load_sitemap();
ASPxTreeList1.DataSource = _Catss;
ASPxTreeList1.DataBind();
}
catch (Exception ex)
{
clsVproErrorHandler.HandlerError(ex);
}
}
/*
* UnitOfWork uow;
* ViewProduct viewProduct;
* ViewProductSupplier viewProductSupplier;
*
* Product product;
* ProductProperty productProperty;
* ProductSupplier productSupplier;
* Manufacturer manufacturer;
* Supplier supplier;
*/
// sqlConnection.ConnectionString = ConfigurationManager.ConnectionStrings["SqlConnectString"].ToString();
// Customer function
/*
* private bool validate()
* {
* bool isValid = true;
*
* uow = new UnitOfWork(ConnectionHelper.GetDataLayer(DevExpress.Xpo.DB.AutoCreateOption.SchemaAlreadyExists));
* viewProduct = (ViewProduct)Session["productMode"];
*
* string oldCode = "";
* string oldName = "";
*
* if (viewProduct != null)
* {
* oldCode = viewProduct.Code;
* oldName = viewProduct.Name;
* }
*
* product = uow.FindObject<Product>(new BinaryOperator("Code", txtCode.Text));
*
* if (product != null && oldCode != txtCode.Text)
* {
* txtCode.ValidationSettings.ErrorText = "Mã Hàng Hóa này đã tồn tại !";
* isValid = false;
* }
*
* productProperty = uow.FindObject<ProductProperty>(new BinaryOperator("Name", txtName.Text));
*
* if (productProperty != null && oldName != txtName.Text)
* {
* txtName.ValidationSettings.ErrorText = "Tên Hàng Hóa này đã tồn tại !";
* isValid = false;
* }
*
* return isValid;
* }
*/
private void BindGrid()
{
var datasource = new[]
{
new { OrganizationId = 1, ParentOrganizationId = 0, code = "MS001", name = "Thùng lớn", Description = "Thùng lớn là đơn vị tính cao nhất", amount = "" },
new { OrganizationId = 2, ParentOrganizationId = 1, code = "LT002", name = "Hợp lớn", Description = "1 Thùng lớn chứa 20 Hộp lớn", amount = "20" },
new { OrganizationId = 3, ParentOrganizationId = 2, code = "LT003", name = "Vĩ", Description = "1 Hộp lớn chứa 30 Vĩ", amount = "30" },
new { OrganizationId = 4, ParentOrganizationId = 3, code = "LT004", name = "Viên nén tròn", Description = "1 Vĩ chứa 12 Viên nén tròn", amount = "12" }
};
ASPxTreeList1.DataSource = datasource;
ASPxTreeList1.DataBind();
}
private void BindGrid()
{
var datasource = new[]
{
new { OrganizationId = 1, ParentOrganizationId = 0, code = "LT001", name = "Khu 1", Description = "Khu 1 là đơn vị lưu trữ cao nhất", amount = "" },
new { OrganizationId = 2, ParentOrganizationId = 1, code = "LT002", name = "Dãy", Description = "Mỗi Khu 1 có 5 Dãy", amount = "5" },
new { OrganizationId = 3, ParentOrganizationId = 2, code = "LT003", name = "Kệ", Description = "Mỗi Dãy có 7 Kệ", amount = "7" },
new { OrganizationId = 4, ParentOrganizationId = 3, code = "LT004", name = "Học", Description = "Mỗi Kệ có 10 Học", amount = "10" }
};
ASPxTreeList1.DataSource = datasource;
ASPxTreeList1.DataBind();
}
protected void Page_Init(object sender, EventArgs e)
{
object[] grdDataSource = new[] {
new { key = "123", code = "MAT001", name = "Mặt hàng 1", lot = "123", reciept = "HD001",
recieptamount = "100", realamount = "90", difamount = "10", unit = "Thùng", description = "Mặt hàng 1",
entry = "Đã điều chỉnh" },
new { key = "1234", code = "MAT002", name = "Mặt hàng 2", lot = "1234", reciept = "HD001",
recieptamount = "150", realamount = "130", difamount = "20", unit = "Hộp", description = "Mặt hàng 2",
entry = "Chưa điều chỉnh" },
};
/*StreamReader reader = new StreamReader(Server.MapPath("/Purchasing/datasource/hierarchy.xml"));
* try
* {
* XmlDataSource1.Data = reader.ReadToEnd();
* }
* finally
* {
* reader.Close();
* }
* ASPxTreeList1.DataSourceID = "XmlDataSource1";*/
var datasource = new[]
{
new { OrganizationId = 1, ParentOrganizationId = 0, name = "Kho 1", Description = "Phòng Nhân sự", Email = "*****@*****.**", Address = "Phòng Nhân sự", PhoneNo = "123456879" },
new { OrganizationId = 2, ParentOrganizationId = 1, name = "Dãy 1.1", Description = "Phòng Kế toán", Email = "*****@*****.**", Address = "Phòng Nhân sự", PhoneNo = "123456879" },
new { OrganizationId = 3, ParentOrganizationId = 2, name = "Kệ 1.1.1", Description = "Bộ phận Kế toán tổng hợp", Email = "*****@*****.**", Address = "Bộ phận Kế toán tổng hợp", PhoneNo = "123456879" },
new { OrganizationId = 4, ParentOrganizationId = 3, name = "Học1.1.1.1", Description = "Bộ phận Kế toán nội bộ", Email = "*****@*****.**", Address = "Bộ phận Kế toán nội bộ", PhoneNo = "123456879" }
};
ASPxTreeList1.DataSource = datasource;
ASPxTreeList1.DataBind();
grdData.DataSource = grdDataSource;
grdData.KeyFieldName = "key";
grdData.DataBind();
grvConfirmData.DataSource = grdDataSource;
grvConfirmData.DataBind();
grdDataAccept.DataSource =
new[] {
new { key = "123", code = "MAT001", name = "Mặt hàng 1", lot = "123", reciept = "HD001",
recieptamount = "90", realamount = "90", difamount = "10", unit = "Thùng", description = "Mặt hàng 1" },
new { key = "1234", code = "MAT002", name = "Mặt hàng 2", lot = "1234", reciept = "HD001",
recieptamount = "130", realamount = "130", difamount = "20", unit = "Hộp", description = "Mặt hàng 2" },
};
grdDataAccept.KeyFieldName = "key";
grdDataAccept.DataBind();
}
void Bind()
{
if (Session[Key] != null)
{
try {
XmlDataSource1.Data = Session[Key].ToString();
ASPxTreeList1.DataSourceID = XmlDataSource1.ID;
ASPxTreeList1.DataBind();
} catch {
Session[Key] = null;
throw;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
var datasource = new[]
{
new { OrganizationId = 1, ParentOrganizationId = 0, LoaiTaiKhoan = "Tài Sản Lưu Động", SoTaiKhoan = "111", Cap = "1", TenTaiKhoan = "Tiền Mặt", GhiChu = "Là Tài Khoản Tiền Mặt" },
new { OrganizationId = 2, ParentOrganizationId = 1, LoaiTaiKhoan = "Tài Sản Lưu Động", SoTaiKhoan = "1111", Cap = "2", TenTaiKhoan = "Tiền Việt Nam", GhiChu = "Là Tài Khoản Tiền Việt Nam" },
new { OrganizationId = 3, ParentOrganizationId = 1, LoaiTaiKhoan = "Tài Sản Lưu Động", SoTaiKhoan = "1112", Cap = "2", TenTaiKhoan = "Ngoại Tệ", GhiChu = "Là Ngoại Tệ" },
new { OrganizationId = 4, ParentOrganizationId = 0, LoaiTaiKhoan = "Tài Sản Lưu Động", SoTaiKhoan = "112", Cap = "1", TenTaiKhoan = "Tiền Gửi Ngân Hàng", GhiChu = "Là Tiền Gửi Ngân Hàng" },
new { OrganizationId = 5, ParentOrganizationId = 4, LoaiTaiKhoan = "Tài Sản Lưu Động", SoTaiKhoan = "1121", Cap = "2", TenTaiKhoan = "Tiền Việt Nam", GhiChu = "Là Tài Khoản Tiền Việt Nam" },
new { OrganizationId = 6, ParentOrganizationId = 4, LoaiTaiKhoan = "Tài Sản Lưu Động", SoTaiKhoan = "1122", Cap = "2", TenTaiKhoan = "Ngoại Tệ", GhiChu = "Là Ngoại Tệ" },
new { OrganizationId = 7, ParentOrganizationId = 3, LoaiTaiKhoan = "Tài Sản Lưu Động", SoTaiKhoan = "1112.1", Cap = "3", TenTaiKhoan = "Vàng Bạc, Kim Khí Quí, Đá Quí", GhiChu = "Là Vàng Bạc, Kim Khí Quí, Đá Quí" }
};
ASPxTreeList1.DataSource = datasource;
ASPxTreeList1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
var datasource = new[]
{
new { OrganizationId = 1, ParentOrganizationId = 0, name = "Kho 1", Description = "Phòng Nhân sự", Email = "*****@*****.**", Address = "Phòng Nhân sự", PhoneNo = "123456879" },
new { OrganizationId = 2, ParentOrganizationId = 1, name = "Dãy 1.1", Description = "Phòng Kế toán", Email = "*****@*****.**", Address = "Phòng Nhân sự", PhoneNo = "123456879" },
new { OrganizationId = 3, ParentOrganizationId = 2, name = "Kệ 1.1.1", Description = "Bộ phận Kế toán tổng hợp", Email = "*****@*****.**", Address = "Bộ phận Kế toán tổng hợp", PhoneNo = "123456879" },
new { OrganizationId = 4, ParentOrganizationId = 3, name = "Học1.1.1.1", Description = "Bộ phận Kế toán nội bộ", Email = "*****@*****.**", Address = "Bộ phận Kế toán nội bộ", PhoneNo = "123456879" }
};
ASPxTreeList1.DataSource = datasource;
ASPxTreeList1.DataBind();
InitPivotGrid();
BindChart();
}
protected void Save_Click(object sender, EventArgs e)
{
int parent = 0;
int.TryParse(Parent.SelectedValue.ToString(), out parent);
bool result = insert_tree_record(Name_Ar.Text, Name_En.Text, parent);
if (result)
{
ASPxTreeList1.DataBind();
Parent.DataBind();
Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "HideTheModel(); notify('top', 'right', 'fa fa-check', 'success', 'animated fadeInRight', 'animated fadeOutRight',' Save Status : ',' The new Structure was Sucessfully saved in system ! ');", true);
}
}
private void BindTreeList()
{
ASPxTreeList1.DataSource = GetData();
ASPxTreeList1.KeyFieldName = "ID";
ASPxTreeList1.ParentFieldName = "ParentID";
ASPxTreeList1.EnableCallbacks = false;
ASPxTreeList1.SettingsBehavior.AllowFocusedNode = true;
ASPxTreeList1.SettingsBehavior.ProcessFocusedNodeChangedOnServer = true;
if (ASPxTreeList1.Columns.Count == 0)
{
DevExpress.Web.ASPxTreeList.TreeListDataColumn col = new DevExpress.Web.ASPxTreeList.TreeListDataColumn();
col.FieldName = "Name";
ASPxTreeList1.Columns.Add(col);
}
ASPxTreeList1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
grid_productgrp.DataSource = new[] {
new{
productgrp_id = "MNHH0001",
productgrp_name = "Nhóm đặc trị 1",
description = "",
note = ""
},
new{
productgrp_id = "MNHH0002",
productgrp_name = "Nhóm đặc trị 2",
description = "",
note = ""
},
new{
productgrp_id = "MNHH0003",
productgrp_name = "Nhóm đặc trị 3",
description = "",
note = ""
},
};
grid_productgrp.DataBind();
grid_manufacturer.DataSource = new[] {
new { supplierid = "MNCC00009",
suppliername = "Nhà cung cấp 9",
description = "" },
new { supplierid = "MNCC00010",
suppliername = "Nhà cung cấp 10",
description = "" },
};
grid_manufacturer.DataBind();
var datasource = new[]
{
new { OrganizationId = 1, ParentOrganizationId = 0, code = "MS001", name = "Thùng lớn", description = "Thùng lớn là đơn vị tính cao nhất", amount = "" },
new { OrganizationId = 2, ParentOrganizationId = 1, code = "LT002", name = "Hợp lớn", description = "1 Thùng lớn chứa 20 Hộp lớn", amount = "20" },
new { OrganizationId = 3, ParentOrganizationId = 2, code = "LT003", name = "Vĩ", description = "1 Hộp lớn chứa 30 Vĩ", amount = "30" },
new { OrganizationId = 4, ParentOrganizationId = 3, code = "LT004", name = "Viên nén tròn", description = "1 Vĩ chứa 12 Viên nén tròn", amount = "12" }
};
ASPxTreeList1.DataSource = datasource;
ASPxTreeList1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
AccountingBO accountBO = new AccountingBO();
//accountBO.InitBalanceForward(session, AccountingPeriodBO.getCurrentAccountingPeriod(session));
var datasource1 = accountBO.getLedgerListByAccountCategory(session, "ASSET");
var datasource2 = accountBO.getLedgerListByAccountCategory(session, "LIABILITY");
var datasource3 = accountBO.getLedgerListByAccountCategory(session, "EQUITY");
ASPxTreeList1.DataSource = datasource1;
ASPxTreeList2.DataSource = datasource2;
ASPxTreeList3.DataSource = datasource3;
ASPxTreeList1.DataBind();
ASPxTreeList2.DataBind();
ASPxTreeList3.DataBind();
XPQuery <AccountCategory> AccCateQuery = session.Query <AccountCategory>();
General gen = new General();
AccountCategory AccCate = AccCateQuery.Where(r => r.Code == "ASSET").FirstOrDefault();
totalAsset = gen.TotalBalance(session, AccCate);
AccCate = AccCateQuery.Where(r => r.Code == "LIABILITY").FirstOrDefault();
totalLiability = gen.TotalBalance(session, AccCate);
AccCate = AccCateQuery.Where(r => r.Code == "EQUITY").FirstOrDefault();
totalEquity = gen.TotalBalance(session, AccCate);
ASPxTextBox tb1 = ASPxTreeList1.FindFooterTemplateControl(ASPxTreeList1.Columns[2], "AssetTotal") as ASPxTextBox;
tb1.Value = ParseStringNumber(totalAsset.ToString());
tb1.Text = ParseStringNumber(totalAsset.ToString());
ASPxTextBox tb2 = ASPxTreeList2.FindFooterTemplateControl(ASPxTreeList2.Columns[2], "LiabilityTotal") as ASPxTextBox;
tb2.Value = ParseStringNumber(totalLiability.ToString());
tb2.Text = ParseStringNumber(totalLiability.ToString());
ASPxTextBox tb3 = ASPxTreeList3.FindFooterTemplateControl(ASPxTreeList3.Columns[2], "EquityTotal") as ASPxTextBox;
tb3.Value = ParseStringNumber(totalEquity.ToString());
tb3.Text = ParseStringNumber(totalEquity.ToString());
ASPxTextBox tb4 = ASPxTreeList3.FindFooterTemplateControl(ASPxTreeList3.Columns[2], "DebitTotal") as ASPxTextBox;
tb4.Value = ParseStringNumber((totalLiability + totalEquity).ToString());
tb4.Text = ParseStringNumber((totalLiability + totalEquity).ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
//AccountType accountType = session.GetObjectByKey<AccountType>(cbAccountType.Value);
//CriteriaOperator criteria;
//criteria = new BinaryOperator("AccountTypeId", accountType.AccountTypeId);
//AccountXPO.Criteria = criteria.ToString();
ASPxTreeList1.DataSourceID = "AccountXPO";
ASPxTreeList1.KeyFieldName = "AccountId";
ASPxTreeList1.DataBind();
//if (cbAccountType.Value != null)
//{
// if (cbAccountType.Value.ToString() != "")
// {
// Guid guid = Guid.Parse(cbAccountType.Value.ToString());
// AccountType accountType = session.GetObjectByKey<AccountType>(guid);
// CriteriaOperator criteria = new BinaryOperator("AccountTypeId!Key", accountType.AccountTypeId);
// AccountXPO.Criteria = criteria.ToString();
// ASPxTreeList1.DataBind();
// }
//}
}
/// <summary>
/// 绑定数据到AspxTreeList1
/// </summary>
private void bindData()
{
userManager theUserManager = (userManager)Session["theUserManager"];
this.TranslateASPxControl(ASPxTreeList1);
theCompanyCode = theUserManager.getCompanyCode();
//theContentPrintSql = "SELECT * FROM CODE_MENU WHERE COMPANY_CODE='" + theCompanyCode + "' ORDER BY MENU_INDEX";
//DataTable dt = conn.GetTable(theContentPrintSql);
ASPxTreeList1.KeyFieldName = "MENU_CODE";
ASPxTreeList1.ParentFieldName = "MENU_CODE_FATHER";
ASPxTreeList1.SettingsEditing.Mode = DevExpress.Web.ASPxTreeList.TreeListEditMode.PopupEditForm;
ASPxTreeList1.SettingsPopupEditForm.HorizontalAlign = DevExpress.Web.ASPxClasses.PopupHorizontalAlign.Center;
ASPxTreeList1.SettingsPopupEditForm.VerticalOffset = 10;
//caoly 20130110 改成离当前行下面10个像素正中间弹出修改或新增框，原来下面的一句是整个页面的正中间，不容易找到
//ASPxTreeList1.SettingsPopupEditForm.VerticalAlign = DevExpress.Web.ASPxClasses.PopupVerticalAlign.WindowCenter;
ASPxTreeList1.SettingsPopupEditForm.AllowResize = true;
ASPxTreeList1.SettingsPopupEditForm.Modal = true;
ASPxTreeList1.SettingsPopupEditForm.Width = 500;
ASPxTreeList1.SettingsPopupEditForm.Caption = "菜单编辑";
//ASPxTreeList1.DataSource = dt;
ASPxTreeList1.DataSource = MenuItemFactory.GetByCompany(theCompanyCode);
ASPxTreeList1.DataBind();
ASPxTreeList1.SettingsEditing.AllowNodeDragDrop = true;
ASPxTreeList1.ProcessDragNode += new DevExpress.Web.ASPxTreeList.TreeListNodeDragEventHandler(ASPxTreeList1_ProcessDragNode);
ASPxTreeList1.CellEditorInitialize += new DevExpress.Web.ASPxTreeList.TreeListColumnEditorEventHandler(ASPxTreeList1_CellEditorInitialize);
ASPxTreeList1.NodeValidating += new DevExpress.Web.ASPxTreeList.TreeListNodeValidationEventHandler(ASPxTreeList1_NodeValidating);
ASPxTreeList1.NodeInserting += new DevExpress.Web.Data.ASPxDataInsertingEventHandler(ASPxTreeList1_NodeInserting);
ASPxTreeList1.NodeUpdating += new DevExpress.Web.Data.ASPxDataUpdatingEventHandler(ASPxTreeList1_NodeUpdating);
ASPxTreeList1.NodeDeleting += new DevExpress.Web.Data.ASPxDataDeletingEventHandler(ASPxTreeList1_NodeDeleting);
}
private void bindData()
{
userManager theUserManager = (userManager)Session["theUserManager"];
this.TranslateASPxControl(ASPxTreeList1);
theCompanyCode = theUserManager.getCompanyCode();
theContentPrintSql = "select * from code_work_unit";
DataTable dt = conn.GetTable(theContentPrintSql);
ASPxTreeList1.KeyFieldName = "WORKUNIT_CODE";
ASPxTreeList1.ParentFieldName = "WORKUNIT_PARENTCODE";
ASPxTreeList1.SettingsEditing.Mode = DevExpress.Web.ASPxTreeList.TreeListEditMode.PopupEditForm;
ASPxTreeList1.SettingsPopupEditForm.HorizontalAlign = DevExpress.Web.ASPxClasses.PopupHorizontalAlign.Center;
ASPxTreeList1.SettingsPopupEditForm.VerticalAlign = DevExpress.Web.ASPxClasses.PopupVerticalAlign.WindowCenter;
ASPxTreeList1.SettingsPopupEditForm.AllowResize = true;
ASPxTreeList1.SettingsPopupEditForm.Modal = true;
ASPxTreeList1.SettingsPopupEditForm.Width = 500;
ASPxTreeList1.SettingsPopupEditForm.Caption = "工作单元编辑";
ASPxTreeList1.DataSource = dt;
ASPxTreeList1.DataBind();
ASPxTreeList1.CollapseAll();
ASPxTreeList1.ExpandToLevel(2);
//ASPxTreeList1.SettingsEditing.AllowNodeDragDrop = true;
//ASPxTreeList1.ProcessDragNode += new DevExpress.Web.ASPxTreeList.TreeListNodeDragEventHandler(ASPxTreeList1_ProcessDragNode);
ASPxTreeList1.CellEditorInitialize += new DevExpress.Web.ASPxTreeList.TreeListColumnEditorEventHandler(ASPxTreeList1_CellEditorInitialize);
//ASPxTreeList1.NodeValidating += new DevExpress.Web.ASPxTreeList.TreeListNodeValidationEventHandler(ASPxTreeList1_NodeValidating);
//ASPxTreeList1.NodeInserting += new DevExpress.Web.Data.ASPxDataInsertingEventHandler(ASPxTreeList1_NodeInserting);
ASPxTreeList1.NodeUpdating += new DevExpress.Web.Data.ASPxDataUpdatingEventHandler(ASPxTreeList1_NodeUpdating);
//ASPxTreeList1.NodeDeleting += new DevExpress.Web.Data.ASPxDataDeletingEventHandler(ASPxTreeList1_NodeDeleting);
//ASPxTreeList1.HtmlRowPrepared += new DevExpress.Web.ASPxTreeList.TreeListHtmlRowEventHandler(ASPxTreeList1_HtmlRowPrepared);
//ASPxTreeList1.HtmlDataCellPrepared += new DevExpress.Web.ASPxTreeList.TreeListHtmlDataCellEventHandler(ASPxTreeList1_HtmlDataCellPrepared);
//ASPxTreeList1.ParseValue += new DevExpress.Web.Data.ASPxParseValueEventHandler(ASPxTreeList1_ParseValue);
}
//void ASPxTreeList1_NodeInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
//{
// string result = this.parseMenuData(false,
// operate.AddNew,
// theCompanyCode,
// O2S(e.NewValues["MENU_CODE"]),
// O2S(e.NewValues["MENU_NAME"]),
// O2S(e.NewValues["MENU_NAME_EN"]),
// O2S(e.NewValues["MENU_CODE_FATHER"]),
// O2S(e.NewValues["MENU_LEVEL"]),
// O2S(e.NewValues["MENU_INDEX"]),
// O2S(e.NewValues["LEAF_FLAG"]),
// O2S(e.NewValues["PROGRAM_CODE"])
// );
// if (result.Length > 0)
// {
// e.Cancel = false;
// }
// else
// {
// ASPxTreeList1.CancelEdit();
// e.Cancel = true;
// bindData();
// }
//}
private void bindData()
{
userManager theUserManager = (userManager)Session["theUserManager"];
this.TranslateASPxControl(ASPxTreeList1);
theCompanyCode = theUserManager.getCompanyCode();
theContentPrintSql = "Select * from (SELECT A.*,B.TEAM_CODE FROM AAA12020 A LEFT JOIN REL_PROCESS_TEAM B ON A.工艺序号=B.PROCESS_NUM WHERE 装入序号 IS NOT NULL AND 批次=2 ORDER BY 装入序号,工艺序号) where rownum<6000";
DataTable dt = conn.GetTable(theContentPrintSql);
ASPxTreeList1.KeyFieldName = "工艺序号";
ASPxTreeList1.ParentFieldName = "装入序号";
ASPxTreeList1.SettingsEditing.Mode = DevExpress.Web.ASPxTreeList.TreeListEditMode.PopupEditForm;
ASPxTreeList1.SettingsPopupEditForm.HorizontalAlign = DevExpress.Web.ASPxClasses.PopupHorizontalAlign.Center;
ASPxTreeList1.SettingsPopupEditForm.VerticalAlign = DevExpress.Web.ASPxClasses.PopupVerticalAlign.WindowCenter;
ASPxTreeList1.SettingsPopupEditForm.AllowResize = true;
ASPxTreeList1.SettingsPopupEditForm.Modal = true;
ASPxTreeList1.SettingsPopupEditForm.Width = 500;
ASPxTreeList1.SettingsPopupEditForm.Caption = "BOM编辑";
ASPxTreeList1.DataSource = dt;
ASPxTreeList1.DataBind();
ASPxTreeList1.CollapseAll();
ASPxTreeList1.ExpandToLevel(0);
//ASPxTreeList1.SettingsEditing.AllowNodeDragDrop = true;
//ASPxTreeList1.ProcessDragNode += new DevExpress.Web.ASPxTreeList.TreeListNodeDragEventHandler(ASPxTreeList1_ProcessDragNode);
ASPxTreeList1.CellEditorInitialize += new DevExpress.Web.ASPxTreeList.TreeListColumnEditorEventHandler(ASPxTreeList1_CellEditorInitialize);
//ASPxTreeList1.NodeValidating += new DevExpress.Web.ASPxTreeList.TreeListNodeValidationEventHandler(ASPxTreeList1_NodeValidating);
//ASPxTreeList1.NodeInserting += new DevExpress.Web.Data.ASPxDataInsertingEventHandler(ASPxTreeList1_NodeInserting);
ASPxTreeList1.NodeUpdating += new DevExpress.Web.Data.ASPxDataUpdatingEventHandler(ASPxTreeList1_NodeUpdating);
//ASPxTreeList1.NodeDeleting += new DevExpress.Web.Data.ASPxDataDeletingEventHandler(ASPxTreeList1_NodeDeleting);
//ASPxTreeList1.HtmlRowPrepared += new DevExpress.Web.ASPxTreeList.TreeListHtmlRowEventHandler(ASPxTreeList1_HtmlRowPrepared);
//ASPxTreeList1.HtmlDataCellPrepared += new DevExpress.Web.ASPxTreeList.TreeListHtmlDataCellEventHandler(ASPxTreeList1_HtmlDataCellPrepared);
//ASPxTreeList1.ParseValue += new DevExpress.Web.Data.ASPxParseValueEventHandler(ASPxTreeList1_ParseValue);
}
protected void Page_Load(object sender, EventArgs e)
{
ASPxTreeList1.DataBind();
ASPxTreeList1.SettingsSelection.Recursive = true;
ASPxTreeList1.ExpandToLevel(2);
}
protected void ASPxTreeList1_NodeDeleted(object sender, DevExpress.Web.Data.ASPxDataDeletedEventArgs e)
{
ASPxTreeList1.DataBind();
Parent.DataBind();
TreeDataSourceView.DataBind();
}
private void fillAllStructure()
{
List <Employee_Structure> ListEmployeeStructure10 = new List <Employee_Structure>();
ListEmployeeStructure10 = loadSendEmployeeStructure();
if (SessionWrapper.LoggedUser.Language_id == 1)
{
var dc1 = from c in ListEmployeeStructure10
where c.Employee_Id != currentUserId
select new
{
ddlKey = c.Employee_Structure_Id,
employeeName = c.Employee.Employee_Name_Ar,
jobTitle = c.Structure.Structure_Name_Ar
};
ASPxGridView1.DataSource = dc1.ToList();
ASPxGridView1.DataBind();
ASPxGridView2.DataSource = dc1.ToList();
ASPxGridView2.DataBind();
}
else
{
var dc1 = from c in ListEmployeeStructure10
where c.Employee_Id != currentUserId
select new
{
ddlKey = c.Employee_Structure_Id,
employeeName = c.Employee.Employee_Name_En,
jobTitle = c.Structure.Structure_Name_En
};
ASPxGridView1.DataSource = dc1.ToList();
ASPxGridView1.DataBind();
ASPxGridView2.DataSource = dc1.ToList();
ASPxGridView2.DataBind();
}
////////////////////////////////////////////////////////////////////////////////////////////////
ListStructure = loadTreeStructure();
ASPxTreeList1.DataSource = ListStructure;
ASPxTreeList1.KeyFieldName = "Structure_Id";
ASPxTreeList1.ParentFieldName = "Structure_Parent";
if (SessionWrapper.LoggedUser.Language_id == 1)
{
ASPxTreeList1.PreviewFieldName = "Structure_Name_Ar";
}
else
{
ASPxTreeList1.PreviewFieldName = "Structure_Name_En";
}
ASPxTreeList1.DataBind();
ASPxTreeList2.DataSource = ListStructure;
ASPxTreeList2.KeyFieldName = "Structure_Id";
ASPxTreeList2.ParentFieldName = "Structure_Parent";
if (SessionWrapper.LoggedUser.Language_id == 1)
{
ASPxTreeList2.PreviewFieldName = "Structure_Name_Ar";
}
else
{
ASPxTreeList2.PreviewFieldName = "Structure_Name_En";
}
ASPxTreeList2.DataBind();
}
protected void ASPxMenu1_ItemClick(object source, DevExpress.Web.MenuItemEventArgs e)
{
String s = e.Item.Name;
switch (s)
{
case "Item1":
TreeLabel.Text = "СКЗ";
if (!Page.User.IsInRole("Members"))
{
SqlDataSource22.SelectCommand = String.Format("SELECT subject_id, subject_name, subject_type, subject_code, object_name, add_info, latitude, longitude FROM \"Subject\" where subject_type='СКЗ' order by subject_name");
TreeCommand = SqlDataSource22.SelectCommand;
}
ASPxTreeList1.DataBind();
break;
case "Item2":
TreeLabel.Text = "БСЗ";
if (!Page.User.IsInRole("Members"))
{
SqlDataSource22.SelectCommand = String.Format("SELECT subject_id, subject_name, subject_type, subject_code, object_name, add_info, latitude, longitude FROM \"Subject\" where subject_type='БСЗ' or subject_type='БКМУ+БСЗ' order by subject_name");
TreeCommand = SqlDataSource22.SelectCommand;
Page.ClientScript.RegisterStartupScript(this.GetType(), "BSZSet", "BSZSet()", true);
}
ASPxTreeList1.DataBind();
break;
case "Item3":
TreeLabel.Text = "БКМУ";
if (!Page.User.IsInRole("Members"))
{
SqlDataSource22.SelectCommand = String.Format("SELECT subject_id, subject_name, subject_type, subject_code, object_name, add_info, latitude, longitude FROM \"Subject\" where subject_type='БКМУ' order by subject_name");
TreeCommand = SqlDataSource22.SelectCommand;
Page.ClientScript.RegisterStartupScript(this.GetType(), "BKMUSet", "BKMUSet()", true);
}
ASPxTreeList1.DataBind();
break;
case "Item9":
TreeLabel.Text = "Все объекты";
if (!Page.User.IsInRole("Members"))
{
SqlDataSource22.SelectCommand = String.Format("SELECT subject_id, subject_name, subject_type, subject_code, object_name, add_info, latitude, longitude FROM \"Subject\"");
TreeCommand = SqlDataSource22.SelectCommand;
Page.ClientScript.RegisterStartupScript(this.GetType(), "AllSet", "AllSet()", true);
}
ASPxTreeList1.DataBind();
break;
case "Item4":
TreeLabel.Text = "СДЗ";
if (!Page.User.IsInRole("Members"))
{
SqlDataSource22.SelectCommand = String.Format("SELECT subject_id, subject_name, subject_type, subject_code, object_name, add_info, latitude, longitude FROM \"Subject\" where subject_type='СДЗ' order by subject_name");
TreeCommand = SqlDataSource22.SelectCommand;
Page.ClientScript.RegisterStartupScript(this.GetType(), "SDZSet", "SDZSet()", true);
}
ASPxTreeList1.DataBind();
break;
default:
TreeLabel.Text = "";
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
ASPxTreeList1.DataBind();
ASPxGridView1.DataBind();
}
