protected void ASPxGridView1_StartRowEditing(object sender, DevExpress.Web.Data.ASPxStartRowEditingEventArgs e)
{
AccountingPeriod currentEdit = session.GetObjectByKey <AccountingPeriod>(Guid.Parse(e.EditingKeyValue.ToString()));
Guid accountingPeriodId = Guid.Parse(e.EditingKeyValue.ToString());
if (AccountingPeriodBO.IsChildOfAnother(session, accountingPeriodId))
{
e.Cancel = true;
(sender as ASPxGridView).CancelEdit();
throw new Exception("Chu kì kế toán này đang là chu kì trực thuộc của một chu kì khác! Không thể chỉnh sửa");
}
Session["AccountingPeriodId_cr"] = currentEdit.AccountingPeriodId;
ASPxGridLookup grid = ASPxGridView1.FindEditRowCellTemplateControl(ASPxGridView1.Columns[5] as GridViewDataColumn, "cp_Grid1").FindControl("GridUnderPeriod") as ASPxGridLookup;
if (currentEdit.AccountingPeriodTypeId.IsDefault == true)
{
XPOAccountingPeriodLookup.Criteria = "[RowStatus] > 0s And [IsActive] = True And [IsActive] <> True And [Code] <> 'NAAN_DEFAULT' And [AccountingPeriodTypeId.IsDefault] = True";
grid.Enabled = false;
}
else
{
XPOAccountingPeriodLookup.Criteria = "[RowStatus] > 0s And [IsActive] = True And [Code] <> 'NAAN_DEFAULT' And [AccountingPeriodTypeId.IsDefault] = True";
grid.Enabled = true;
}
}
//新增
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxComboBox pLine = ASPxGridView1.FindEditFormTemplateControl("comboPLine") as ASPxComboBox;
ASPxComboBox zdmc = ASPxGridView1.FindEditFormTemplateControl("comboStationCode") as ASPxComboBox;
ASPxTextBox zddm = ASPxGridView1.FindEditFormTemplateControl("txtStationName") as ASPxTextBox;
ASPxGridLookup gridlookup = ASPxGridView1.FindEditFormTemplateControl("comboLJDM") as ASPxGridLookup;
ASPxComboBox part_ABC = ASPxGridView1.FindEditFormTemplateControl("comboLJLB") as ASPxComboBox;
string ljdm = gridlookup.Value.ToString();
string ljmc = gridlookup.Text.Trim();
string Sql = "INSERT INTO ATPUZDLJMLB (GZDD,ZDDM,ZDMC,LJDM,LJMC,INPUT_PERSON,INPUT_TIME,PART_ABC) "
+ "VALUES( '" + pLine.Value.ToString() + "','" + zddm.Text.Trim() + "','" + zdmc.Value.ToString() + "','" + ljdm + "','" + ljmc + "','" + theUserId + "',SYSDATE,'" + part_ABC.Value.ToString() + "')";
dc.ExeSql(Sql);
//插入到日志表161103
try
{
string Sql2 = "INSERT INTO ATPUZDLJMLB_LOG (GZDD,ZDDM,ZDMC,LJDM,LJMC,user_code,flag,rqsj,PART_ABC)"
+ " SELECT GZDD,ZDDM,ZDMC,LJDM,LJMC,'" + theUserCode + "' , 'ADD', SYSDATE,PART_ABC FROM ATPUZDLJMLB WHERE GZDD = '" + pLine.Value.ToString() + "' and ZDMC = '" + zdmc.Value.ToString() + "' and LJDM = '" + ljdm + "'";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
protected override System.Web.UI.WebControls.WebControl CreateEditModeControlCore()
{
ASPxGridLookup lookupEdit = new ASPxGridLookup();
lookupEdit.ID = PropertyName + "_CheckedComboBox";
lookupEdit.Width = Unit.Percentage(100);
lookupEdit.SelectionMode = GridLookupSelectionMode.Multiple;
lookupEdit.TextChanged += EditValueChangedHandler;
lookupEdit.KeyFieldName = LookupValueColumnName;
lookupEdit.MultiTextSeparator = ", ";
lookupEdit.AllowUserInput = false;
// Set the drop-down editor width.
lookupEdit.GridView.Width = 500;
// OR
//string setSizeScript = "function(s, e){s.GetGridView().SetWidth(s.GetWidth()); }";
//lookupEdit.ClientSideEvents.Init = lookupEdit.ClientSideEvents.DropDown = setSizeScript;
lookupEdit.GridViewProperties.Settings.ShowColumnHeaders = false;
lookupEdit.GridViewProperties.Settings.GridLines = GridLines.None;
lookupEdit.GridViewStyles.SelectedRow.BackColor = System.Drawing.ColorTranslator.FromHtml("#00fbfbfb");
lookupEdit.GridViewStyles.FocusedRow.BackColor = System.Drawing.ColorTranslator.FromHtml("#00fbfbfb");
GridViewCommandColumn selectionColumn = new GridViewCommandColumn();
selectionColumn.ShowSelectCheckbox = true;
lookupEdit.Columns.Add(selectionColumn);
GridViewDataColumn valueColumn = new GridViewDataColumn(LookupValueColumnName);
lookupEdit.Columns.Add(valueColumn);
lookupEdit.DataSource = GetLookupData();
return(lookupEdit);
}
// 主表修改
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
//ASPxLabel billId = ASPxGridView1.FindEditFormTemplateControl("LabBillId") as ASPxLabel;
ASPxTextBox assetcode = ASPxGridView1.FindEditFormTemplateControl("txtAssetCode") as ASPxTextBox;
ASPxTextBox srlno = ASPxGridView1.FindEditFormTemplateControl("txtSrlNo") as ASPxTextBox;
ASPxGridLookup lkpVendor = ASPxGridView1.FindEditFormTemplateControl("GridLookupVendor") as ASPxGridLookup;
ASPxGridLookup lkpManuf = ASPxGridView1.FindEditFormTemplateControl("GridLookupManuf") as ASPxGridLookup;
ASPxGridLookup lkpDept = ASPxGridView1.FindEditFormTemplateControl("GridLookupDept") as ASPxGridLookup;
ASPxDateEdit dtePurchDate = ASPxGridView1.FindEditFormTemplateControl("CalPCDate") as ASPxDateEdit;
ASPxTextBox txtPurchCost = ASPxGridView1.FindEditFormTemplateControl("txtPrice") as ASPxTextBox;
ASPxDateEdit wrtStartDate = ASPxGridView1.FindEditFormTemplateControl("CalWRTStartDate") as ASPxDateEdit;
ASPxDateEdit wrtEndDate = ASPxGridView1.FindEditFormTemplateControl("CalWRTEndDate") as ASPxDateEdit;
ASPxTextBox txtAssetColor = ASPxGridView1.FindEditFormTemplateControl("txtColor") as ASPxTextBox;
ASPxTextBox txtBarCode = ASPxGridView1.FindEditFormTemplateControl("txtBarCode") as ASPxTextBox;
ASPxGridLookup lkpRspPerson = ASPxGridView1.FindEditFormTemplateControl("lkpResponsePerson") as ASPxGridLookup;
ASPxCheckBox chkActiveFlag = ASPxGridView1.FindEditFormTemplateControl("chkActiveFlag") as ASPxCheckBox;
ASPxMemo assetRemark = ASPxGridView1.FindEditFormTemplateControl("txtRemark") as ASPxMemo;
string deptCode = "", vendorCode = "", manufCode = "", rspPerson = "";
ASPxGridLookup gridLookupVendor = ASPxGridView1.FindEditFormTemplateControl("GridLookupVendor") as ASPxGridLookup;
ASPxTextBox txtSVendor = ASPxGridView1.FindEditFormTemplateControl("txtSVendor") as ASPxTextBox;
if (lkpDept.Value != null)
{
deptCode = lkpDept.Value.ToString();
}
if (lkpManuf.Value != null)
{
manufCode = lkpManuf.Value.ToString();
}
if (lkpVendor.Value != null)
{
vendorCode = lkpVendor.Value.ToString();
}
if (lkpRspPerson.Value != null)
{
rspPerson = lkpRspPerson.Value.ToString();
}
string activeflag = chkActiveFlag.Checked ? "Y":"N";
string upSql = "UPDATE data_asset_detail SET vendor_code='" + vendorCode + "',manufacturer_code='" + lkpManuf.Value + "'," +
"response_dept_code='" + deptCode + "',purchase_date=to_date('" + dtePurchDate.Value.ToString() + "','yyyy-mm-dd hh24:mi:ss'),purchase_cost=" + txtPurchCost.Text + "," +
"warranty_start_date=to_date('" + wrtStartDate.Value.ToString() + "','yyyy-mm-dd hh24:mi:ss'),warranty_end_date=to_date('" + wrtEndDate.Value.ToString() + "','yyyy-mm-dd hh24:mi:ss')," +
"response_person_code='" + lkpRspPerson.Value.ToString() + "',asset_color='" + txtAssetColor.Text + "',asset_remark='" + assetRemark.Text + "',active_flag='" + activeflag + "' " +
" WHERE COMPANY_CODE = '" + theCompanyCode + "' AND serial_number='" + srlno.Text + "'";
theDc.ExeSql(upSql);
e.Cancel = true;
ASPxGridView1.CancelEdit();
queryFunction();
}
protected void ASPxGridView2_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxGridLookup uSO = ASPxGridView2.FindEditFormTemplateControl("txtSO2") as ASPxGridLookup;
ASPxTextBox uJX = ASPxGridView2.FindEditFormTemplateControl("txtJX") as ASPxTextBox;
ASPxTextBox uPQBAK = ASPxGridView2.FindEditFormTemplateControl("txtPQBAK") as ASPxTextBox;
ASPxTextBox uREMARK = ASPxGridView2.FindEditFormTemplateControl("txtREMARK") as ASPxTextBox;
string strSO = uSO.Value.ToString();
string strJX = uJX.Text.Trim();
string strPQBAK = uPQBAK.Text.Trim();
string strREMARK = uREMARK.Text.Trim();
string Sql = "INSERT INTO PAINT_SO (SO,TYPE_PQ,TYPE_PQBAK,REMARK,JX,input_person,input_time) "
+ "VALUES( '" + strSO + "','" + strPQBAK + "','" + strPQBAK + "','" + strREMARK + "','" + strJX + "','" + theUserId + "',sysdate)";
dc.ExeSql(Sql);
//插入到日志表
try
{
string Sql2 = "INSERT INTO PAINT_SO_LOG (SO,TYPE_PQ,TYPE_PQBAK,REMARK,JX,user_code,flag,rqsj)"
+ " VALUES( '" + strSO + "','" + strPQBAK + "','" + strPQBAK + "','" + strREMARK + "','" + strJX + "','" + theUserCode + "' , 'ADD', SYSDATE) ";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView2.CancelEdit();
setCondition();
}
public override void InitGridLookup(ASPxGridLookup gridlookup)
{
gridlookup.KeyFieldName = "OrganizationId";
gridlookup.TextFormatString = "{0} - {1}";
gridlookup.Columns.Clear();
GridViewColumn selectionColumn = new GridViewCommandColumn()
{
ShowSelectCheckbox = true,
VisibleIndex = 0
};
GridViewColumn codeColumn = new GridViewDataTextColumn()
{
ShowInCustomizationForm = true,
FieldName = "Code",
Caption = "Mã khách hàng",
VisibleIndex = 1
};
GridViewColumn nameColumn = new GridViewDataTextColumn()
{
ShowInCustomizationForm = true,
FieldName = "Name",
Caption = "Tên khách hàng",
VisibleIndex = 2
};
gridlookup.Columns.Add(selectionColumn);
gridlookup.Columns.Add(codeColumn);
gridlookup.Columns.Add(nameColumn);
}
protected void gridLkupSubj_OnDataBound(object sender, EventArgs e)
{
Debug.Print("gridLkupSubj_OnDataBound " + System.DateTime.Now.ToString());
bool loadvars = false;
if (Request.QueryString["subjset_pk"] != null)
{
ASPxGridLookup x = (ASPxGridLookup)sender;
ASPxGridView grid = (ASPxGridView)x.GridView;
var nrow = (int)grid.VisibleRowCount;
//var nrow = 33;
for (int i = 0; i < numsubj; i++)
{
if (selected_subjlist.Contains(grid.GetRowValues(i, "subjID").ToString()))
{
if (grid.Selection.IsRowSelected(i) == false)
{
loadvars = true;
grid.Selection.SelectRow(i);
}
}
}
}
RefreshSelectedSubj();
}
protected void gridLookup_Init(object sender, EventArgs e)
{
ASPxGridLookup gl = (ASPxGridLookup)sender;
gl.DataSource = CreateDataSource();
gl.DataBind();
}
protected void ASPxGridView1_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
//判断为空
ASPxGridLookup gridLookupTeam = ASPxGridView1.FindEditFormTemplateControl("GridLookupTeam") as ASPxGridLookup;
if (gridLookupTeam.Value == null)
{
e.RowError = "班组代码不能为空！";
}
ASPxGridLookup gridLookupUser = ASPxGridView1.FindEditFormTemplateControl("GridLookupUser") as ASPxGridLookup;
if (gridLookupUser.Value == null)
{
e.RowError = "用户代码不能为空！";
}
else
{
//判断同一个用户只能分配一个班组
List <object> Users = gridLookupUser.GridView.GetSelectedFieldValues("USER_ID");
List <object> UsersName = gridLookupUser.GridView.GetSelectedFieldValues("USER_NAME");
for (int indexUser = 0; indexUser < Users.Count; indexUser++)
{
string chSql = "SELECT COMPANY_CODE,PLINE_CODE,TEAM_CODE,USER_ID FROM REL_TEAM_USER WHERE COMPANY_CODE='" + theCompanyCode + "' AND PLINE_CODE='" + thePlCode + "' AND USER_ID='" + Users[indexUser].ToString() + "'";
DataTable dt = theDc.GetTable(chSql);
if (dt.Rows.Count >= 1)
{
e.RowError = UsersName[indexUser].ToString() + "已经被分配过班组！";
}
}
}
}
protected void SpecifyJSProperties(ASPxGridLookup gl)
{
if (gl.GridView.Selection.Count == gl.GridView.VisibleRowCount)
{
gl.GridView.JSProperties["cp_selected"] = true;
}
}
public override void InitGridLookup(ASPxGridLookup gridlookup)
{
gridlookup.KeyFieldName = "BillId";
gridlookup.TextFormatString = "{0}";
gridlookup.Columns.Clear();
GridViewColumn selectionColumn = new GridViewCommandColumn()
{
ShowSelectCheckbox = true,
VisibleIndex = 0
};
GridViewColumn codeColumn = new GridViewDataTextColumn()
{
ShowInCustomizationForm = true,
FieldName = "Code",
Caption = "Số phiếu bán",
VisibleIndex = 1
};
GridViewColumn nameColumn = new GridViewDataTextColumn()
{
ShowInCustomizationForm = true,
FieldName = "IssuedDate",
Caption = "Ngày",
VisibleIndex = 2
};
gridlookup.Columns.Add(selectionColumn);
gridlookup.Columns.Add(codeColumn);
gridlookup.Columns.Add(nameColumn);
}
protected void gridLookup_Init(object sender, EventArgs e)
{
ASPxGridLookup gl = (ASPxGridLookup)sender;
gl.GridView.Width = Unit.Pixel(165);
gl.DataSource = CreateDataIEnumerableSourceFromEnum(typeof(CustomEnum));
gl.DataBind();
}
protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e)
{
ASPxGridLookup gridLookupUser = ASPxGridView1.FindEditFormTemplateControl("GridLookupUser") as ASPxGridLookup;
gridLookupUser.GridView.Width = 250;
ASPxGridLookup gridLookupRole = ASPxGridView1.FindEditFormTemplateControl("GridLookupRole") as ASPxGridLookup;
gridLookupRole.GridView.Width = 250;
}
public override void BreakLinksToControl(bool unwireEventsOnly)
{
ASPxGridLookup lookupEdit = Editor as ASPxGridLookup;
if (lookupEdit != null)
{
lookupEdit.TextChanged -= EditValueChangedHandler;
}
base.BreakLinksToControl(unwireEventsOnly);
}
protected void glProducts_Init(object sender, EventArgs e)
{
ASPxGridLookup gridLookup = sender as ASPxGridLookup;
gridLookup.GridView.CustomCallback += new ASPxGridViewCustomCallbackEventHandler(gridView_CustomCallback);
if (Session["FilterExpression"] != null)
{
gridLookup.GridView.DataSource = adsProducts;
adsProducts.FilterExpression = Session["FilterExpression"].ToString();
}
}
protected override System.Web.UI.WebControls.WebControl CreateEditModeControlCore()
{
lookup = new ASPxGridLookup();
lookup.ValueChanged += ExtendedEditValueChangedHandler;
lookup.GridView.SettingsBehavior.AllowSelectByRowClick = true;
lookup.GridView.SettingsBehavior.AllowSelectSingleRowOnly = true;
lookup.GridView.AutoGenerateColumns = true;
lookup.IncrementalFilteringMode = DevExpress.Web.ASPxEditors.IncrementalFilteringMode.Contains;
lookup.SelectionMode = GridLookupSelectionMode.Single;
lookup.GridView.KeyFieldName = "Oid";
return(lookup);
}
protected object GetGridLookupValue(ASPxGridLookup lookup)
{
try
{
return(lookup.Value);
}
catch (Exception ex)
{
CommonMethods.LogThis(ex.Message + "\r\n" + ex.Source + "\r\n" + ex.StackTrace);
return(null);
}
}
public override List <NASCustomFieldPredefinitionData> GetSelectedPredefinitionDataFromList(object source)
{
List <NASCustomFieldPredefinitionData> ret = null;
Session session = null;
try
{
session = XpoHelper.GetNewSession();
ASPxGridLookup gridlookup = source as ASPxGridLookup;
var selectedIds = gridlookup.GridView
.GetSelectedFieldValues("OrganizationId")
.Select(r => Guid.Parse(r.ToString()));
if (selectedIds != null)
{
ret = new List <NASCustomFieldPredefinitionData>();
foreach (var Id in selectedIds)
{
Organization organization =
session.GetObjectByKey <Organization>(Id);
if (organization != null)
{
NASCustomFieldPredefinitionData retItem = new NASCustomFieldPredefinitionData()
{
Code = organization.Code,
Description = organization.Description,
Name = organization.Name,
PredefinitionType = Enum.GetName(typeof(MultiSelectionBuiltInTypeEnum),
MultiSelectionBuiltInTypeEnum.MULTI_CHOICE_LIST_SUPPLIER),
RefId = organization.OrganizationId
};
ret.Add(retItem);
}
}
}
return(ret);
}
catch (Exception)
{
throw;
}
finally
{
if (session != null)
{
session.Dispose();
}
}
}
public override List <NASCustomFieldPredefinitionData> GetSelectedPredefinitionDataFromList(object source)
{
List <NASCustomFieldPredefinitionData> ret = null;
Session session = null;
try
{
session = XpoHelper.GetNewSession();
ASPxGridLookup gridlookup = source as ASPxGridLookup;
var selectedIds = gridlookup.GridView
.GetSelectedFieldValues("BillId")
.Select(r => Guid.Parse(r.ToString()));
if (selectedIds != null)
{
ret = new List <NASCustomFieldPredefinitionData>();
foreach (var Id in selectedIds)
{
PurchaseInvoice purchaseInvoice =
session.GetObjectByKey <PurchaseInvoice>(Id);
if (purchaseInvoice != null)
{
NASCustomFieldPredefinitionData retItem = new NASCustomFieldPredefinitionData()
{
Code = purchaseInvoice.Code,
Description = String.Empty,
Name = String.Empty,
PredefinitionType = Enum.GetName(typeof(MultiSelectionBuiltInTypeEnum),
MultiSelectionBuiltInTypeEnum.MULTI_CHOICE_LIST_INVOICE_PURCHASE),
RefId = purchaseInvoice.BillId
};
ret.Add(retItem);
}
}
}
return(ret);
}
catch (Exception)
{
throw;
}
finally
{
if (session != null)
{
session.Dispose();
}
}
}
//修改
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
//ASPxTextBox uCode = ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxTextBox;
//ASPxTextBox uName = ASPxGridView1.FindEditFormTemplateControl("txtPName") as ASPxTextBox;
ASPxGridLookup uSO = ASPxGridView1.FindEditFormTemplateControl("txtSO") as ASPxGridLookup;
ASPxTextBox uJX = ASPxGridView1.FindEditFormTemplateControl("txtJX") as ASPxTextBox;
ASPxTextBox uPQBAK = ASPxGridView1.FindEditFormTemplateControl("txtPQBAK") as ASPxTextBox;
ASPxTextBox uREMARK = ASPxGridView1.FindEditFormTemplateControl("txtREMARK") as ASPxTextBox;
string strSO = uSO.Value.ToString();
string strJX = uJX.Text.Trim();
string strPQBAK = uPQBAK.Text.Trim();
string strREMARK = uREMARK.Text.Trim();
//插入到日志表
try
{
string Sql2 = "INSERT INTO PAINT_SO_LOG (SO,TYPE_PQ,TYPE_PQBAK,REMARK,JX,user_code,flag,rqsj)"
+ " SELECT SO,TYPE_PQ,TYPE_PQBAK,REMARK,JX,'" + theUserCode + "' , 'BEFOREEDIT', SYSDATE FROM PAINT_SO WHERE SO = '" + strSO + "'";
dc.ExeSql(Sql2);
}
catch
{
return;
}
string Sql = "UPDATE PAINT_SO SET TYPE_PQ='" + strPQBAK + "',TYPE_PQBAK='" + strPQBAK + "',REMARK='" + strREMARK + "',input_person='" + theUserId + "',input_time=sysdate"
+ " WHERE SO = '" + strSO + "' ";
dc.ExeSql(Sql);
//插入到日志表
try
{
string Sql2 = "INSERT INTO PAINT_SO_LOG (SO,TYPE_PQ,TYPE_PQBAK,REMARK,JX,user_code,flag,rqsj)"
+ " SELECT SO,TYPE_PQ,TYPE_PQBAK,REMARK,JX,'" + theUserCode + "' , 'AFTEREDIT', SYSDATE FROM PAINT_SO WHERE SO = '" + strSO + "'";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
//新增
int indexUser, indexRole;
ASPxGridLookup gridLookupUser = ASPxGridView1.FindEditFormTemplateControl("GridLookupUser") as ASPxGridLookup;
ASPxGridLookup gridLookupRole = ASPxGridView1.FindEditFormTemplateControl("GridLookupRole") as ASPxGridLookup;
List <object> Users = gridLookupUser.GridView.GetSelectedFieldValues("USER_ID");
List <object> Roles = gridLookupRole.GridView.GetSelectedFieldValues("ROLE_CODE");
for (indexUser = 0; indexUser < Users.Count; indexUser++)
{
for (indexRole = 0; indexRole < Roles.Count; indexRole++)
{
MW_MODIFY_USER_ROLE sp = new MW_MODIFY_USER_ROLE()
{
THEFUNCTION1 = "ADD",
THECOMPANYCODE1 = theCompanyCode,
THEUSERID1 = Users[indexUser].ToString(),
THEROLECODE1 = Roles[indexRole].ToString()
};
Rmes.DA.Base.Procedure.run(sp);
//dataConn theDataConn = new dataConn();
//theDataConn.theComd.CommandType = CommandType.StoredProcedure;
//theDataConn.theComd.CommandText = "MW_MODIFY_USER_ROLE";
//theDataConn.theComd.Parameters.Add("THEFUNCTION1", OracleDbType.Varchar2).Value = "ADD";
//theDataConn.theComd.Parameters.Add("THEFUNCTION1", OracleDbType.Varchar2).Direction = ParameterDirection.Input;
//theDataConn.theComd.Parameters.Add("THECOMPANYCODE1", OracleDbType.Varchar2).Value = theCompanyCode;
//theDataConn.theComd.Parameters.Add("THECOMPANYCODE1", OracleDbType.Varchar2).Direction = ParameterDirection.Input;
//theDataConn.theComd.Parameters.Add("THEUSERID1", OracleDbType.Varchar2).Value = Users[indexUser].ToString();
//theDataConn.theComd.Parameters.Add("THEUSERID1", OracleDbType.Varchar2).Direction = ParameterDirection.Input;
//theDataConn.theComd.Parameters.Add("THEROLECODE1", OracleDbType.Varchar2).Value = Roles[indexRole].ToString();
//theDataConn.theComd.Parameters.Add("THEROLECODE1", OracleDbType.Varchar2).Direction = ParameterDirection.Input;
//theDataConn.OpenConn();
//theDataConn.theComd.ExecuteNonQuery();
//theDataConn.CloseConn();
}
}
setCondition();
e.Cancel = true;
ASPxGridView1.CancelEdit();
}
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxCheckBox chkQAD = ASPxGridView1.FindEditFormTemplateControl("chkQAD") as ASPxCheckBox;
ASPxComboBox PCode = ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox;
//ASPxComboBox uPNum = ASPxGridView1.FindEditFormTemplateControl("txtPNum") as ASPxComboBox;
ASPxGridLookup Bgy = ASPxGridView1.FindEditFormTemplateControl("txtBgy") as ASPxGridLookup;
ASPxGridLookup Part = ASPxGridView1.FindEditFormTemplateControl("txtPart") as ASPxGridLookup;
ASPxTextBox Pname = ASPxGridView1.FindEditFormTemplateControl("txtPname") as ASPxTextBox;
//ASPxDateEdit uOnlinetime = ASPxGridView1.FindEditFormTemplateControl("DateOnlinetime") as ASPxDateEdit;
string vFlag = "";
if (chkQAD.Checked == true)
{
vFlag = "Y";
}
else
{
vFlag = "N";
}
string strPCode = PCode.Value.ToString();
string strPname = "";
string strBgy = Bgy.Value.ToString();
string strPart = Part.Value.ToString();
string Gsql = "select pt_desc2 from copy_pt_mstr where upper(pt_part)='" + strPart.ToUpper() + "'";
DataTable Gdt = dc.GetTable(Gsql);
if (Gdt.Rows.Count > 0)
{
strPname = Gdt.Rows[0][0].ToString();
}
// string strOnlinetime = uOnlinetime.Text.Trim();
if (vFlag == "N")
{
string Sql = "insert into atpubkflpart(part,gzdd,part_type,part_desc,edit_name,edit_date) "
+ "VALUES('" + strPart + "','" + strPCode + "','0','" + strPname + "','" + theUserName + "',sysdate)";
dc.ExeSql(Sql);
}
else
{
string Sql = "insert into atpubkflpart(part,gzdd,part_type,part_desc,edit_name,edit_date,bgy) "
+ "VALUES('" + strPart + "','" + strPCode + "','1','" + strPname + "','" + theUserName + "',sysdate,'" + strBgy + "')";
dc.ExeSql(Sql);
}
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
// 主表新增
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxTextBox txtSrlNo = ASPxGridView1.FindEditFormTemplateControl("txtSrlNo") as ASPxTextBox;
ASPxGridLookup lkpMntType = ASPxGridView1.FindEditFormTemplateControl("lkpMaintType") as ASPxGridLookup;
ASPxComboBox txtMntItem = ASPxGridView1.FindEditFormTemplateControl("cmbMntItem") as ASPxComboBox;
ASPxTextBox txtSrvUnit = ASPxGridView1.FindEditFormTemplateControl("txtSrvUnit") as ASPxTextBox;
ASPxTextBox txtSrvPerson = ASPxGridView1.FindEditFormTemplateControl("txtSrvPerson") as ASPxTextBox;
ASPxTextBox txtMntResult = ASPxGridView1.FindEditFormTemplateControl("txtMntResult") as ASPxTextBox;
ASPxTextBox txtMntCost = ASPxGridView1.FindEditFormTemplateControl("txtMntCost") as ASPxTextBox;
ASPxDateEdit calMntStartDate = ASPxGridView1.FindEditFormTemplateControl("calMntStartDate") as ASPxDateEdit;
ASPxDateEdit calMntEndDate = ASPxGridView1.FindEditFormTemplateControl("calMntEndDate") as ASPxDateEdit;
ASPxMemo mntRemark = ASPxGridView1.FindEditFormTemplateControl("txtRemark") as ASPxMemo;
ASPxMemo faultScript = ASPxGridView1.FindEditFormTemplateControl("txtFault") as ASPxMemo;
string mntType = "";
string mntItem = e.NewValues["MAINT_ITEM"].ToString();
//string mntItem = txtMntItem == null ? "" : txtMntItem.SelectedItem.Value.ToString();
string mntCost = txtMntCost == null ? "0" : txtMntCost.Text;
if (lkpMntType.Value != null)
{
mntType = lkpMntType.Value.ToString();
}
string inSql = "insert into DATA_ASSET_MAINTAIN(company_code,SERIAL_NUMBER,maint_type,maint_item,maint_service_unit," +
"maint_service_person,maint_result,maint_cost,maint_start_date,maint_end_date,maint_remark,fault_script) " +
"values('" + theCompanyCode + "','" + txtSrlNo.Text + "','" + mntType + "','" + mntItem + "','" +
txtSrvUnit.Text + "','" + txtSrvPerson.Text + "','" + txtMntResult.Text + "'," + mntCost + "," +
"to_date('" + calMntStartDate.Value.ToString() + "','yyyy-mm-dd hh24:mi:ss'),to_date('" +
calMntEndDate.Value.ToString() + "','yyyy-mm-dd hh24:mi:ss'),'" + mntRemark.Text + "','" + faultScript.Text + "')";
dataConn inDc = new dataConn();
inDc.ExeSql(inSql);
e.Cancel = true;
ASPxGridView1.CancelEdit();
queryFunction();
}
public override void BreakLinksToControl(bool unwireEventsOnly)
{
if (Editor != null)
{
ASPxGridLookup control = (ASPxGridLookup)Editor;
if (control != null)
{
control.ValueChanged -= EditValueChangedHandler;
control.GridView.CustomCallback -= GridView_CustomCallback;
control.Init -= control_Init;
control.PreRender -= control_PreRender;
}
}
base.BreakLinksToControl(unwireEventsOnly);
}
private void AddButtons(ASPxGridLookup control)
{
EditButton clearButton = new EditButton();
clearButton.ToolTip = CaptionHelper.GetLocalizedText("DialogButtons", "Clear");
ASPxImageHelper.SetImageProperties(clearButton.Image, "Editor_Clear");
control.Buttons.Add(clearButton);
if (newObjectViewController.NewObjectAction.Items.Count > 0)
{
EditButton addButton = new EditButton();
addButton.ToolTip = CaptionHelper.GetLocalizedText("DialogButtons", "Add");
ASPxImageHelper.SetImageProperties(addButton.Image, "Editor_Add");
control.Buttons.Add(addButton);
}
}
public void LoadManufacurer(ASPxGridLookup searchlookupedit)
{
try
{
ds = this.GetPatient();
searchlookupedit.KeyFieldName = "PatientId";
searchlookupedit.DataSource = ds.Tables["PatientsDetails"];
searchlookupedit.DataBind();
}
catch (Exception ex)
{
Security secs = new Security();
secs.ErrorDesscription = ex.Message;
secs.ErrorModule = "Select all permit types";
secs.SaveError();
}
}
public void LoadDepartments(ASPxGridLookup searchlookupedit)
{
try
{
ds = this.GetDepartment();
searchlookupedit.KeyFieldName = "DeptCode";
searchlookupedit.DataSource = ds.Tables["Departments"];
searchlookupedit.DataBind();
}
catch (Exception ex)
{
Security secs = new Security();
secs.ErrorDesscription = ex.Message;
secs.ErrorModule = "Select all permit types";
secs.SaveError();
}
}
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxTextBox uLJJ = ASPxGridView1.FindEditFormTemplateControl("txtLJJ") as ASPxTextBox;
ASPxTextBox uCYCLE = ASPxGridView1.FindEditFormTemplateControl("txtCYCLE") as ASPxTextBox;
ASPxTextBox uXH = ASPxGridView1.FindEditFormTemplateControl("txtXH") as ASPxTextBox;
ASPxGridLookup GridLookupCode = ASPxGridView1.FindEditFormTemplateControl("GridLookupCode") as ASPxGridLookup;
ASPxTextBox uBZ = ASPxGridView1.FindEditFormTemplateControl("txtBZ") as ASPxTextBox;
string code = GridLookupCode.Text.Trim();
//插入到日志表
try
{
string Sql2 = "INSERT INTO ATPUFLGJTHZQB_LOG (XH,LOCATION_CODE,LOCATION_NAME,LJJ,CYCLE,BZ,user_code,flag,rqsj)"
+ " SELECT XH,LOCATION_CODE,LOCATION_NAME,LJJ,CYCLE,BZ,'" + theUserCode + "' , 'BEFOREEDIT', SYSDATE FROM ATPUFLGJTHZQB WHERE XH = '" + uXH.Text.Trim() + "' ";
dc.ExeSql(Sql2);
}
catch
{
return;
}
string Sql = "UPDATE ATPUFLGJTHZQB SET LOCATION_CODE='" + code + "', LOCATION_NAME='" + code + "',LJJ='" + uLJJ.Text.Trim() + "',CYCLE='" + uCYCLE.Text.Trim() + "',BZ='" + uBZ.Text.Trim() + "',INPUT_PERSON='" + theUserId + "',INPUT_TIME=SYSDATE "
+ " WHERE XH = '" + uXH.Text.Trim() + "'";
dc.ExeSql(Sql);
//插入到日志表
try
{
string Sql2 = "INSERT INTO ATPUFLGJTHZQB_LOG (XH,LOCATION_CODE,LOCATION_NAME,LJJ,CYCLE,BZ,user_code,flag,rqsj)"
+ " SELECT XH,LOCATION_CODE,LOCATION_NAME,LJJ,CYCLE,BZ,'" + theUserCode + "' , 'AFTEREDIT', SYSDATE FROM ATPUFLGJTHZQB WHERE XH = '" + uXH.Text.Trim() + "' ";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
if (e.NewValues["IsActive"] == null)
{
e.NewValues["IsActive"] = false;
}
if (Util.isExistXpoObject <AccountingPeriod>("Code", (string)e.NewValues["Code"]))
{
e.Cancel = true;
throw (new Exception("Trùng mã chu kì"));
return;
}
if (e.NewValues["AccountingPeriodTypeId!Key"] == null)
{
e.Cancel = true;
throw (new Exception("Chưa chọn thể loại"));
return;
}
AccountingPeriod accountingPeriod = new AccountingPeriod(session);
accountingPeriod.Description = (string)e.NewValues["Description"];
accountingPeriod.Code = (string)e.NewValues["Code"];
accountingPeriod.AccountingPeriodTypeId = session.GetObjectByKey <AccountingPeriodType>(Guid.Parse(e.NewValues["AccountingPeriodTypeId!Key"].ToString()));
accountingPeriod.FromDateTime = (DateTime)e.NewValues["FromDateTime"];
accountingPeriod.ToDateTime = (DateTime)e.NewValues["ToDateTime"];
accountingPeriod.RowStatus = Constant.ROWSTATUS_ACTIVE;
accountingPeriod.IsActive = (bool)e.NewValues["IsActive"];
if (accountingPeriod.Code != null)
{
accountingPeriod.Save();
}
ASPxGridLookup grid = ASPxGridView1.FindEditRowCellTemplateControl(ASPxGridView1.Columns[5] as GridViewDataColumn, "cp_Grid1").FindControl("GridUnderPeriod") as ASPxGridLookup;
List <object> selectedRows = grid.GridView.GetSelectedFieldValues("AccountingPeriodId");
if (!accountingPeriod.AccountingPeriodTypeId.IsDefault)
{
foreach (var o in selectedRows)
{
AccountingPeriodBO.CreatAccountingPeriodComposite(session, accountingPeriod.AccountingPeriodId, Guid.Parse(o.ToString()));
}
}
e.Cancel = true;
ASPxGridView1.CancelEdit();
}
public override void InitGridLookup(ASPxGridLookup gridlookup)
{
gridlookup.KeyFieldName = "OrganizationId";
gridlookup.TextFormatString = "{0} - {1}";
gridlookup.Columns.Clear();
GridViewColumn selectionColumn = new GridViewCommandColumn()
{
ShowSelectCheckbox = true,
VisibleIndex = 0
};
GridViewColumn codeColumn = new GridViewDataTextColumn()
{
ShowInCustomizationForm = true,
FieldName = "Code",
Caption = "Mã tổ chức",
VisibleIndex = 1,
Width = 120
};
GridViewColumn nameColumn = new GridViewDataTextColumn()
{
ShowInCustomizationForm = true,
FieldName = "Name",
Caption = "Tên tổ chức",
VisibleIndex = 2,
Width = 200
};
GridViewColumn parentOrgColumn = new GridViewDataTextColumn()
{
ShowInCustomizationForm = true,
FieldName = "ParentOrganizationId.Name",
Caption = "Trực thuộc tổ chức",
VisibleIndex = 3,
};
gridlookup.Columns.Add(selectionColumn);
gridlookup.Columns.Add(codeColumn);
gridlookup.Columns.Add(nameColumn);
gridlookup.Columns.Add(parentOrgColumn);
}
private void buildAddBtn(ASPxGridLookup cmb, string popupCode, int moduleID, int width, int height, string title, string param)
{
EditButton btnAdd = new EditButton();
btnAdd.Image.IconID = "actions_add_16x16";
btnAdd.Image.Height = Unit.Pixel(16);
btnAdd.ToolTip = "Thêm mới";
cmb.Buttons.Add(btnAdd);
string cmbClientName = cmb.ClientInstanceName;
cmb.ClientSideEvents.ButtonClick = string.Format("function(s,e){{btnCmbAdd('{0}','{1}',{2},{3},{4},'{5}','{6}');}}", popupCode, cmbClientName, moduleID, width, height, title, param);
cmb.ClientSideEvents.KeyPress = string.Format("function(s,e){{if(event.ctrlKey && event.keyCode==13)btnCmbAdd('{0}','{1}',{2},{3},{4},'{5}','{6}');}}", popupCode, cmbClientName, moduleID, width, height, title, param);
}
public List<HtmlTableCell> BuildGridLookup(string fieldtext, string id, string tablename, string alias, string helptext, string SkinID, int length, string datasource, bool isReadOnly, string controlValue)
{
List<HtmlTableCell> c = new List<HtmlTableCell>();
try
{
HtmlTableCell cell = new HtmlTableCell();
cell.Attributes.Add("class", "tblFormViewtdLabel");
cell.Style.Add("Width", "20%");
ASPxLabel lb = new ASPxLabel() { Text = fieldtext };
cell.Controls.Add(lb);
HtmlTableCell celledit = new HtmlTableCell();
celledit.Attributes.Add("class", "tblFormViewtdValue");
celledit.Style.Add("Width", "30%");
//json attribute
DataTable dtvalues = JsonConvert.DeserializeObject<DataTable>(datasource);
string textformat = dtvalues.Rows[0]["textformat"].ToString();
string tablequery = dtvalues.Rows[0]["tablequery"].ToString();
string type = dtvalues.Rows[0]["type"].ToString();
string colSetting = dtvalues.Rows[0]["colSetting"].ToString();
string datavalue = dtvalues.Rows[0]["datavalue"].ToString();
string wherecondition = dtvalues.Rows[0]["wherecondition"].ToString();
SqlDataSource sqldata = new SqlDataSource() { ConnectionString = DataServices.ConnectString };
ASPxGridLookup gl = new ASPxGridLookup();
switch (type)
{
#region table
case "table":
{
string select = string.Format("SELECT * FROM {0}", tablequery);
string querysql = ProccessquerySql(select, wherecondition);
proccessCreateColumnGridLookup(type,"",colSetting, gl);
sqldata.SelectCommandType = SqlDataSourceCommandType.Text;
sqldata.SelectCommand = querysql;
gl.DataSource = sqldata;
gl.KeyFieldName = datavalue;
}
break;
#endregion
#region query
case "query":
{
string select = tablequery;
string querysql = ProccessquerySql(select, wherecondition);
proccessCreateColumnGridLookup(type,"", colSetting, gl);
sqldata.SelectCommandType = SqlDataSourceCommandType.Text;
sqldata.SelectCommand = querysql;
gl.DataSource = sqldata;
gl.KeyFieldName = select.IndexOf('*') >= 0 ? datavalue : datavalue.ToLower();
}
break;
#endregion
#region query
case "sp":
{
proccessCreateColumnGridLookup(type, "", colSetting, gl);
sqldata.SelectCommandType = SqlDataSourceCommandType.StoredProcedure;
sqldata.SelectCommand = tablequery;
ProccessAddparamForStore(wherecondition, sqldata);
gl.DataSource = sqldata;
gl.KeyFieldName = datavalue;
}
break;
#endregion
}
gl.ID = id;
gl.GridViewProperties.Settings.ShowFilterRow = true;
gl.SkinID = SkinID;
gl.GridView.Width = Unit.Pixel((gl.GridView.Columns.Count > 0 ? gl.GridView.Columns.Count : 1) *
(gl.GridView.Columns.Count > 0 ? int.Parse(gl.GridView.Columns[0].Width.Value.ToString()) : 1));
gl.Width = Unit.Percentage(99);
gl.Theme = "DevEx";
gl.AutoPostBack = false;
gl.TextFormatString = textformat;
gl.DataBind();
gl.Value = controlValue;
gl.ReadOnly = isReadOnly;
celledit.Controls.Add(gl);
c.Add(cell);
c.Add(celledit);
cot += 2;
}
catch (Exception ex)
{
LogAction(0, ex.ToString());
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), Guid.NewGuid().ToString(),
"<script> alert('BuildGridLookup fieldname" + id + "'); </script>",
false);
}
return c;
}
private void proccessCreateColumnGridLookup(string type,string select ,string colSetting, ASPxGridLookup gl)
{
if (type == "query" && select.IndexOf('*')<0)
colSetting = colSetting.ToLower();
DataTable dtLiscolSetting = JsonConvert.DeserializeObject<DataTable>(colSetting);
for (int i = 0; i < dtLiscolSetting.Rows.Count; i++)
{
string colname = dtLiscolSetting.Rows[i]["colname"].ToString();
string caption = string.Format("{0}{1}", dtLiscolSetting.Rows[i]["caption"].ToString().Substring(0, 1).ToUpper(), dtLiscolSetting.Rows[i]["caption"].ToString().Remove(0, 1));
GridViewDataTextColumn cl = new GridViewDataTextColumn();
cl.Caption = string.Format("<Center>{0}<Center>", caption);
cl.FieldName = colname;
cl.VisibleIndex = i;
cl.Width = 150;
cl.Settings.AutoFilterCondition = AutoFilterCondition.Contains;
gl.Columns.Add(cl);
}
}
/// <summary>
/// Tao nut add/fav/refresh
/// </summary>
/// <param name="cmb">Truyen vao control combobox</param>
/// <param name="type">Truyen vao loai nut. 0 : Fav; 1:Fav+Add;2:Fav+Add+Refresh;3:Only Refresh;4:Only Add;5: Fav+Refresh</param>
public void buildcmbButton(ASPxGridLookup cmb, int type, string popupCode = "")
{
int modulePage = -1;
try
{
Int32.TryParse(CU.getCurrentModuleID().ToString(), out modulePage);
}
catch (System.NullReferenceException) { }
int width = 500;
int height = 500;
string title = "Error load Page!!!";
string param = "";
DataTable dtPopupWindow = new DataTable();
dtPopupWindow = SY_GetModuleID_for_PopUpcontrol(popupCode);
if (dtPopupWindow.Rows.Count > 0)
{
SiAuto.Main.LogDataTable(dtPopupWindow);
int.TryParse(dtPopupWindow.Rows[0]["moduleID"].ToString(), out moduleID);
int.TryParse(dtPopupWindow.Rows[0]["width"].ToString(), out width);
int.TryParse(dtPopupWindow.Rows[0]["height"].ToString(), out height);
title = dtPopupWindow.Rows[0]["title"].ToString();
param = dtPopupWindow.Rows[0]["paramArray"].ToString();
}
else
return;
//get Module by popupCode here......
switch (type)
{
case 0:
buildFavBtn(cmb, modulePage);
break;
case 1:
if (checkPermissionBtn(moduleID))
buildFavAddBtn(cmb, popupCode, modulePage, moduleID, width, height, title, param);
else buildFavBtn(cmb, modulePage);
break;
case 2:
if (checkPermissionBtn(moduleID))
buildAllBtn(cmb, popupCode, modulePage, moduleID, width, height, title, param);
else buildFavRefresh(cmb, modulePage);
break;
case 3:
buildRefreshBtn(cmb);
break;
case 4:
if (checkPermissionBtn(moduleID))
buildAddBtn(cmb, popupCode, moduleID, width, height, title, param);
break;
case 5:
buildFavRefresh(cmb, modulePage);
break;
default:
break;
}
}
private void buildFavAddBtn(ASPxGridLookup cmb, string popupCode, int ModulePage, int moduleID, int width, int height, string title, string param)
{
EditButton btnAdd = new EditButton();
btnAdd.Image.IconID = "actions_add_16x16";
btnAdd.Image.Height = Unit.Pixel(16);
btnAdd.ToolTip = "Thêm mới";
cmb.Buttons.Add(btnAdd);
string cmbClientName = cmb.ClientInstanceName;
string cmbClientID = cmb.ClientID + "_B1Img";
EditButton btnFav = new EditButton();
btnFav.Image.Url = "~/img/nonstar.png";
btnFav.Image.Height = Unit.Pixel(16);
btnFav.ToolTip = "Chọn làm giá trị mặc định";
cmb.Buttons.Add(btnFav);
cmb.ClientSideEvents.Init = string.Format("function(s,e){{cmbFavAddInit(s,'{0}','{1}',{2});}}", cmbClientName, cmbClientID, ModulePage);
cmb.ClientSideEvents.ButtonClick = string.Format("function(s,e){{cmbFavAddClick(s,e,'{0}','{1}','{2}',{3},{4},{5},{6},'{7}','{8}');}}", popupCode, cmbClientName, cmbClientID, ModulePage, moduleID, width, height, title, param);
cmb.ClientSideEvents.KeyPress = string.Format("function(s,e){{if(event.ctrlKey && event.keyCode==13)btnCmbAdd('{0}','{1}',{2},{3},{4},'{5}','{6}');}}", popupCode, cmbClientName, moduleID, width, height, title, param);
}
public static void SetLookupValue(ASPxGridLookup cbb, object objects)
{
try
{
if (objects != null)
cbb.Value = objects;
}
catch (Exception ex)
{
SiAuto.Main.LogString("Lỗi SetLookupValue :", ex.ToString());
}
}
public static string GetLookupValue(ASPxGridLookup cbb)
{
string result = "-1";
try
{
result = cbb.Value.ToString();
}
catch (Exception ex)
{
SiAuto.Main.LogString("Lỗi GetLookupValue :", ex.ToString());
}
return result;
}
public static void BindData(ASPxGridLookup gvlookup, DevExpress.Xpo.Session s, string objectname, string filter = "", params object[] parameter)
{
try
{
DynamicDataTableClassInfo classInfo = dynamicClasses[objectname];
if (classInfo != null)
{
XPServerCollectionSource ds = new XPServerCollectionSource(s, dynamicClasses[objectname], CriteriaOperator.Parse(filter, parameter));
gvlookup.DataSource = ds;
//gvlookup.KeyFieldName = classInfo.KeyProperty.DisplayName;
}
else
throw new Exception(string.Format("Đối tượng {0} không tìm thấy trong database. Nếu không có dữ liệu hiển thị thì XPOProfiles để xem điều kiện lọc đúng chưa", objectname));
}
catch (Exception ex)
{
SiAuto.Main.LogColored(Color.Red, "Loi BindData:" + ex.ToString());
throw ex;
}
}
private void buildRefreshBtn(ASPxGridLookup cmb)
{
string cmbClientName = cmb.ClientInstanceName;
EditButton btnRefresh = new EditButton();
btnRefresh.Image.IconID = "actions_refresh_16x16";
btnRefresh.Image.Height = Unit.Pixel(16);
btnRefresh.ToolTip = "Load lại dữ liệu";
cmb.Buttons.Add(btnRefresh);
cmb.ClientSideEvents.ButtonClick = string.Format("function(s,e){{cmbRefreshClick('{0}');}}", cmbClientName);
}
private void buildFavRefresh(ASPxGridLookup cmb, int ModulePage)
{
EditButton btnFav = new EditButton();
btnFav.Image.Url = "~/img/nonstar.png";
btnFav.Image.Height = Unit.Pixel(16);
btnFav.ToolTip = "Chọn làm giá trị mặc định";
cmb.Buttons.Add(btnFav);
EditButton btnRefresh = new EditButton();
btnRefresh.Image.IconID = "actions_refresh_16x16";
btnRefresh.Image.Height = Unit.Pixel(16);
btnRefresh.ToolTip = "Load lại dữ liệu";
cmb.Buttons.Add(btnRefresh);
string cmbClientName = cmb.ClientInstanceName;
string cmbClientID = cmb.ClientID + "_B0Img";
cmb.ClientSideEvents.Init = string.Format("function(s,e){{cmbFavInit(s,'{0}','{1}',{2});}}", cmbClientName, cmbClientID, ModulePage);
cmb.ClientSideEvents.ButtonClick = string.Format("function(s,e){{cmbFavRefClick(s,e,'{0}','{1}',{2});}}", cmbClientName, cmbClientID, ModulePage);
}
