protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
int totCnt = SafeValue.SafeInt(System.Configuration.ConfigurationManager.AppSettings["License"], 0);
int cnt = SafeValue.SafeInt(C2.Manager.ORManager.ExecuteScalar("SELECT COUNT(SequenceId) FROM [User]"), 0);
if (cnt - 1 >= totCnt)
{
throw new Exception("Error, pls contact your IT");
}
else
{
ASPxGridView grd = sender as ASPxGridView;
ASPxTextBox pwd = grd.FindEditFormTemplateControl("txtPwd") as ASPxTextBox;
if (pwd.Text == "")
{
e.Cancel = true;
throw new Exception("Please enter the password .");
}
else
{
ASPxTextBox userId = grd.FindEditFormTemplateControl("txtCode") as ASPxTextBox;
Encryption.EncryptClass encrypt = new Encryption.EncryptClass();
e.NewValues["Pwd"] = encrypt.DESEnCode(userId.Text, pwd.Text);
}
e.NewValues["IsActive"] = true;
}
}
private Dictionary <string, object> ExtractValuesFromEditForm(ASPxGridView grid)
{
Dictionary <string, object> pairs = new Dictionary <string, object>();
// EmployeeID
pairs.Add("EmployeeID", null);
string employeeIDStr = ((ASPxLabel)grid.FindEditFormTemplateControl("lblEmployeeID")).Text;
if (!string.IsNullOrEmpty(employeeIDStr))
{
pairs["EmployeeID"] = Int32.Parse(employeeIDStr);
}
// PageControl
ASPxPageControl pageControl = (ASPxPageControl)grid.FindEditFormTemplateControl("pgcEditForm");
/// First page
TabPage firstPage = pageControl.TabPages[0];
pairs.Add("FirstName", ((ASPxTextBox)firstPage.FindControl("tbFirstName")).Text);
pairs.Add("LastName", ((ASPxTextBox)firstPage.FindControl("tbLastName")).Text);
pairs.Add("BirthDate", ((ASPxDateEdit)firstPage.FindControl("deBirthDate")).Date);
/// Second page
TabPage secondPage = pageControl.TabPages[1];
pairs.Add("City", ((ASPxTextBox)secondPage.FindControl("tbCity")).Text);
pairs.Add("Country", ((ASPxTextBox)secondPage.FindControl("tbCountry")).Text);
/// Third page
pairs.Add("Notes", ((ASPxMemo)pageControl.TabPages[2].FindControl("txtNotes")).Text);
/// Fourth page
TabPage fourthPage = pageControl.TabPages[3];
pairs.Add("OccupationID", ((ASPxComboBox)fourthPage.FindControl("cbOccupation")).Value);
pairs.Add("Subscriber", ((ASPxCheckBox)fourthPage.FindControl("chbSubscriber")).Checked);
return(pairs);
}
protected void gridInterviewDet_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxGridView grd = sender as ASPxGridView;
ASPxTextBox name = grd.FindEditFormTemplateControl("txt_Name") as ASPxTextBox;
if (SafeValue.SafeString(name.Text).Length < 1)
{
throw new Exception("Name not be null !!!");
return;
}
e.NewValues["Status"] = "CANDIDATE";
e.NewValues["InterviewId"] = SafeValue.SafeString(e.NewValues["InterviewId"], "");
e.NewValues["RecruitId"] = SafeValue.SafeString(e.NewValues["RecruitId"], "");
ASPxCheckBox married = grd.FindEditFormTemplateControl("ckb_Married") as ASPxCheckBox;
if (married.Checked)
{
e.NewValues["Married"] = "Y";
}
else
{
e.NewValues["Married"] = "N";
}
e.NewValues["CreateBy"] = HttpContext.Current.User.Identity.Name;
e.NewValues["CreateDateTime"] = DateTime.Now;
}
protected void GRID_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxGridView grid = (ASPxGridView)sender;
ASPxTextBox txtNombre = (ASPxTextBox)grid.FindEditFormTemplateControl("ASPxNombre");
ASPxListBox cmbMateriales = (ASPxListBox)grid.FindEditFormTemplateControl("ASPxListBox");
MATERIAL newKit = new MATERIAL();
newKit.M_NOMBRE = txtNombre.Text;
newKit.M_TIPO = "Kit";
newKit.M_MEDIDA_COMPRA = 1;
newKit.M_MEDIDA_DISTRIBUCION = 1;
newKit.M_STOCK_BAJO = 1;
newKit.M_STOCK_IDEAL = 100;
newKit.M_STOCK_REAL = 0;
CRUD_Material.Create(newKit);
int kit_id = CRUD_Material.Read(newKit.M_NOMBRE);
foreach (ListEditItem item in cmbMateriales.Items)
{
MATERIAL_KIT mat = new MATERIAL_KIT();
mat.M_ID = kit_id;
mat.MAT_M_ID = CRUD_Material.Read(item.Value.ToString());
mat.MK_CANTIDAD = 1;
CRUD_Kit.Create(mat);
}
e.Cancel = true;
grid.CancelEdit();
}
protected void grid_Event_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxGridView g = this.grid_Transport;
ASPxGridView gEvent = g.FindEditFormTemplateControl("grid_Event") as ASPxGridView;
ASPxDropDownEdit contNo = gEvent.FindEditFormTemplateControl("DropDownEdit") as ASPxDropDownEdit;
ASPxComboBox contType = gEvent.FindEditFormTemplateControl("cmb_ContainerType") as ASPxComboBox;
if (checkCont_NO_Type(contNo.Text, contType.Text))
{
throw new Exception("Container No and Type are not match");
}
e.NewValues["EventDateTime"] = DateTime.Now;
ASPxTextBox docNo = g.FindEditFormTemplateControl("txt_DocNo") as ASPxTextBox;
e.NewValues["DocNo"] = docNo.Text;
ASPxTextBox docType = g.FindEditFormTemplateControl("txt_DocType") as ASPxTextBox;
e.NewValues["DocType"] = docType.Text;
ASPxTextBox jobNo = g.FindEditFormTemplateControl("txt_JobNo") as ASPxTextBox;
e.NewValues["JobNo"] = jobNo.Text;
ASPxButtonEdit shipPol = g.FindEditFormTemplateControl("btn_ShipPol") as ASPxButtonEdit;
e.NewValues["Pol"] = shipPol.Text;
ASPxButtonEdit shipPod = g.FindEditFormTemplateControl("btn_ShipPod") as ASPxButtonEdit;
e.NewValues["Pod"] = shipPod.Text;
//string Name = EzshipHelper.GetUserName();
//string Port = System.Configuration.ConfigurationManager.AppSettings["LocalPort"];
e.NewValues["EventPort"] = btn_Port.Text;
}
public void Effect_Inserting(object sender, ASPxDataInsertingEventArgs e)
{
ASPxGridView detailGridView = (ASPxGridView)sender;
ASPxGridView editform_gv = (ASPxGridView)detailGridView.FindEditFormTemplateControl("cnr").FindControl("gv1");
ASPxFormLayout fl = (ASPxFormLayout)detailGridView.FindEditFormTemplateControl("cnr").FindControl("Effect_Layout_Form");
for (int i = 0; i < editform_gv.Selection.Count; i++)
{
SqlCommand cmd;
string effect_obid = editform_gv.GetSelectedFieldValues("OBID")[i].ToString();
string detector_obid = detailGridView.GetMasterRowKeyValue().ToString();
string load_qry = "insert into TB_DE_LINK(OBID, LEFTREL, RIGHTREL, N1CREATIONDATE, N1CREATIONSESID) ";
load_qry = load_qry + "VALUES (NEWID(), '" + detector_obid + "', '" + effect_obid + "', ";
load_qry = load_qry + "REPLACE(REPLACE(CONVERT(varchar(23), GETDATE(), 121), '-','/'),' ', '-') , '" + SessionInfo.UserName + "') ";
cmd = new SqlCommand(load_qry, fgm_moduler.func_Class.conn);
cmd.ExecuteNonQuery();
}
e.Cancel = true;
Detector_Grid.CancelEdit();
//makeDetectorGridView();
//makeEffectGridView();
//Session["Dataset"] = DetectorVoting;
//Detector_Grid.DataSource = DetectorVoting;
//Detector_Grid.DataBind();
}
protected void gvw_car_no_OnRowUpdating(object sender, ASPxDataUpdatingEventArgs e)
{
ASPxGridView grid = sender as ASPxGridView;
var cbb_car_area = grid.FindEditFormTemplateControl("cbb_car_area") as DevExpress.Web.ASPxEditors.ASPxComboBox;
var txt_car_no = grid.FindEditFormTemplateControl("txt_car_no") as DevExpress.Web.ASPxEditors.ASPxTextBox;
e.NewValues["car_no"] = cbb_car_area.Text + txt_car_no.Text;
}
private LogFile CollectDataForLogFile(string Mode, DataRow LogFileRow)
{
try
{
LogFile LogFileObject = new LogFile();
ContentPlaceHolder cph = (ContentPlaceHolder)Master.FindControl("ContentPlaceHolder1");
ASPxGridView gv = (ASPxGridView)cph.FindControl("LogFileGridView");
//cph.FindControl("LogFileGridView");
ASPxTextBox txtKeyword = (ASPxTextBox)gv.FindEditFormTemplateControl("LogFileTextBox");
ASPxTextBox txtNotRequiredKeyword = (ASPxTextBox)gv.FindEditFormTemplateControl("NotLogFileTextBox");
ASPxCheckBox LogFileCheckBox = (ASPxCheckBox)gv.FindEditFormTemplateControl("LogFileCheckBox");
ASPxCheckBox logCheckBox = (ASPxCheckBox)gv.FindEditFormTemplateControl("logCheckBox");
ASPxCheckBox AgentlogCheckBox = (ASPxCheckBox)gv.FindEditFormTemplateControl("AgentlogCheckBox");
LogFileObject.Keyword = txtKeyword.Text;
LogFileObject.NotRequiredKeyword = txtNotRequiredKeyword.Text;
//LogFileRow["Keyword"].ToString();
if (LogFileCheckBox.Checked == true)
{
LogFileObject.RepeatOnce = true;
}
else
{
LogFileObject.RepeatOnce = false;
}
if (logCheckBox.Checked == true)
{
LogFileObject.Log = true;
}
else
{
LogFileObject.Log = false;
}
if (AgentlogCheckBox.Checked == true)
{
LogFileObject.AgentLog = true;
}
else
{
LogFileObject.AgentLog = false;
}
//bool.Parse(LogFileRow["RepeatOnce"].ToString());
if (Mode == "Update")
{
LogFileObject.ID = int.Parse(LogFileRow["ID"].ToString());
}
return(LogFileObject);
}
catch (Exception ex)
{
//6/27/2014 NS added for VSPLUS-634
Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex);
throw ex;
}
finally { }
}
private int GetBalQty(ASPxGridView grd)
{
ASPxButtonEdit txt_det_Product = grd.FindEditFormTemplateControl("txt_det_Product") as ASPxButtonEdit;
ASPxSpinEdit spin_det_Price = grd.FindEditFormTemplateControl("spin_det_Price") as ASPxSpinEdit;
string product = SafeValue.SafeString(txt_det_Product.Text);
decimal price = SafeValue.SafeDecimal(spin_det_Price.Value, 0);
string sql = string.Format("select (select SUM(Qty) from wh_POReceiptDet where Price={1} and Product='{0}')-isnull((select sum(Qty) from wh_SoReleaseDet where Price={1} and Product='{0}'),0)", product, price);
return(SafeValue.SafeInt(C2.Manager.ORManager.ExecuteScalar(sql), 0));
}
protected void gvUser_InitNewRow(object sender, DevExpress.Web.Data.ASPxDataInitNewRowEventArgs e)
{
ASPxGridView gridView = sender as ASPxGridView;
ASPxRadioButtonList ASPxRadioButtonList2 = gridView.FindEditFormTemplateControl("ASPxRadioButtonList2") as ASPxRadioButtonList;
ASPxRadioButtonList ASPxRadioButtonList1 = gridView.FindEditFormTemplateControl("ASPxRadioButtonList1") as ASPxRadioButtonList;
ASPxRadioButtonList1.Value = 1;
ASPxRadioButtonList1.SelectedIndex = 0;
ASPxRadioButtonList2.Value = 2;
ASPxRadioButtonList2.SelectedIndex = 0;
}
protected void grid_Event_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxGridView g = this.grid_Transport;
ASPxGridView gEvent = g.FindEditFormTemplateControl("grid_Event") as ASPxGridView;
ASPxDropDownEdit contNo = gEvent.FindEditFormTemplateControl("DropDownEdit") as ASPxDropDownEdit;
ASPxComboBox contType = gEvent.FindEditFormTemplateControl("cmb_ContainerType") as ASPxComboBox;
if (checkCont_NO_Type(contNo.Text, contType.Text))
{
throw new Exception("Container No and Type are not match");
}
}
protected void SaveJob()
{
try
{
ASPxGridView g = this.grid_Marking;
ASPxTextBox houseId = g.FindEditFormTemplateControl("txt_Id") as ASPxTextBox;
int Id = SafeValue.SafeInt(houseId.Text, 0);
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(SeaExportMkg), "SequenceId='" + Id + "'");
SeaExportMkg mkg = C2.Manager.ORManager.GetObject(query) as SeaExportMkg;
bool isNew = false;
if (Id == 0)
{
isNew = true;
mkg = new SeaExportMkg();
}
ASPxDateEdit polEta = g.FindEditFormTemplateControl("date_PolEta") as ASPxDateEdit;
mkg.PolEta = polEta.Date;
ASPxDateEdit polClearDate = g.FindEditFormTemplateControl("date_PolClearDate") as ASPxDateEdit;
mkg.PolClearDate = polClearDate.Date;
ASPxDateEdit polReturnDate = g.FindEditFormTemplateControl("date_PolReturnDate") as ASPxDateEdit;
mkg.PolReturnDate = polReturnDate.Date;
ASPxDateEdit podEta = g.FindEditFormTemplateControl("date_PodEta") as ASPxDateEdit;
mkg.PodEta = podEta.Date;
ASPxDateEdit podClearDate = g.FindEditFormTemplateControl("date_PodClearDate") as ASPxDateEdit;
mkg.PodClearDate = podClearDate.Date;
ASPxDateEdit podReturnDate = g.FindEditFormTemplateControl("date_PodReturnDate") as ASPxDateEdit;
mkg.PodReturnDate = podReturnDate.Date;
ASPxMemo polRemark = g.FindEditFormTemplateControl("memo_PolRemark") as ASPxMemo;
mkg.PolRemark = polRemark.Text;
ASPxMemo podRemark = g.FindEditFormTemplateControl("memo_PodRemark") as ASPxMemo;
mkg.PodRemark = podRemark.Text;
if (isNew)
{
C2.Manager.ORManager.StartTracking(mkg, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(mkg);
houseId.Text = mkg.SequenceId.ToString();
//this.txt_JobNo.Text = tpt1.JobNo;
Session["TptWhere"] = "SequenceId='" + mkg.SequenceId + "'";
this.dsMarking.FilterExpression = Session["TptWhere"].ToString();
if (this.grid_Marking.GetRow(0) != null)
{
this.grid_Marking.StartEdit(0);
}
}
else
{
C2.Manager.ORManager.StartTracking(mkg, Wilson.ORMapper.InitialState.Updated);
C2.Manager.ORManager.PersistChanges(mkg);
}
}
catch (Exception ex)
{ throw new Exception(ex.Message + ex.StackTrace); }
}
protected void UserProfileDataSource_Inserting(object sender, SqlDataSourceCommandEventArgs e)
{
int visibleindex = MainGridView.FocusedRowIndex;
ASPxGridView sousgrid = MainGridView.FindDetailRowTemplateControl(visibleindex, "ThemeGridSite") as ASPxGridView;
ASPxCheckBoxList listTiers = sousgrid.FindEditFormTemplateControl("chkListTiers") as ASPxCheckBoxList;
string ListTiers = "";
foreach (string val in listTiers.SelectedValues)
{
ListTiers += val + ";";
}
ASPxCheckBoxList listJour = sousgrid.FindEditFormTemplateControl("chkListJourn") as ASPxCheckBoxList;
string ListJour = "";
foreach (string val in listJour.SelectedValues)
{
ListJour += val + ";";
}
ASPxCheckBoxList listaffichmontant = sousgrid.FindEditFormTemplateControl("ASPxCheckAfficherMontant") as ASPxCheckBoxList;
string affichmontant = "0";
foreach (string val in listaffichmontant.SelectedValues)
{
affichmontant = val;
}
ASPxCheckBoxList listaccederdate = sousgrid.FindEditFormTemplateControl("ASPxCheckAccederDate") as ASPxCheckBoxList;
string accederdate = "0";
foreach (string val in listaccederdate.SelectedValues)
{
accederdate = val;
}
//ASPxCheckBoxList listDoc = sousgrid.FindEditFormTemplateControl("chkListDoc") as ASPxCheckBoxList;
//string ListDoc = "";
//foreach (string val in listDoc.SelectedValues)
//{
// ListDoc += val + ";";
//}
e.Command.Parameters[2].Value = ListJour;
e.Command.Parameters[3].Value = ListTiers;
e.Command.Parameters[5].Value = affichmontant;
e.Command.Parameters[6].Value = accederdate;
//e.Command.Parameters[4].Value = ListDoc;
}
protected void grid_Transport_CustomDataCallback(object sender, ASPxGridViewCustomDataCallbackEventArgs e)
{
if (e.Parameters.Equals("save"))
{
gridView_save(sender, e);
}
if (e.Parameters.Equals("borrow"))
{
ASPxGridView grd = (sender as ASPxGridView) as ASPxGridView;
ASPxLabel txt_Id = grd.FindEditFormTemplateControl("lb_Id") as ASPxLabel;
C2.CtmMastData data = C2.Manager.ORManager.GetObject <C2.CtmMastData>(SafeValue.SafeInt(txt_Id.Text, 0));
if (data != null)
{
C2.CtmMastDataLog.addBorrow(data);
e.Result = "success";
}
}
if (e.Parameters.Equals("return"))
{
ASPxGridView grd = (sender as ASPxGridView) as ASPxGridView;
ASPxLabel txt_Id = grd.FindEditFormTemplateControl("lb_Id") as ASPxLabel;
C2.CtmMastData data = C2.Manager.ORManager.GetObject <C2.CtmMastData>(SafeValue.SafeInt(txt_Id.Text, 0));
if (data != null)
{
C2.CtmMastDataLog.addReturn(data);
e.Result = "success";
}
}
}
protected void grid_Transport_CustomDataCallback(object sender, ASPxGridViewCustomDataCallbackEventArgs e)
{
string s = e.Parameters;
ASPxGridView g = sender as ASPxGridView;
ASPxTextBox masterId = g.FindEditFormTemplateControl("txt_Id") as ASPxTextBox;
string userId = HttpContext.Current.User.Identity.Name;
}
public DateTime controlKoniecZawieszeniafromWUC(ASPxGridView grid)
{
ASPxPageControl pageControl = grid.FindEditFormTemplateControl("ASPxPageControl1") as ASPxPageControl;
zawieszenia txt = pageControl.FindControl("zawieszenia1") as zawieszenia;
return(txt.koniec.Date);
}
protected void ASPxGridView1_RowUpdating(object sender, ASPxDataUpdatingEventArgs e)
{
ASPxGridView grid = (ASPxGridView)sender;
DataType dataType = (DataType)grid.GetRowValuesByKeyValue(e.Keys[0], "Type");
string editorID = string.Empty;
switch (dataType)
{
case DataType.Text:
editorID = "txt";
break;
case DataType.DateTime:
editorID = "date";
break;
case DataType.Dictionary1:
editorID = "dict";
break;
case DataType.Dictionary2:
editorID = "dict";
break;
}
ASPxEdit editor = (ASPxEdit)grid.FindEditFormTemplateControl(editorID);
e.NewValues["DataValue"] = editor.Value.ToString();
}
protected void ASPxGridView1_CustomDataCallback1(object sender, ASPxGridViewCustomDataCallbackEventArgs e)
{
string s = e.Parameters;
if (s == "Delete")
{
ASPxGridView grd = sender as ASPxGridView;
ASPxTextBox oid = grd.FindEditFormTemplateControl("txt_Oid") as ASPxTextBox;
string sql = string.Format("Delete from XAGlEntryDet where GlNo='{0}'", oid.Text);
int res = Manager.ORManager.ExecuteCommand(sql);
if (res > -1)
{
sql = string.Format("Delete from XAGlEntry where SequenceId='{0}'", oid.Text);
res = Manager.ORManager.ExecuteCommand(sql);
if (res > -1)
{
e.Result = "CS";//cancel success
}
else
{
e.Result = "CF";
}
}
else
{
}
}
}
protected void grid_ref_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
string refN = e.Parameters;
ASPxGridView grd = sender as ASPxGridView;
if (refN == "Photo")
{
if (this.dsJobPhoto.FilterExpression == "1=0")
{
ASPxPageControl pageControl = grd.FindEditFormTemplateControl("pageControl") as ASPxPageControl;
ASPxTextBox refNo = pageControl.FindControl("txt_RefN") as ASPxTextBox;
this.dsJobPhoto.FilterExpression = "JobClass='E' and RefNo='" + refNo.Text + "'";//
}
}
else if (refN == "Save")
{
Save();
}
else if (refN == "Delete")
{
// ASPxCheckBox cb_de =(ASPxCheckBox)grid_ref.FindControl
//if (cb_Delete.Checked == true)
// {
// string sql = "delete from SeaAttachment where SequenceId="+SafeValue.SafeInt(txt_ID.Text,0);
// }
}
}
/// <summary>
/// GridView的直接子控件的显示情况(GridView.Column可填Caption/FieldName)
/// </summary>
/// <param name="gv"></param>
/// <param name="Status"></param>
/// <param name="where"></param>
public static void Bind_Authority(ASPxGridView gv, string Status, string where)
{
string Role = EzshipHelper.GetUseRole();
string Path = GetFrame();
string sql_part = "";
if (Status.Length > 0)
{
sql_part = " and [Status]='" + Status + "'";
}
sql_part += where;
string sql = string.Format(@"select Control,ControlType,IsHid from Helper_Authority where Frame='{0}' and Role='{1}' {2}", Path, Role, sql_part);
DataTable dt = ConnectSql.GetTab(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
string name = SafeValue.SafeString(dr["Control"]);
string type = SafeValue.SafeString(dr["ControlType"]);
string IsHid = SafeValue.SafeString(dr["IsHid"].ToString());
if (type.Equals("Column"))
{
Bind_Column(gv, name, IsHid);
}
else
{
Control c = gv.FindEditFormTemplateControl(name);
if (c != null)
{
Bind_Control(c, type, IsHid);
}
}
}
}
public bool controlCheckbox(string control, ASPxGridView grid)
{
ASPxPageControl pageControl = grid.FindEditFormTemplateControl("ASPxPageControl1") as ASPxPageControl;
ASPxCheckBox txt = pageControl.FindControl(control) as ASPxCheckBox;
return(txt.Checked);
}
public static T EditForm <T>(this ASPxGridView source, string path, string pathSeparator) where T : Control
{
var controlIds = path.Split(new[] { pathSeparator }, StringSplitOptions.RemoveEmptyEntries);
var elementsEnumerator = controlIds.GetEnumerator();
var result = source.FindEditFormTemplateControl(elementsEnumerator.FetchNext().As <string>());
if (result == null)
{
throw new ElementNotFoundException();
}
while (elementsEnumerator.MoveNext())
{
result = result.FindControl(elementsEnumerator.Current.As <string>());
if (result == null)
{
throw new ElementNotFoundException();
}
}
return((T)result);
}
protected void grid_Export_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
string s = e.Parameters;
if (s == "Photo")
{
if (this.dsJobPhoto.FilterExpression == "1=0")
{
ASPxGridView grd = sender as ASPxGridView;
ASPxPageControl pageControl = grd.FindEditFormTemplateControl("pageControl_Hbl") as ASPxPageControl;
ASPxTextBox HNo = pageControl.FindControl("txtHouseId") as ASPxTextBox;
//this.dsJobPhoto.FilterExpression = "JobClass='I' and RefNo='" + refNo.Text + "'";
string sql = "select RefNo,JobNo from air_job where Id='" + HNo.Text + "'";
DataTable tab = C2.Manager.ORManager.GetDataSet(sql).Tables[0];
if (tab.Rows.Count > 0)
{
string refNo = tab.Rows[0]["RefNo"].ToString();
string jobNo = tab.Rows[0]["JobNo"].ToString();
this.dsJobPhoto.FilterExpression = string.Format("JobType='AE' and RefNo='{0}' and JobNo='{1}'", refNo, jobNo);
}
}
}
if (s == "Save")
{
SaveJob();
}
}
protected void grid_Cost_HtmlEditFormCreated(object sender, ASPxGridViewEditFormEventArgs e)
{
ASPxGridView grd = sender as ASPxGridView;
ASPxTextBox vendorName = grd.FindEditFormTemplateControl("txt_CostVendorName") as ASPxTextBox;
vendorName.Text = EzshipHelper.GetPartyName(grd.GetRowValues(grd.EditingRowVisibleIndex, new string[] { "VendorId" }));
}
protected void grid_Transport_HtmlEditFormCreated(object sender, ASPxGridViewEditFormEventArgs e)
{
//throw new Exception("AA");
try
{
if (this.grid_Transport.EditingRowVisibleIndex > -1)
{
ASPxGridView g = this.grid_Transport;
//ASPxTextBox custName = g.FindEditFormTemplateControl("txt_Tpt_CustomerName") as ASPxTextBox;
//ASPxTextBox haulierName = g.FindEditFormTemplateControl("txt_Tpt_HaulierName") as ASPxTextBox;
//custName.Text = EzshipHelper.GetPartyName(this.grid_Transport.GetRowValues(this.grid_Transport.EditingRowVisibleIndex, new string[] { "CustomerId" }));
//haulierName.Text = EzshipHelper.GetPartyName(this.grid_Transport.GetRowValues(this.grid_Transport.EditingRowVisibleIndex, new string[] { "HaulierId" }));
string oid = SafeValue.SafeString(this.grid_Transport.GetRowValues(this.grid_Transport.EditingRowVisibleIndex, new string[] { "Id" }));
//PayTab(SafeValue.SafeInt(oid, 0));
string sql = "select isnull(StatusCode,'USE') from cont_asset where Id=" + oid;
string StatusCode = SafeValue.SafeString(C2.Manager.ORManager.ExecuteScalar(sql), "USE");
switch (StatusCode)
{
case "CLS":
ASPxButton btnCLS = g.FindEditFormTemplateControl("btn_Close") as ASPxButton;
btnCLS.Text = "Open";
break;
case "CNL":
ASPxButton btnCNL = g.FindEditFormTemplateControl("btn_Void") as ASPxButton;
btnCNL.Text = "UnVoid";
break;
default:
break;
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message + ex.StackTrace);
}
//if (Request.QueryString["JobNo"] != null)
//{
// string jobType = EzshipHelper.GetJobType("SE", Request.QueryString["JobNo"].ToString());
//}
//else
//{
// string refNo = SafeValue.SafeString(this.grid_Transport.GetRowValues(this.grid_Transport.EditingRowVisibleIndex, new string[] { "RefNo" }));
//}
}
protected void gvUser_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxGridView gridView = sender as ASPxGridView;
ASPxCallbackPanel cbPanel = gridView.FindEditFormTemplateControl("ASPxCallbackOffice") as ASPxCallbackPanel;
ASPxTextBox txtofficeid = (ASPxTextBox)cbPanel.FindControl("txtofficeid");
e.NewValues["OfficeLocID"] = txtofficeid.Value;
}
protected void grid_Event_DataSelect(object sender, EventArgs e)
{
ASPxGridView g = this.grid_Transport;
ASPxTextBox docNo = g.FindEditFormTemplateControl("txt_DocNo") as ASPxTextBox;
ASPxGridView grd = sender as ASPxGridView;
this.dsEvent.FilterExpression = "DocNo='" + SafeValue.SafeString(docNo.Text, "-1") + "'";
}
protected void BUDeptListGrid_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxGridView grid = sender as ASPxGridView;
ASPxPageControl pageControl = grid.FindEditFormTemplateControl("BUHeadPageControl") as ASPxPageControl;
ASPxDateEdit effectDate = pageControl.FindControl("EffectDate") as ASPxDateEdit;
ASPxComboBox entCode = pageControl.FindControl("EntityCode") as ASPxComboBox;
ASPxCallbackPanel callBackPanel = pageControl.FindControl("BUCallBackPanel") as ASPxCallbackPanel;
ASPxComboBox buCode = callBackPanel.FindControl("BUCode") as ASPxComboBox;
ASPxComboBox buHead = pageControl.FindControl("BUHead") as ASPxComboBox;
ASPxComboBox buHeadStatus = pageControl.FindControl("BUHeadStatus") as ASPxComboBox;
SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString());
conn.Open();
string sCtrlNum = GlobalClass.GetControl_DocNum("BU_Dept_Head", Convert.ToDateTime(effectDate.Value.ToString()));
string sLastModified = DateTime.Now.ToString();
string sbuCode = "";
if (buCode.Value != null)
{
sbuCode = buCode.Value.ToString();
}
string insert = "INSERT INTO tbl_System_BUDeptHead ([Ctrl], [EffectDate], [EntityCode], [BUDeptCode], [UserKey], [StatusKey], [LastModified]) VALUES (@Ctrl, @EffectDate, @EntityCode, @BUDeptCode, @UserKey, @StatusKey, @LastModified)";
SqlCommand cmd = new SqlCommand(insert, conn);
cmd.Parameters.AddWithValue("@Ctrl", sCtrlNum);
cmd.Parameters.AddWithValue("@EffectDate", effectDate.Value.ToString());
cmd.Parameters.AddWithValue("@EntityCode", entCode.Value.ToString());
cmd.Parameters.AddWithValue("@BUDeptCode", sbuCode.ToString());
cmd.Parameters.AddWithValue("@UserKey", buHead.Value.ToString());
cmd.Parameters.AddWithValue("@StatusKey", buHeadStatus.Value.ToString());
cmd.Parameters.AddWithValue("@LastModified", sLastModified);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
e.Cancel = true;
grid.CancelEdit();
BindUserList();
int pk_latest = 0;
string query_pk = "SELECT TOP 1 [PK] FROM tbl_System_BUDeptHead ORDER BY [PK] DESC";
SqlCommand comm = new SqlCommand(query_pk, conn);
SqlDataReader r = comm.ExecuteReader();
while (r.Read())
{
pk_latest = Convert.ToInt32(r[0].ToString());
}
conn.Close();
if (pk_latest > 0)
{
FocusThisRowGrid(grid, pk_latest);
}
}
protected void grid_bkg_HtmlEditFormCreated(object sender, ASPxGridViewEditFormEventArgs e)
{
ASPxGridView grd = sender as ASPxGridView;
if (grd.EditingRowVisibleIndex > -1)
{
string houseId = SafeValue.SafeString(grd.GetRowValues(grd.EditingRowVisibleIndex, new string[] { "SequenceId" }));
string sql = string.Format("select top(1) mkg.Sequenceid,Mkg.Qty,Mkg.PackageType,Mkg.Weight,mkg.Volume,mkg.Marking,mkg.Description from seaexportmkg mkg inner join seaexport job on mkg.RefNo=job.RefNo and mkg.JobNo=job.JobNo where job.SequenceId='{0}'", houseId);
DataTable tab = ConnectSql.GetTab(sql);
if (tab.Rows.Count == 1)
{
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;
mkgId.Text = SafeValue.SafeString(tab.Rows[0]["SequenceId"]);
wt.Value = SafeValue.SafeDecimal(tab.Rows[0]["Weight"], 0);
m3.Value = SafeValue.SafeDecimal(tab.Rows[0]["Volume"], 0);
qty.Value = SafeValue.SafeInt(tab.Rows[0]["Qty"], 0);
pkgType.Text = SafeValue.SafeString(tab.Rows[0]["PackageType"]);
mkg.Text = SafeValue.SafeString(tab.Rows[0]["Marking"]);
des.Text = SafeValue.SafeString(tab.Rows[0]["Description"]);
}
}
}
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxGridView grd = sender as ASPxGridView;
ASPxTextBox pwd = grd.FindEditFormTemplateControl("txtPwd") as ASPxTextBox;
if (pwd.Text == "")
{
//e.Cancel = true;
//throw new Exception("Please enter the password .");
}
else
{
ASPxTextBox userId = grd.FindEditFormTemplateControl("txtCode") as ASPxTextBox;
Encryption.EncryptClass encrypt = new Encryption.EncryptClass();
e.NewValues["Pwd"] = encrypt.DESEnCode(userId.Text, pwd.Text);
}
}
/// <summary>
/// Searchs for combo by FindEditFormTemplateControl and returns selected value
/// </summary>
/// <param name="grid"></param>
/// <param name="controlName"></param>
/// <returns></returns>
public static object GetEditFormComboValue(ASPxGridView grid, string controlName)
{
ASPxComboBox cbo = (ASPxComboBox)grid.FindEditFormTemplateControl(controlName);
if (cbo != null)
if (cbo.SelectedItem == null)
return null;
else
return cbo.SelectedItem.Value;
return null;
}
protected object GetValueFromControlGeneric(string idName, ASPxGridView grid, string pageControlID)
{
ASPxPageControl pageControl = grid.FindEditFormTemplateControl(pageControlID) as ASPxPageControl;
if (pageControl == null) return null;
object control = pageControl.FindControl(idName);
if (control is ASPxTextBox)
{
ASPxTextBox t = control as ASPxTextBox;
return t.Text;
}
else if (control is ASPxSpinEdit)
{
ASPxSpinEdit t = control as ASPxSpinEdit;
return t.Value;
}
else if (control is ASPxDateEdit)
{
ASPxDateEdit t = control as ASPxDateEdit;
return t.Date;
}
else if (control is ASPxComboBox)
{
ASPxComboBox t = control as ASPxComboBox;
return t.Value;
}
else if (control is ASPxMemo)
{
ASPxMemo t = control as ASPxMemo;
return t.Text;
}
else if (control is ASPxCheckBox)
{
ASPxCheckBox t = control as ASPxCheckBox;
return t.Checked;
}
else if (control is DevExpress.Web.ASPxHtmlEditor.ASPxHtmlEditor)
{
DevExpress.Web.ASPxHtmlEditor.ASPxHtmlEditor t = control as DevExpress.Web.ASPxHtmlEditor.ASPxHtmlEditor;
return t.Html;
}
return "";
}
/// <summary>
/// Legge valori di ct_stato_civile e ct_titolo dai controlli (combobox) e li
/// scrive in recPaziente
/// </summary>
/// <param name="recPaziente"></param>
/// <param name="grdSender"></param>
private void readComboBox(DALRuntime.TRecPaziente recPaziente, ASPxGridView grdSender)
{
ASPxComboBox cbxStatoCivile = (ASPxComboBox)grdSender.FindEditFormTemplateControl("cbxStatoCivile");
if (cbxStatoCivile != null && cbxStatoCivile.Value != null)
recPaziente.CtStatoCivile = Convert.ToInt32(cbxStatoCivile.Value.ToString());
ASPxComboBox cbxTitolo = (ASPxComboBox)grdSender.FindEditFormTemplateControl("cbxTitoloStudio");
if (cbxTitolo != null && cbxTitolo.Value != null)
recPaziente.CtTitolo = Convert.ToInt32(cbxTitolo.Value.ToString());
ASPxComboBox cbxSesso = (ASPxComboBox)grdSender.FindEditFormTemplateControl("cbxSesso");
if (cbxSesso != null && cbxSesso.Value != null)
recPaziente.Sesso = cbxSesso.Value.ToString();
}
