protected void grid_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxTextBox text = grid.FindEditFormTemplateControl("txtName") as ASPxTextBox;
ASPxTextBox textId = grid.FindEditFormTemplateControl("txtId") as ASPxTextBox;
this.language.id = -1;
language.name = text.Text;
language.isactive = true;
this.objLanuage.AddLanguage(language);
grid.CancelEdit();
e.Cancel = true;
this.grid.DataSource = objLanuage.GetLanguages();
this.grid.DataBind();
}
protected void ASPxGridView1_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
string[] param = e.Parameters.Split('|');
if (param[0] == "oneRow")
{
int visibleIndex = int.Parse(param[1]);
ASPxGridView grid = sender as ASPxGridView;
ASPxTextBox tbCategoryName = grid.FindRowCellTemplateControl(visibleIndex, grid.Columns["CategoryName"] as GridViewDataColumn, "txtBox") as ASPxTextBox;
ASPxTextBox tbDescription = grid.FindRowCellTemplateControl(visibleIndex, grid.Columns["Description"] as GridViewDataColumn, "txtBox") as ASPxTextBox;
AccessDataSource1.UpdateParameters["CategoryName"].DefaultValue = tbCategoryName.Text;
AccessDataSource1.UpdateParameters["Description"].DefaultValue = tbDescription.Text;;
AccessDataSource1.UpdateParameters["CategoryID"].DefaultValue = grid.GetRowValues(visibleIndex, "CategoryID").ToString();
AccessDataSource1.Update();
}
ASPxGridView1.DataBind();
}
protected void grid_Zone_HtmlEditFormCreated(object sender, ASPxGridViewEditFormEventArgs e)
{
ASPxGridView grid = (sender as ASPxGridView) as ASPxGridView;
if (grid.EditingRowVisibleIndex > -1)
{
ASPxPageControl pageControl = grid.FindEditFormTemplateControl("pageControl_Zone") as ASPxPageControl;
ASPxTextBox txt_Zone_Code = pageControl.FindControl("txt_Zone_Code") as ASPxTextBox;
txt_Zone_Code.Enabled = false;
ASPxTextBox txt_PartyName = pageControl.FindControl("txt_PartyName") as ASPxTextBox;
ASPxTextBox txt_WarehouseName = pageControl.FindControl("txt_WarehouseName") as ASPxTextBox;
txt_PartyName.Text = EzshipHelper.GetPartyName(grid.GetRowValues(grid.EditingRowVisibleIndex, new string[] { "PartyId" }));
txt_WarehouseName.Text = EzshipHelper.GetWarehouse(grid.GetRowValues(grid.EditingRowVisibleIndex, new string[] { "WarehouseCode" }));
}
}
public void EnableCombinations(bool Value)
{
foreach (Control c in CombinationRow.Controls)
{
if (c is TextBox)
{
TextBox C = (TextBox)c;
C.Enabled = Value;
}
else if (c is DevExpress.Web.ASPxTextBox)
{
ASPxTextBox T = (ASPxTextBox)c;
T.Enabled = Value;
}
}
}
private void OnLoad()
{
int start = 0; // this.ASPxGridView1.PageIndex * ASPxGridView1.SettingsPager.PageSize;
int end = 100; // (ASPxGridView1.PageIndex + 1) * ASPxGridView1.SettingsPager.PageSize;
for (int i = start; i < end; i++)
{
ASPxTextBox docId = this.grid.FindRowTemplateControl(i, "txt_Id") as ASPxTextBox;
ASPxCheckBox isPay = this.grid.FindRowTemplateControl(i, "ack_IsPay") as ASPxCheckBox;
if (docId != null && isPay != null && isPay.Checked)
{
list.Add(new Record(SafeValue.SafeInt(docId.Text, 0)
));
}
}
}
// 新增
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxTextBox uCode = ASPxGridView1.FindEditFormTemplateControl("txtUCode") as ASPxTextBox;
ASPxTextBox uName = ASPxGridView1.FindEditFormTemplateControl("txtUName") as ASPxTextBox;
string inSql = "INSERT INTO CODE_USER (COMPANY_CODE, USER_ID, USER_CODE, USER_NAME,user_type) "
+ "VALUES('" + theCompanyCode + "',TRIM(TO_CHAR(SEQ_USER_ID.NEXTVAL,'000000')),'" + uCode.Text.Trim().ToUpper() + "','" + uName.Text.Trim() + "' ,'B')";
dataConn inDc = new dataConn();
inDc.ExeSql(inSql);
inDc.CloseConn();
e.Cancel = true;
ASPxGridView1.CancelEdit();
queryFunction();
}
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxTextBox uCXH = ASPxGridView1.FindEditFormTemplateControl("txtCXH") as ASPxTextBox;
ASPxTextBox txtFR = ASPxGridView1.FindEditFormTemplateControl("txtFR") as ASPxTextBox;
ASPxTextBox txtsat = ASPxGridView1.FindEditFormTemplateControl("txtSAT") as ASPxTextBox;
string strFR = txtFR.Text.Trim();
string Sql = "UPDATE ATPUFRCXH SET CXH='" + uCXH.Text.Trim() + "',sat='" + txtsat.Text.Trim() + "'"
+ " WHERE FR = '" + strFR + "'";
dc.ExeSql(Sql);
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
public override System.Web.UI.Control Build()
{
base.Build();
ASPxTextBox tb = new ASPxTextBox();
tb.Width = ModuleField.Width;
tb.Height = ModuleField.Height;
tb.MaskSettings.Mask = "(9999)99999999";
tb.MaskSettings.ErrorText = "格式错误！";
tb.MaskSettings.IncludeLiterals = MaskIncludeLiteralsMode.None;
tb.ValidationSettings.RequiredField.IsRequired = ModuleField.IsRequired;
tb.ValidationSettings.RequiredField.ErrorText = ModuleField.ErrorText;
tb.Text = ModuleField.CurrentValue == null ? ModuleField.DefaultValue == null ? null : ModuleField.DefaultValue.ToString() : ModuleField.CurrentValue.ToString();
tb.NullText = ModuleField.NullText;
return(tb);
}
protected void grid_InvDet_InitNewRow(object sender, DevExpress.Web.Data.ASPxDataInitNewRowEventArgs e)
{
e.NewValues["DocLineNo"] = 0;
ASPxTextBox docCurr = this.ASPxGridView1.FindEditFormTemplateControl("txt_Currency") as ASPxTextBox;
e.NewValues["Currency"] = docCurr.Text;
//e.NewValues["Currency"] = System.Configuration.ConfigurationManager.AppSettings["Currency"];
e.NewValues["ExRate"] = 1.0;
e.NewValues["GstAmt"] = 0;
e.NewValues["DocAmt"] = 0;
e.NewValues["LocAmt"] = 0;
e.NewValues["Qty"] = 1;
e.NewValues["Price"] = 0;
e.NewValues["GstType"] = "Z";
e.NewValues["AcSource"] = "CR";
}
protected void btnSave_Command(object sender, CommandEventArgs e)
{
ASPxTextBox txtPassword = gvTSelf.FindEditFormTemplateControl("txtPassword") as ASPxTextBox;
ASPxTextBox txtName = gvTSelf.FindEditFormTemplateControl("txtName") as ASPxTextBox;
string password = txtPassword.Text;
if (password.Length < 6)
{
Response.Write("<script>alert('密码不得少于6位')</script>");
return;
}
else
{
gvTSelf.UpdateEdit();
}
}
protected void grid_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxTextBox text = grid.FindEditFormTemplateControl("txtName") as ASPxTextBox;
ASPxTextBox textId = grid.FindEditFormTemplateControl("txtId") as ASPxTextBox;
this.country.id = -1;
country.name = text.Text;
country.isactive = true;
this.objCountry.AddCountry(country);
grid.CancelEdit();
e.Cancel = true;
this.grid.DataSource = objCountry.GetCountrys();
this.grid.DataBind();
}
protected void grid_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxTextBox text = grid.FindEditFormTemplateControl("txtName") as ASPxTextBox;
ASPxTextBox textId = grid.FindEditFormTemplateControl("txtId") as ASPxTextBox;
this.health.id = -1;
health.name = text.Text;
health.isactive = true;
this.objHealth.AddHealthType(health);
grid.CancelEdit();
e.Cancel = true;
this.grid.DataSource = objHealth.GetHealthTypes();
this.grid.DataBind();
}
protected override WebControl CreateEditModeControlCore()
{
if (AllowEdit.ResultValue)
{
ASPxTextBox textBox = RenderHelper.CreateASPxTextBox();
textBox.ID = "textBox";
textBox.ValidationSettings.RegularExpression.ValidationExpression = UrlEmailMask;
textBox.ValidationSettings.RegularExpression.ErrorText = UserVisibleExceptionLocalizer.GetExceptionMessage(UserVisibleExceptionId.MaskValidationErrorMessage);
textBox.TextChanged += EditValueChangedHandler;
return(textBox);
}
else
{
return(CreateViewModeControlCore());
}
}
protected void grid_bkg_RowUpdated(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
ASPxGridView grd = sender as ASPxGridView;
ASPxTextBox mkgId = grd.FindEditFormTemplateControl("txtMkgId") as ASPxTextBox;
ASPxSpinEdit wt = grd.FindEditFormTemplateControl("spin_wt2") as ASPxSpinEdit;
ASPxSpinEdit m3 = grd.FindEditFormTemplateControl("spin_m4") as ASPxSpinEdit;
ASPxSpinEdit qty = grd.FindEditFormTemplateControl("spin_pkg2") as ASPxSpinEdit;
ASPxButtonEdit pkgType = grd.FindEditFormTemplateControl("txt_pkgType2") as ASPxButtonEdit;
ASPxMemo mkg = grd.FindEditFormTemplateControl("txt_mkg2") as ASPxMemo;
ASPxMemo des = grd.FindEditFormTemplateControl("txt_des2") as ASPxMemo;
string sql = string.Format("update SeaExportMkg set Qty='{1}',PackageType='{2}',Weight='{3}',Volume='{4}',Marking='{5}',Description='{6}' where SequenceId='{0}'"
, mkgId.Text, qty.Value, pkgType.Text, wt.Value, m3.Value, mkg.Text, des.Text);
ConnectSql.ExecuteSql(sql);
}
public void InstantiateIn(Control _container)
{
GridViewEditItemTemplateContainer container = _container as GridViewEditItemTemplateContainer;
object[] values = (object[])container.Grid.GetRowValues(container.VisibleIndex, new string[] { "Type", "DataValue" });
string dataType = Convert.ToString(values[0]);
string dataValue = Convert.ToString(values[1]);
switch (dataType)
{
case "Text":
ASPxTextBox txt = new ASPxTextBox();
txt.ID = "txt";
txt.Text = dataValue;
container.Controls.Add(txt);
break;
case "DateTime":
ASPxDateEdit date = new ASPxDateEdit();
date.ID = "date";
date.Date = Convert.ToDateTime(dataValue);
container.Controls.Add(date);
break;
case "Dictionary1":
ASPxComboBox cmb = new ASPxComboBox();
cmb.ID = "dict";
cmb.DataSource = DataProvider.GetDictionaryData(DataType.Dictionary1);
cmb.TextField = "Data";
cmb.ValueField = "Id";
cmb.DataBind();
cmb.Value = dataValue;
container.Controls.Add(cmb);
break;
case "Dictionary2":
ASPxComboBox cmb2 = new ASPxComboBox();
cmb2.ID = "dict";
cmb2.DataSource = DataProvider.GetDictionaryData(DataType.Dictionary2);
cmb2.TextField = "Data";
cmb2.ValueField = "Id";
cmb2.DataBind();
cmb2.Value = dataValue;
container.Controls.Add(cmb2);
break;
}
}
protected void ASPxCardView1_CardInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxCardView card = sender as ASPxCardView;
ASPxTextBox f = FindPageControl(card).FindControl("f") as ASPxTextBox;
e.NewValues["FirstName"] = f.Text;
ASPxTextBox l = FindPageControl(card).FindControl("l") as ASPxTextBox;
e.NewValues["LastName"] = l.Text;
ASPxTextBox j = FindPageControl(card).FindControl("j") as ASPxTextBox;
e.NewValues["JeuneFilleName"] = j.Text;
ASPxTextBox p = FindPageControl(card).FindControl("p") as ASPxTextBox;
e.NewValues["Position"] = p.Text;
ASPxDateEdit d = FindPageControl(card).FindControl("d") as ASPxDateEdit;
e.NewValues["DateOfBirth"] = Convert.ToDateTime(d.Text);
ASPxTextBox m = FindPageControl(card).FindControl("m") as ASPxTextBox;
e.NewValues["MaritalStatus"] = m.Text;
ASPxTextBox s = FindPageControl(card).FindControl("s") as ASPxTextBox;
e.NewValues["SocialSecurityRef"] = s.Text;
ASPxTextBox fa = FindPageControl(card).FindControl("fa") as ASPxTextBox;
e.NewValues["FatherId"] = fa.Text;
ASPxTextBox mo = FindPageControl(card).FindControl("mo") as ASPxTextBox;
e.NewValues["MotherId"] = mo.Text;
ASPxTextBox st = FindPageControl(card).FindControl("st") as ASPxTextBox;
e.NewValues["State"] = st.Text;
ASPxDateEdit da = FindPageControl(card).FindControl("da") as ASPxDateEdit;
e.NewValues["DeathDate"] = Convert.ToDateTime(da.Text);
ASPxTextBox sex = FindPageControl(card).FindControl("sex") as ASPxTextBox;
e.NewValues["Sexe"] = sex.Text;
ASPxTextBox fax = FindPageControl(card).FindControl("fax") as ASPxTextBox;
e.NewValues["Fax"] = fax.Text;
ASPxTextBox note = FindPageControl(card).FindControl("note") as ASPxTextBox;
e.NewValues["note"] = note.Text;
e.NewValues["Photo"] = Session["data"];
}
//end update
/// <summary>
/// new record
/// </summary>
protected int insert_voyage()
{
int _newid = 0;
try
{
///new instance of record
VoyageTable _tbl = new VoyageTable();
string _joined = "";
//get values off editform
//vessel id
ASPxComboBox _cbo = (ASPxComboBox)this.fmvVoyage.FindControl("dxcboVesselID");
if (_cbo != null && _cbo.Value != null)
{
_tbl.VesselID = wwi_func.vint(_cbo.Value.ToString());
_joined = _cbo.Text.ToString();
}
//voyage number
ASPxTextBox _txt = (ASPxTextBox)this.fmvVoyage.FindControl("dxtxtVoyageNumber");
if (_txt != null)
{
_tbl.VoyageNumber = _txt.Text.ToString();
_joined += " " + _txt.Text.ToString();
}
//joined = vessel name & voyage number
_tbl.Joined = _joined;
//user
_tbl.AddedBy = Page.Session["user"] != null ? (Int32)((UserClass)Page.Session["user"]).UserId : 0;
//date
_tbl.DateAdded = DateTime.Now;
//insert
_tbl.Save();
//get new id
_newid = (int)_tbl.GetPrimaryKeyValue();
}
catch (Exception ex)
{
string _ex = ex.Message.ToString();
this.dxlblErr.Text = _ex;
this.dxpnlErr.ClientVisible = true;
}
return(_newid);
}
protected void grid_InvDet_InitNewRow(object sender, DevExpress.Web.Data.ASPxDataInitNewRowEventArgs e)
{
e.NewValues["DocLineNo"] = 0;
ASPxTextBox docCurr = this.ASPxGridView1.FindEditFormTemplateControl("txt_Currency") as ASPxTextBox;
e.NewValues["Currency"] = docCurr.Text;
e.NewValues["ExRate"] = 1.0;
e.NewValues["GstAmt"] = 0;
e.NewValues["DocAmt"] = 0;
e.NewValues["LocAmt"] = 0;
e.NewValues["Qty"] = 1;
e.NewValues["Price"] = 0;
e.NewValues["GstType"] = "Z";
e.NewValues["AcSource"] = "DB";
e.NewValues["InvNo"] = " ";
e.NewValues["InvId"] = 0;
}
//修改
protected void ASPxGridView2_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs 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();
//插入到日志表
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 + "' and JX= '" + strJX + "'";
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 + "'and JX= '" + strJX + "' ";
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 + "' and JX= '" + strJX + "'";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView2.CancelEdit();
setCondition();
}
protected void grid_ref_HtmlEditFormCreated(object sender, ASPxGridViewEditFormEventArgs e)
{
if (this.grid_ref.EditingRowVisibleIndex > -1)
{
ASPxPageControl pageControl = this.grid_ref.FindEditFormTemplateControl("pageControl") as ASPxPageControl;
ASPxTextBox txt_AgentName = this.grid_ref.FindEditFormTemplateControl("txt_AgentName") as ASPxTextBox;
ASPxTextBox txt_CrAgentName = this.grid_ref.FindEditFormTemplateControl("txt_CrAgentName") as ASPxTextBox;
ASPxTextBox txt_NvoccAgentName = pageControl.FindControl("txt_NvoccAgentName") as ASPxTextBox;
ASPxTextBox txt_LocalCustName = this.grid_ref.FindEditFormTemplateControl("txt_LocalCustName") as ASPxTextBox;
ASPxTextBox txt_WhName = pageControl.FindControl("txt_WhName") as ASPxTextBox;
ASPxDateEdit refDate = this.grid_ref.FindEditFormTemplateControl("date_RefDate") as ASPxDateEdit;
refDate.ReadOnly = true;
refDate.BackColor = ((DevExpress.Web.ASPxEditors.ASPxTextBox)(this.grid_ref.FindEditFormTemplateControl("txt_RefN"))).BackColor;
txt_LocalCustName.Text = EzshipHelper.GetPartyName(this.grid_ref.GetRowValues(this.grid_ref.EditingRowVisibleIndex, new string[] { "LocalCust" }));
txt_AgentName.Text = EzshipHelper.GetPartyName(this.grid_ref.GetRowValues(this.grid_ref.EditingRowVisibleIndex, new string[] { "AgentId" }));
txt_CrAgentName.Text = EzshipHelper.GetPartyName(this.grid_ref.GetRowValues(this.grid_ref.EditingRowVisibleIndex, new string[] { "CarrierAgentId" }));
txt_NvoccAgentName.Text = EzshipHelper.GetPartyName(this.grid_ref.GetRowValues(this.grid_ref.EditingRowVisibleIndex, new string[] { "NvoccAgentId" }));
txt_WhName.Text = EzshipHelper.GetPartyName(this.grid_ref.GetRowValues(this.grid_ref.EditingRowVisibleIndex, new string[] { "WareHouseId" }));
int oid = SafeValue.SafeInt(this.grid_ref.GetRowValues(this.grid_ref.EditingRowVisibleIndex, new string[] { "Id" }), 0);
if (oid > 0)
{
string userId = HttpContext.Current.User.Identity.Name;
ASPxLabel lab_StatusCode = pageControl.FindControl("lb_JobStatus") as ASPxLabel;
string sql = string.Format("select StatusCode from air_ref where Id={0}", oid);
string closeInd = SafeValue.SafeString(Manager.ORManager.ExecuteScalar(sql));
ASPxButton btn_VoidMaster = this.grid_ref.FindEditFormTemplateControl("btn_VoidMaster") as ASPxButton;
ASPxButton btn_CloseJob = this.grid_ref.FindEditFormTemplateControl("btn_CloseJob") as ASPxButton;
if (closeInd == "CLS")
{
btn_CloseJob.Text = "Open Job";
lab_StatusCode.Text = "Close";
}
else if (closeInd == "CNL")
{
btn_VoidMaster.Text = "Unvoid";
lab_StatusCode.Text = "Void";
}
else
{
btn_CloseJob.Text = "Close Job";
lab_StatusCode.Text = "USE";
btn_VoidMaster.Text = "Void";
}
}
}
}
private ASPxTextBox createNode(string nodeText, string nodeId)
{
ASPxTextBox newNode = new ASPxTextBox();
newNode.Text = nodeText;
newNode.ID = nodeId;
newNode.Border.BorderStyle = BorderStyle.Solid;
newNode.Border.BorderWidth = 1;
newNode.Height = 100;
newNode.Width = 170;
newNode.Enabled = false;
newNode.Cursor = "pointer";
newNode.HorizontalAlign = HorizontalAlign.Center;
//newNode.ClientSideEvents = "function(s,e) {var index = ListNode.GetSelectedIndex();if(index!=-1) {var items = ListNode.GetSelectedItems();PanelNode.PerformCallback(items[0].text);}}";
return(newNode);
}
protected void grid_Zone_BeforePerformDataSelect(object sender, EventArgs e)
{
ASPxPageControl pageControl = this.grid.FindEditFormTemplateControl("pageControl") as ASPxPageControl;
ASPxTextBox txt_Code = pageControl.FindControl("txt_Code") as ASPxTextBox;
string where = "";
if (txt_Code.Text.Trim() != "")
{
where = "LocLevel='Zone'";
where += string.Format(" and WarehouseCode='{0}'", txt_Code.Text.Trim());
}
else
{
where = "1=0";
}
this.dsRefZone.FilterExpression = where;
}
protected void grid_Transport_HtmlRowPrepared(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewTableRowEventArgs e)
{
if (e.RowType != DevExpress.Web.ASPxGridView.GridViewRowType.Data)
{
return;
}
ASPxButtonEdit driver = this.grid_Transport.FindRowTemplateControl(e.VisibleIndex, "btn_DriveCode") as ASPxButtonEdit;
if (driver != null)
{
driver.ClientInstanceName = driver.ClientInstanceName + e.VisibleIndex;
ASPxTextBox towhead = this.grid_Transport.FindRowTemplateControl(e.VisibleIndex, "txt_TowheadCode") as ASPxTextBox;
towhead.ClientInstanceName = towhead.ClientInstanceName + e.VisibleIndex;
ASPxTextBox ScheduleDate = this.grid_Transport.FindRowTemplateControl(e.VisibleIndex, "txt_ScheduleDate") as ASPxTextBox;
driver.ClientSideEvents.ButtonClick = "function(s,e){" + string.Format("PopupCTM_DriverLog({0},null,{1},'{2}');", driver.ClientInstanceName, towhead.ClientInstanceName, ScheduleDate.Text) + "}";
}
}
protected void grid_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxTextBox text = grid.FindEditFormTemplateControl("txtName") as ASPxTextBox;
ASPxTextBox txtMaNhom = grid.FindEditFormTemplateControl("txtMaNhom") as ASPxTextBox;
ASPxSpinEdit txtThuTu = grid.FindEditFormTemplateControl("txtThuTu") as ASPxSpinEdit;
ASPxComboBox cmbNNL = grid.FindEditFormTemplateControl("cmbNNL") as ASPxComboBox;
int n = SqlHelper.ExecuteNonQuery(strconn, "SP_HRM_NhomChucDanhB", Int32.Parse(e.Keys[grid.KeyFieldName].ToString()), text.Text, txtMaNhom.Text, Int32.Parse(txtThuTu.Text), Int32.Parse(cmbNNL.Value.ToString()), 1);
grid.CancelEdit();
e.Cancel = true;
LoadNhomChucDanh();
}
protected void grd_DSRole_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
try
{
e.Cancel = true;
ASPxFormLayout pnLayData = grd_DSRole.FindEditFormTemplateControl("LayOutThemSua") as ASPxFormLayout;
ASPxMemo txtNote = pnLayData.FindControl("txtNote") as ASPxMemo;
ASPxTextBox txtName = pnLayData.FindControl("txtName") as ASPxTextBox;
ctlRole.insertRoles(txtName.Text, txtNote.Text);
BindataThemNhanh();
Utils.notifierGrid(grd_DSRole, Constant.NOTIFY_SUCCESS, "Bạn đã thêm thành công Role có [" + txtName.Text + "]");
}
catch (Exception ex)
{
Utils.notifierGrid(grd_DSRole, Constant.NOTIFY_FAILURE, ex.Message + " " + ex.StackTrace);
}
}
protected void cmb_Status_CustomJSProperties(object sender, DevExpress.Web.ASPxClasses.CustomJSPropertiesEventArgs e)
{
ASPxComboBox cmb_Status = grid.FindEditFormTemplateControl("cmb_Status") as ASPxComboBox;
ASPxTextBox txt_LcNo = grid.FindEditFormTemplateControl("txt_LcNo") as ASPxTextBox;
string doNo = SafeValue.SafeString(txt_LcNo.Text);
string sql = string.Format(@"select StatusCode from Wh_Trans where LcNo='{0}'", doNo);
string status = SafeValue.SafeString(C2.Manager.ORManager.ExecuteScalar(sql), "N");
if (status == "Confirmed")
{
cmb_Status.Text = "Confirmed";
}
if (status == "Draft")
{
cmb_Status.Text = "Draft";
}
}
protected void grid_contact_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxPageControl pageControl = this.grid.FindEditFormTemplateControl("pageControl") as ASPxPageControl;
ASPxTextBox txtPartyId = pageControl.FindControl("txtPartyId") as ASPxTextBox;
ASPxTextBox txtName = pageControl.FindControl("txtName") as ASPxTextBox;
e.NewValues["PartyId"] = txtPartyId.Text;
e.NewValues["PartyName"] = txtName.Text;
e.NewValues["IsDefault"] = SafeValue.SafeBool(e.NewValues["IsDefault"], true);
e.NewValues["Name"] = SafeValue.SafeString(e.NewValues["Name"]);
e.NewValues["Tel"] = SafeValue.SafeString(e.NewValues["Tel"]);
e.NewValues["Fax"] = SafeValue.SafeString(e.NewValues["Fax"]);
e.NewValues["Address"] = SafeValue.SafeString(e.NewValues["Address"]);
e.NewValues["Email"] = SafeValue.SafeString(e.NewValues["Email"]);
e.NewValues["Mobile"] = SafeValue.SafeString(e.NewValues["Mobile"]);
e.NewValues["Remark"] = SafeValue.SafeString(e.NewValues["Remark"]);
}
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxTextBox uJX = ASPxGridView1.FindEditFormTemplateControl("txtJX") as ASPxTextBox;
ASPxTextBox uRZG = ASPxGridView1.FindEditFormTemplateControl("txtRZG") as ASPxTextBox;
ASPxTextBox uSC = ASPxGridView1.FindEditFormTemplateControl("txtSC") as ASPxTextBox;
ASPxTextBox uS1 = ASPxGridView1.FindEditFormTemplateControl("txtS1") as ASPxTextBox;
ASPxTextBox uS2 = ASPxGridView1.FindEditFormTemplateControl("txtS2") as ASPxTextBox;
ASPxTextBox uS3 = ASPxGridView1.FindEditFormTemplateControl("txtS3") as ASPxTextBox;
ASPxComboBox uSFMRZ = ASPxGridView1.FindEditFormTemplateControl("txtSFMRZ") as ASPxComboBox;
string strSFMRZ = uSFMRZ.Value.ToString();
//插入到日志表
try
{
string Sql2 = "INSERT INTO ATPUEMARK_LOG (FDJJX,SC,RZZS1,RZZS2,RZZS3,RZG,SFMRZ,WHRQ,RYDM,user_code,flag,rqsj)"
+ " SELECT FDJJX,SC,RZZS1,RZZS2,RZZS3,RZG,SFMRZ,WHRQ,RYDM,'" + theUserCode + "' , 'BEFOREEDIT', SYSDATE FROM ATPUEMARK WHERE FDJJX = '" + uJX.Text.Trim() + "'";
dc.ExeSql(Sql2);
}
catch
{
return;
}
string Sql = "UPDATE ATPUEMARK SET SC='" + uSC.Text.Trim().ToUpper() + "',RZZS1='" + uS1.Text.Trim() + "',RZZS2='" + uS2.Text.Trim() + "',"
+ "RZZS3='" + uS3.Text.Trim() + "',RZG='" + uRZG.Text.Trim() + "',SFMRZ='" + uSFMRZ.Text.Trim() + "',"
+ "WHRQ=to_date('" + theTime + "','yyyy-mm-dd hh24:mi:ss'),INPUT_TIME=SYSDATE,INPUT_PERSON='" + theUserId + "' "
+ " WHERE FDJJX = '" + uJX.Text.Trim() + "'";
dc.ExeSql(Sql);
//插入到日志表
try
{
string Sql2 = "INSERT INTO ATPUEMARK_LOG (FDJJX,SC,RZZS1,RZZS2,RZZS3,RZG,SFMRZ,WHRQ,RYDM,user_code,flag,rqsj)"
+ " SELECT FDJJX,SC,RZZS1,RZZS2,RZZS3,RZG,SFMRZ,WHRQ,RYDM,'" + theUserCode + "' , 'AFTEREDIT', SYSDATE FROM ATPUEMARK WHERE FDJJX = '" + uJX.Text.Trim() + "'";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
protected override void SetupControl(WebControl control)
{
base.SetupControl(control);
if (control is ASPxTextBox)
{
ASPxTextBox aSPxTextBox = (ASPxTextBox)control;
ASPxPureTextBoxBase aSPxPureTextBox = (ASPxPureTextBoxBase)control;
aSPxPureTextBox.HorizontalAlign = HorizontalAlign.Left;
aSPxTextBox.MaskSettings.Mask = "$ <-99999999999..99999999999g>.<00..99>";
aSPxTextBox.MaskSettings.IncludeLiterals = MaskIncludeLiteralsMode.All;
aSPxTextBox.MaskSettings.AllowMouseWheel = false;
aSPxTextBox.DisplayFormatString = CurrencyFormat;
aSPxTextBox.ValueChanged += new EventHandler(this.SelectedCurrencyChangedHandler);
aSPxTextBox.ValidationSettings.ErrorDisplayMode = ErrorDisplayMode.None;
}
}
protected void grid_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxTextBox txtName = grid.FindEditFormTemplateControl("txtName") as ASPxTextBox;
ASPxTextBox txtVietTat = grid.FindEditFormTemplateControl("txtVietTat") as ASPxTextBox;
ASPxTextBox txtCapKhenThuong = grid.FindEditFormTemplateControl("txtCapKhenThuong") as ASPxTextBox;
ASPxMemo memoGhiChu = grid.FindEditFormTemplateControl("memoGhiChu") as ASPxMemo;
ASPxComboBox cmbDoiTuongUpdate = grid.FindEditFormTemplateControl("cmbDoiTuongUpdate") as ASPxComboBox;
ASPxComboBox cmbThanhTichUpdate = grid.FindEditFormTemplateControl("cmbThanhTichUpdate") as ASPxComboBox;
int n = SqlHelper.ExecuteNonQuery(strconn, "[HRM_DanhHieuThiDua_UI]", Int32.Parse(e.Keys[grid.KeyFieldName].ToString()), cmbThanhTichUpdate.Value, txtName.Text, txtVietTat.Text, memoGhiChu.Text,
cmbDoiTuongUpdate.Value, txtCapKhenThuong.Text, 1);
grid.CancelEdit();
e.Cancel = true;
grid.DataBind();
LoadDanhHieuThiDua(Int32.Parse(cmbDoiTuong.Value.ToString()), Int32.Parse(cmbThanhTich.Value.ToString()));
}
public List<WebControl> RenderControl(XmlNode xmlControl)
{
base.Initialize(xmlControl);
ASPxTextBox aspxTextBox = new ASPxTextBox
{
MaxLength = _PropertyMapper.GetMaxLength(),
ID = _PropertyMapper.GetID(),
NullText = "Ingrese un valor",
Width = new Unit(80, UnitType.Percentage),
ReadOnly = _PropertyMapper.ReadOnly()
};
aspxTextBox.ValidationSettings.SetFocusOnError = true;
aspxTextBox.ValidationSettings.RequiredField.IsRequired = _PropertyMapper.Required();
aspxTextBox.ValidationSettings.RequiredField.ErrorText = "Campo Requerido";
aspxTextBox.ValidationSettings.ValidationGroup = "InputValidation";
_Controls.Add(aspxTextBox);
return _Controls;
}
protected void BindExisting(ASPxSpinEdit txtSerialLevel, ASPxTextBox txtNameLevel, ASPxTextBox txtAbbrLevel, string ORG_SERIAL, ASPxRadioButton rdActive, ASPxRadioButton rdCancel)
{
string SQL = "select ORG_SERIAL,ORG_NAME,ORG_ABBR,ORG_TYPE,ORG_STATUS from CTLT_ORGANIZE where ORG_SERIAL='" + ORG_SERIAL + "'";
SqlDataAdapter DA = new SqlDataAdapter(SQL, OPM_BL.DefaultConnectionString);
DataTable DT = new DataTable();
DA.Fill(DT);
if (DT.Rows.Count > 0)
{
txtSerialLevel.Text = DT.Rows[0]["ORG_SERIAL"].ToString();
txtSerialLevel.ReadOnly = true;
txtSerialLevel.BackColor = System.Drawing.Color.Gray;
txtNameLevel.Text = DT.Rows[0]["ORG_NAME"].ToString();
txtAbbrLevel.Text = DT.Rows[0]["ORG_ABBR"].ToString();
if ( DT.Rows[0]["ORG_STATUS"].ToString() == "A"){
rdActive .Checked =true ;
rdCancel.Checked =false ;
}else{
rdActive .Checked =false ;
rdCancel.Checked =true ;
}
}
else
{
txtSerialLevel.Text = "";
txtSerialLevel.ReadOnly = false;
txtSerialLevel.BackColor = System.Drawing.Color.White;
txtNameLevel.Text = "";
txtAbbrLevel.Text = "";
rdActive.Checked = true;
rdCancel.Checked = false;
}
}
public void InstantiateIn(Control container)
{
Control control = new Control();
control.ID = "GroupDetectorEditForm";
container.Controls.Add(control);
DataTable dt = datafield;
string db_name = "";
string desc_name = "";
string auth = "";
string cell_type = "";
ASPxFormLayout editform_GroupDetector = new ASPxFormLayout();
editform_GroupDetector.ID = "editform_GroupDetector";
//editform_GroupDetector.Border.BorderWidth = Unit.Pixel(1);
//editform_GroupDetector.SettingsItems.VerticalAlign = FormLayoutVerticalAlign.Middle;
//editform_GroupDetector.SettingsItems.HorizontalAlign = FormLayoutHorizontalAlign.Center;
editform_GroupDetector.Paddings.Padding = Unit.Pixel(8);
foreach (DataRow dr in dt.Select("AUTH <> 'System'", "VIEW_SEQ"))
{
db_name = dr["DB_NAME"].ToString();
desc_name = dr["DESC_NAME"].ToString();
auth = dr["AUTH"].ToString();
cell_type = dr["SEL_TYPE"].ToString();
LayoutItem li = new LayoutItem(desc_name);
li.FieldName = db_name;
editform_GroupDetector.Items.Add(li);
LayoutItemNestedControlContainer li_container = li.LayoutItemNestedControlContainer;
if (auth == "Manager")
{
li.CaptionStyle.Font.Bold = true;
li.CaptionStyle.ForeColor = Color.Red;
}
if (cell_type == "DropDown List")
{
ASPxDropDownEdit dropdownEdit = new ASPxDropDownEdit();
dropdownEdit.ID = db_name;
ASPxComboBox comboBox = new ASPxComboBox();
comboBox.DataSource = Srch_DropDownItem(db_name);
comboBox.TextField = "LOOKUPDETDESC";
comboBox.DataBind();
comboBox.IncrementalFilteringMode = IncrementalFilteringMode.StartsWith;
comboBox.DropDownStyle = DropDownStyle.DropDown;
comboBox.EnableSynchronization = DevExpress.Utils.DefaultBoolean.False;
li_container.Controls.Add(comboBox);
}
else if (cell_type == "Note")
{
ASPxMemo textMemo = new ASPxMemo();
textMemo.ID = db_name;
textMemo.Width = Unit.Percentage(91);
li_container.Controls.Add(textMemo);
}
else
{
ASPxTextBox textBox = new ASPxTextBox();
textBox.ID = db_name;
li_container.Controls.Add(textBox);
//Suffix 증가 유무 체크 (15.10.16)
if (db_name == "CNT")
{
li = new LayoutItem("Suffix");
li.FieldName = "DETECTOR_SUFFIX";
editform_GroupDetector.Items.Add(li);
li_container = li.LayoutItemNestedControlContainer;
ASPxCheckBox chkBox = new ASPxCheckBox();
chkBox.ID = "DETECTOR_SUFFIX";
li_container.Controls.Add(chkBox);
}
}
}
container.Controls.Add(editform_GroupDetector);
//container.Controls.Add(editform_GroupDetector);
//Button
ASPxFormLayout btn_lo = new ASPxFormLayout();
btn_lo.ID = "button_GroupDetector";
btn_lo.ColCount = 1;
btn_lo.Width = Unit.Percentage(90);
btn_lo.SettingsItems.HorizontalAlign = FormLayoutHorizontalAlign.Right;
btn_lo.Paddings.Padding = Unit.Pixel(1);
LayoutItem btn_li = new LayoutItem("btn_li");
btn_li.ShowCaption = DevExpress.Utils.DefaultBoolean.False;
btn_lo.Items.Add(btn_li);
LayoutItemNestedControlContainer btn_li_container = btn_li.LayoutItemNestedControlContainer;
ASPxGridViewTemplateReplacement btn_add = new ASPxGridViewTemplateReplacement();
btn_add.ReplacementType = GridViewTemplateReplacementType.EditFormUpdateButton;
btn_add.ID = "btn_add";
btn_li_container.Controls.Add(btn_add);
//LayoutItem btn_li2 = new LayoutItem("btn_li2");
//btn_li2.ShowCaption = DevExpress.Utils.DefaultBoolean.False;
//btn_lo.Items.Add(btn_li2);
//LayoutItemNestedControlContainer btn_li_container2 = btn_li2.LayoutItemNestedControlContainer;
ASPxGridViewTemplateReplacement btn_cancel = new ASPxGridViewTemplateReplacement();
btn_cancel.ReplacementType = GridViewTemplateReplacementType.EditFormCancelButton;
btn_cancel.ID = "btn_cancel";
btn_li_container.Controls.Add(btn_cancel);
//btn_li.HorizontalAlign = FormLayoutHorizontalAlign.Right;
container.Controls.Add(btn_lo);
}
private WebControl CreateTextEdit(Control container)
{
ASPxTextBox textbox = new ASPxTextBox();
templateContainer = (GridViewDataItemTemplateContainer)container;
textbox.ID = string.Format("{0}_{1}", (templateContainer.Column).FieldName, templateContainer.VisibleIndex);
textbox.ClientInstanceName = string.Format("{0}_{1}", (templateContainer.Column).FieldName, templateContainer.VisibleIndex);
textbox.Value = templateContainer.Grid.GetRowValues(templateContainer.VisibleIndex, (templateContainer.Column).FieldName).ToString();
object clientevent = SqlHelper.ExecuteScalar( DataServices.ConnectString, "SY_modulefields_getClientevent", _moduleID, _tableName, (templateContainer.Column).FieldName);
if (clientevent != null)
{
Dictionary<string, string> valueclientevent = JsonConvert.DeserializeObject<Dictionary<string, string>>(clientevent.ToString());
if (valueclientevent != null)
{
textbox.ClientSideEvents.GotFocus = valueclientevent["gotfocus"];
textbox.ClientSideEvents.Init = valueclientevent["init"];
textbox.ClientSideEvents.KeyDown = valueclientevent["keydown"];
textbox.ClientSideEvents.KeyPress = valueclientevent["keypress"];
textbox.ClientSideEvents.KeyUp = valueclientevent["keyup"];
textbox.ClientSideEvents.LostFocus = valueclientevent["lostfocus"];
textbox.ClientSideEvents.TextChanged = valueclientevent["textchanged"];
textbox.ClientSideEvents.Validation = valueclientevent["validation"];
textbox.ClientSideEvents.ValueChanged = valueclientevent["valuechanged"];
//{"gotfocus":"","init":"","keydown":"","keypress":"","keyup":"","lostfocus":"","textchanged":"","validation":"","valuechanged":""}
}
}
return textbox;
}
public List<HtmlTableCell> BuildTextBox(string fieldtext, string id, string helptext, string SkinID, int length, 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%");
ASPxTextBox txt = new ASPxTextBox();
txt.Style.Add("Width", "98%");
txt.SkinID = SkinID;
txt.MaxLength = length;
txt.NullText = helptext;
txt.ID = id;
txt.Theme = "DevEx";
txt.AutoPostBack = false;
txt.Text = controlValue;
txt.Width = Unit.Percentage(100);
txt.ReadOnly = isReadOnly;
celledit.Controls.Add(txt);
c.Add(cell);
c.Add(celledit);
cot += 2;
}
catch (Exception)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), Guid.NewGuid().ToString(),
"<script> alert('buildTextBox fieldname"+id+"'); </script>",
false);
}
return c;
}
public static void SetTextBoxValue(ASPxTextBox Textbox, object objects)
{
try
{
if (objects != null)
Textbox.Text = objects.ToString();
}
catch (Exception ex)
{
SiAuto.Main.LogString("Lỗi SetTextBoxValue :", ex.ToString());
}
}
public static void AddTextQuestionAdvanced(BusinessLogicLayer.Entities.FormBuilder.FormField Q, Panel QuestionPanel)
{
QuestionPanel.ToolTip = Q.FormFieldType.Name;
Label QuestionTitle = new Label();
QuestionTitle.Text = String.Format(@"<span class='fb-Title'>{0}</span>", Q.Title);
//-----
Label IsReqired = new Label();
IsReqired.Text = (Q.IsRequired) ? "*Required" : "";
//-----
Label HelpText = new Label();
HelpText.Text = Q.HelpText;
//-----
ASPxTextBox txtAnswer = new ASPxTextBox();
txtAnswer.ID = String.Format("Answer{0}", Q.FormFieldValues[0].FormFieldValueId);
txtAnswer.Width = new Unit(250);
if (Q.IsRequired)
{
txtAnswer.ValidationSettings.CausesValidation = true;
txtAnswer.ValidationSettings.ErrorDisplayMode = ErrorDisplayMode.Text;
txtAnswer.ValidationSettings.RequiredField.IsRequired = true;
}
//-----
ControlsAdder(QuestionPanel, QuestionsTemplates.Text, new Control[4] { QuestionTitle, IsReqired, HelpText, txtAnswer }, new String[4] { "@QuestionTitle", "@IsRequired", "@HelpText", "@AnswerTextBox" });
}
protected void Page_Load(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(TabPage)) throw new NullReferenceException("TabPage Vazia");
if (string.IsNullOrEmpty(GridID)) throw new NullReferenceException("GridView Vazia");
if (string.IsNullOrEmpty(DataSourceID)) throw new NullReferenceException("DataSourceID Vazia");
txtBox = NamingContainer.FindControl(TxtBoxID) as ASPxTextBox;
Grid = NamingContainer.FindControl(GridID) as ASPxGridView;
DataSource = NamingContainer.FindControl(DataSourceID) as SqlDataSource;
UsuariosControle ctrlUsu = new UsuariosControle();
string idUsu = ctrlUsu.GetUsuarioByLogin(HttpContext.Current.Session["pUId"].ToString()).UsuarioID.ToString();
sqlSituacao.SelectParameters["@usuario"].DefaultValue = idUsu;
sqlSituacaoExterno.SelectParameters["@usuario"].DefaultValue = idUsu;
HabilitarBotoes();
}
