public static void AddField(OrderedDictionary newvals, ASPxGridView gv, string fldname, string ctlname, DevExpress.Web.ControlType ctype)
{
//Check to see if there is a checkbox "DoNotUpdate" and do not process if checked
ASPxCheckBox chk = (ASPxCheckBox)gv.FindEditFormLayoutItemTemplateControl(ctlname + "_DoNotUpdate");
bool processThisControl = true;
if (chk != null)
{
if (chk.Checked == true)
{
processThisControl = false;
}
}
if (processThisControl)
{
switch (ctype)
{
case DevExpress.Web.ControlType.ASPxComboBox:
ASPxComboBox cbo = (ASPxComboBox)gv.FindEditFormLayoutItemTemplateControl(ctlname);
newvals[fldname] = cbo.Value;
break;
case DevExpress.Web.ControlType.ASPxTextBox:
ASPxTextBox txt = (ASPxTextBox)gv.FindEditFormLayoutItemTemplateControl(ctlname);
newvals[fldname] = txt.Value;
break;
case DevExpress.Web.ControlType.ASPxMemo:
ASPxMemo mem = (ASPxMemo)gv.FindEditFormLayoutItemTemplateControl(ctlname);
newvals[fldname] = mem.Value;
break;
case DevExpress.Web.ControlType.ASPxCalendar:
ASPxCalendar cal = (ASPxCalendar)gv.FindEditFormLayoutItemTemplateControl(ctlname);
newvals[fldname] = cal.Value;
break;
case DevExpress.Web.ControlType.ASPxDateEdit:
ASPxDateEdit dateedit = (ASPxDateEdit)gv.FindEditFormLayoutItemTemplateControl(ctlname);
newvals[fldname] = dateedit.Value;
break;
}
}
else
{
//remove the field from the update as it is not to be updated
newvals.Remove(fldname);
}
}
public override System.Web.UI.Control Build()
{
base.Build();
ASPxMemo memo = new ASPxMemo();
memo.Width = ModuleField.Width;
memo.Height = ModuleField.Height;
memo.ValidationSettings.RequiredField.IsRequired = ModuleField.IsRequired;
memo.ValidationSettings.RequiredField.ErrorText = ModuleField.ErrorText;
memo.NullText = ModuleField.NullText;
memo.Text = ModuleField.CurrentValue == null ? ModuleField.DefaultValue == null ? null : ModuleField.DefaultValue.ToString() : ModuleField.CurrentValue.ToString();
return(memo);
}
protected override WebControl CreateEditModeControlCore()
{
if (!AllowEdit)
{
return(new LabelControl(new ASPxLabel()));
}
ASPxMemo memo = RenderHelper.CreateASPxMemo();
memo.Rows = Model.RowCount;
memo.MaxLength = MaxLength;
memo.TextChanged += MemoOnTextChanged;
return(memo);
}
protected void ASPxButton1_Click(object sender, EventArgs e)
{
int startIndex = ASPxGridView1.PageIndex * ASPxGridView1.SettingsPager.PageSize;
int endIndex = Math.Min(ASPxGridView1.VisibleRowCount, startIndex + ASPxGridView1.SettingsPager.PageSize);
for (int i = startIndex; i < endIndex; i++)
{
ASPxRadioButtonList rb = (ASPxRadioButtonList)ASPxGridView1.FindRowCellTemplateControl(i, (GridViewDataColumn)ASPxGridView1.Columns[4], string.Format("rb_{0}", i));
ASPxComboBox cmb = (ASPxComboBox)ASPxGridView1.FindRowCellTemplateControl(i, (GridViewDataColumn)ASPxGridView1.Columns[5], string.Format("cmb_{0}", i));
ASPxMemo memo = (ASPxMemo)ASPxGridView1.FindRowCellTemplateControl(i, (GridViewDataColumn)ASPxGridView1.Columns[5], string.Format("memo_{0}", i));
//SAVE DATA
}
}
protected void grid_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxTextBox txtName = grid.FindEditFormTemplateControl("txtName") as ASPxTextBox;
ASPxMemo memoGhiChu = grid.FindEditFormTemplateControl("memoGhiChu") as ASPxMemo;
int n = SqlHelper.ExecuteNonQuery(strconn, "[HRM_HinhthucKhenthuong_UI2]", -1, txtName.Text, memoGhiChu.Text, 0);
grid.CancelEdit();
e.Cancel = true;
grid.DataBind();
LoadHinhThucKhenThuong(0);
}
protected string SaveNewJob()
{
try
{
ASPxDateEdit issueDate = ASPxPopupControl1.FindControl("date_IssueDate") as ASPxDateEdit;
string issueN = "";
JobInfo job = new JobInfo();
issueN = C2Setup.GetNextNo("", "JobOrder", issueDate.Date);
job.JobDate = issueDate.Date;
job.JobStage = "Customer Inquir";
ASPxComboBox cmb_JobType = ASPxPopupControl1.FindControl("cmb_JobType") as ASPxComboBox;
job.JobType = SafeValue.SafeString(cmb_JobType.Value);
//Main Info
ASPxButtonEdit txt_CustomerId = ASPxPopupControl1.FindControl("txt_CustomerId") as ASPxButtonEdit;
job.CustomerId = txt_CustomerId.Text;
ASPxTextBox txt_CustomerName = ASPxPopupControl1.FindControl("txt_CustomerName") as ASPxTextBox;
job.CustomerName = txt_CustomerName.Text;
ASPxMemo memo_Address = ASPxPopupControl1.FindControl("memo_NewAddress") as ASPxMemo;
job.CustomerAdd = memo_Address.Text;
ASPxTextBox txt_PostalCode = ASPxPopupControl1.FindControl("txt_NewPostalCode") as ASPxTextBox;
job.Postalcode = txt_PostalCode.Text;
ASPxTextBox txt_Contact = ASPxPopupControl1.FindControl("txt_NewContact") as ASPxTextBox;
job.Contact = txt_Contact.Text;
ASPxTextBox txt_Tel = ASPxPopupControl1.FindControl("txt_NewTel") as ASPxTextBox;
job.Tel = txt_Tel.Text;
ASPxTextBox txt_Email = ASPxPopupControl1.FindControl("txt_NewEmail") as ASPxTextBox;
job.Email = txt_Email.Text;
ASPxTextBox txt_Fax = ASPxPopupControl1.FindControl("txt_NewFax") as ASPxTextBox;
job.Fax = txt_Fax.Text;
ASPxMemo remark = ASPxPopupControl1.FindControl("txt_NewRemark") as ASPxMemo;
job.Remark = remark.Text;
job.WorkStatus = "PENDING";
string userId = HttpContext.Current.User.Identity.Name;
job.CreateBy = userId;
job.CreateDateTime = DateTime.Now;
job.UpdateBy = userId;
job.UpdateDateTime = DateTime.Now;
job.JobNo = issueN;
Manager.ORManager.StartTracking(job, Wilson.ORMapper.InitialState.Inserted);
Manager.ORManager.PersistChanges(job);
C2Setup.SetNextNo("", "JobOrder", issueN, issueDate.Date);
return(job.JobNo);
}
catch { }
return("");
}
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxTextBox rmesid = ASPxGridView1.FindEditFormTemplateControl("txtRmesid") as ASPxTextBox;
ASPxTextBox plancode = ASPxGridView1.FindEditFormTemplateControl("txtPlanCode") as ASPxTextBox;
ASPxTextBox planseq = ASPxGridView1.FindEditFormTemplateControl("txtPlanSeq") as ASPxTextBox;
ASPxTextBox planso = ASPxGridView1.FindEditFormTemplateControl("txtPlanSO") as ASPxTextBox;
ASPxTextBox planseries = ASPxGridView1.FindEditFormTemplateControl("productSeries") as ASPxTextBox;
ASPxTextBox qty = ASPxGridView1.FindEditFormTemplateControl("ASPxplanqty") as ASPxTextBox;
ASPxTextBox customer = ASPxGridView1.FindEditFormTemplateControl("ASPxCustomer") as ASPxTextBox;
ASPxComboBox across = ASPxGridView1.FindEditFormTemplateControl("ASPxComboBoxAcross1") as ASPxComboBox;
ASPxMemo remark = ASPxGridView1.FindEditFormTemplateControl("txtRemark") as ASPxMemo;
ASPxComboBox PlineCode = ASPxGridView1.FindEditFormTemplateControl("PlineCombo") as ASPxComboBox;
ASPxComboBox RSite = ASPxGridView1.FindEditFormTemplateControl("RountingsiteCombo") as ASPxComboBox;
ASPxDateEdit begindate1 = ASPxGridView1.FindEditFormTemplateControl("ASPxDateBegin") as ASPxDateEdit;
ASPxDateEdit enddate1 = ASPxGridView1.FindEditFormTemplateControl("ASPxDateEnd") as ASPxDateEdit;
DateTime beginDate = begindate1.Date;
DateTime endDate = enddate1.Date;
userManager theUserManager = (userManager)Session["theUserManager"];
string gylx1;
string accountdate1;
string ROUNTING_CODE1 = across.Value.ToString(); //工艺路线代码，默认为
//调用函数判断计划代码是否符合规范
string sqlPlan = "select func_check_plan('B','" + plancode.Text.Trim() + "','" + PlineCode.SelectedItem.Value + "','" + RSite.SelectedItem.Value + "','" + planso.Text.Trim() + "') from dual";
dc.setTheSql(sqlPlan);
string getvalue1 = dc.GetValue();
char[] charSeparators1 = new char[] { '#' };
string[] collection1 = getvalue1.Split(charSeparators1);
if (collection1[0] != "OK")
{
return;
}
else
{
accountdate1 = collection1[1];
gylx1 = collection1[2];
}
PlanFactory.PL_CREATE_PLAN("MODIFY", theCompanyCode, PlineCode.SelectedItem.Value.ToString(), PlineCode.SelectedItem.Text, planseq.Text.Trim(), plancode.Text.Trim(), planso.Text.Trim(), planseries.Text.Trim(), "B", theUserId, theUserManager.getUserName(), beginDate.ToString("yyyy-MM-dd"), endDate.ToString("yyyy-MM-dd"), accountdate1, qty.Text.Trim(), "0", "0", RSite.SelectedItem.Value.ToString(), gylx1, customer.Text.Trim(), remark.Text.Trim(), ROUNTING_CODE1, "Y");
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();
}
private void gridView_save(object sender, ASPxGridViewCustomDataCallbackEventArgs e)
{
ASPxGridView grd = (sender as ASPxGridView) as ASPxGridView;
ASPxLabel txt_Id = grd.FindEditFormTemplateControl("lb_Id") as ASPxLabel;
ASPxTextBox txt_Code = grd.FindEditFormTemplateControl("txt_Code") as ASPxTextBox;
ASPxTextBox txt_Size = grd.FindEditFormTemplateControl("txt_Size") as ASPxTextBox;
ASPxComboBox cbb_Status = grd.FindEditFormTemplateControl("cbb_Status") as ASPxComboBox;
ASPxComboBox cbb_self = grd.FindEditFormTemplateControl("cbb_self") as ASPxComboBox;
ASPxTextBox txt_finance = grd.FindEditFormTemplateControl("txt_finance") as ASPxTextBox;
ASPxMemo txt_Remark = grd.FindEditFormTemplateControl("txt_Remark") as ASPxMemo;
ASPxDateEdit ASPxDateEdit1 = grd.FindEditFormTemplateControl("ASPxDateEdit1") as ASPxDateEdit;
ASPxDateEdit ASPxDateEdit2 = grd.FindEditFormTemplateControl("ASPxDateEdit2") as ASPxDateEdit;
ASPxDateEdit ASPxDateEdit3 = grd.FindEditFormTemplateControl("ASPxDateEdit3") as ASPxDateEdit;
ASPxDateEdit ASPxDateEdit4 = grd.FindEditFormTemplateControl("ASPxDateEdit4") as ASPxDateEdit;
ASPxDateEdit ASPxDateEdit5 = grd.FindEditFormTemplateControl("ASPxDateEdit5") as ASPxDateEdit;
C2.CtmMastData data = C2.Manager.ORManager.GetObject <C2.CtmMastData>(SafeValue.SafeInt(txt_Id.Text, 0));
bool isNew = false;
if (data == null)
{
data = new C2.CtmMastData();
data.Type = "chessis";
isNew = true;
}
data.Code = txt_Code.Text;
data.Name = data.Code;
data.Remark = txt_Size.Text;
data.Type1 = (SafeValue.SafeString(cbb_Status.Text) == "InActive" ? "InActive" : "Active");
data.Note2 = (SafeValue.SafeString(cbb_self.Text) == "N" ? "N" : "Y");
data.Note3 = txt_finance.Text;
data.Note1 = txt_Remark.Text;
data.Date1 = SafeValue.SafeDate(ASPxDateEdit1.Date, DateTime.Now);
data.Date2 = SafeValue.SafeDate(ASPxDateEdit2.Date, DateTime.Now);
data.Date3 = SafeValue.SafeDate(ASPxDateEdit3.Date, DateTime.Now);
data.Date4 = SafeValue.SafeDate(ASPxDateEdit4.Date, DateTime.Now);
data.Date5 = SafeValue.SafeDate(ASPxDateEdit5.Date, DateTime.Now);
if (isNew)
{
C2.Manager.ORManager.StartTracking(data, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(data);
}
else
{
C2.Manager.ORManager.StartTracking(data, Wilson.ORMapper.InitialState.Updated);
C2.Manager.ORManager.PersistChanges(data);
}
e.Result = "success";
}
protected void clbPanel_Callback(object sender, DevExpress.Web.ASPxClasses.CallbackEventArgsBase e)
{
int index = Convert.ToInt32(e.Parameter);
int id = Convert.ToInt32(Grid.GetRowValues(index, "ID"));
ASPxMemo memo = (sender as ASPxCallbackPanel).FindControl("C3_memo") as ASPxMemo;
if (id % 2 == 0)
{
memo.MaxLength = 4;
}
else
{
memo.MaxLength = 10;
}
}
private void Update_Inline(DevExpress.Web.ASPxGridView.ASPxGridViewCustomDataCallbackEventArgs e, int rowIndex)
{
if (rowIndex < 0)
{
e.Result = "Save Error";
return;
}
TextBox txt_tripId = this.grid_Transport.FindRowCellTemplateControl(rowIndex, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid_Transport.Columns["tripDetail"], "txt_tripId") as TextBox;
ASPxButtonEdit btn_Driver = this.grid_Transport.FindRowCellTemplateControl(rowIndex, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid_Transport.Columns["tripDetail"], "btn_Driver") as ASPxButtonEdit;
ASPxButtonEdit txt_trailer = this.grid_Transport.FindRowCellTemplateControl(rowIndex, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid_Transport.Columns["tripDetail"], "txt_trailer") as ASPxButtonEdit;
ASPxButtonEdit txt_parkingLot = this.grid_Transport.FindRowCellTemplateControl(rowIndex, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid_Transport.Columns["tripDetail"], "txt_parkingLot") as ASPxButtonEdit;
ASPxMemo txt_toAddress = this.grid_Transport.FindRowCellTemplateControl(rowIndex, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid_Transport.Columns["tripDetail"], "txt_toAddress") as ASPxMemo;
string sql = string.Format(@"select DriverCode from ctm_jobdet2 where Id=@Id");
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@Id", txt_tripId.Text, SqlDbType.Int));
string Driver_old = ConnectSql_mb.ExecuteScalar(sql, list).context;
string re = HttpContext.Current.User.Identity.Name + "," + txt_tripId.Text + "," + btn_Driver.Text;
if (!btn_Driver.Text.Equals(Driver_old))
{
re += "," + Driver_old;
}
sql = string.Format(@"update ctm_jobdet2 set
ToParkingLot=@ToParkingLot,ToCode=@ToCode,DriverCode=@DriverCode,ChessisCode=@ChessisCode
where Id=@Id");
list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@Id", txt_tripId.Text, SqlDbType.Int));
list.Add(new ConnectSql_mb.cmdParameters("@ToParkingLot", txt_parkingLot.Text, SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@ToCode", txt_toAddress.Text, SqlDbType.NVarChar, 300));
list.Add(new ConnectSql_mb.cmdParameters("@DriverCode", btn_Driver.Text, SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@ChessisCode", txt_trailer.Text, SqlDbType.NVarChar, 100));
ConnectSql_mb.sqlResult res = ConnectSql_mb.ExecuteNonQuery(sql, list);
if (res.status)
{
e.Result = "success:" + re;
}
else
{
e.Result = "Save Error:" + res.context;
}
//e.Result = txt_tripId.Text;
}
protected void ASPxGridView1_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
ASPxPageControl tabs = (ASPxPageControl)ASPxGridView1.FindEditFormTemplateControl("pageControl");
if (tabs != null)
{
ASPxFormLayout form = (ASPxFormLayout)tabs.FindControl("formLayoutUbicacion");
/* PROVINCIA */
ASPxComboBox comboProvincia = (ASPxComboBox)form.FindControl("cmbProvincia");
/* CANTON */
ASPxComboBox comboCanton = (ASPxComboBox)form.FindControl("cmbCanton");
/* DISTRITO */
ASPxComboBox comboDistrito = (ASPxComboBox)form.FindControl("cmbDistrito");
/* BARRIO */
ASPxComboBox comboBarrio = (ASPxComboBox)form.FindControl("cmbBarrio");
ASPxMemo otraSena = (ASPxMemo)form.FindControl("txtOtraSenas");
ASPxComboBox combPlan = (ASPxComboBox)form.FindControl("cmbPlan");
if (comboProvincia.Value == null || comboCanton.Value == null || comboDistrito.Value == null || comboBarrio.Value == null || string.IsNullOrWhiteSpace(otraSena.Text))
{
e.RowError = "La ubicación es obligatoria (provincia, cantón, distrito, barrio y otras señas";
}
if (string.IsNullOrWhiteSpace(combPlan.Text))
{
e.RowError = "Debe seleccionar un plan";
}
}
if (e.NewValues["correoElectronico"] != null)
{
Regex validator = new Regex(@"\s*\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*\s*");
string[] correos = e.NewValues["correoElectronico"].ToString().Split(',');
foreach (var correo in correos)
{
if (!validator.IsMatch(correo))
{
AddError(e.Errors, this.ASPxGridView1.Columns["correoElectronico"], string.Format("Verificar formato: {0}", correo));
}
}
if (correos.Length > 5)
{
e.RowError = "Solo puede agregar un máximo de 5 correos";
}
}
}
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);
}
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 grid_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxGridView grid = sender as ASPxGridView;
ASPxMemo textBox = FindPageControl(grid).FindControl("txtNoidung") as ASPxMemo;
ASPxComboBox nhomvk = FindPageControl(grid).FindControl("cbNhomvk") as ASPxComboBox;
e.NewValues["NOIDUNG"] = textBox.Text;
e.NewValues["MANHOM"] = nhomvk.SelectedItem.Value;
//e.Cancel = !SaveFileBytesToRow(grid, e.NewValues);
if (Session["data"] != null)
{
e.NewValues["HINHANH"] = (string)Session["data"];//uploader.FileBytes;
Session.Remove("data");
}
}
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()));
}
protected void grd_DSRole_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
try
{
e.Cancel = true;
Int32 idRoles = Convert.ToInt32(e.Keys[grd_DSRole.KeyFieldName]);
ASPxFormLayout pnLayData = grd_DSRole.FindEditFormTemplateControl("LayOutThemSua") as ASPxFormLayout;
ASPxMemo txtNote = pnLayData.FindControl("txtNote") as ASPxMemo;
ASPxTextBox txtName = pnLayData.FindControl("txtName") as ASPxTextBox;
ctlRole.updateRoles(idRoles, txtName.Text, txtNote.Text);
BindataThemNhanh();
Utils.notifierGrid(grd_DSRole, Constant.NOTIFY_SUCCESS, "Bạn đã cập nhập thành công cho Role có ID [" + idRoles.ToString() + "]");
}
catch (Exception ex)
{
Utils.notifierGrid(grd_DSRole, Constant.NOTIFY_FAILURE, ex.Message + " " + ex.StackTrace);
}
}
protected override void AssignControllerValues()
{
ASPxTextBox tbField1 = (ASPxTextBox)FindControlByID("tbField1");
ASPxMemo memField2 = (ASPxMemo)FindControlByID("memField2");
if (string.IsNullOrEmpty(tbField1.Text))
{
Controller.Field1 = null;
}
else
{
Controller.Field1 = Convert.ToDouble(tbField1.Text);
}
Controller.Field2 = memField2.Text;
base.AssignControllerValues();
}
// 主表修改
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxTextBox srlno = 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();
if (lkpMntType.Value != null)
{
mntType = lkpMntType.Value.ToString();
}
string upSql = "UPDATE DATA_ASSET_MAINTAIN SET maint_type='" + mntType + "',maint_item='" + mntItem + "',maint_service_unit='" + txtSrvUnit.Text + "'," +
"maint_service_person='" + txtSrvPerson.Text + "',maint_result='" + txtMntResult.Text + "',maint_cost=" + txtMntCost.Text + "," +
"maint_start_date=to_date('" + calMntStartDate.Value.ToString() + "','yyyy-mm-dd hh24:mi:ss'),maint_end_date=to_date('" +
calMntEndDate.Value.ToString() + "','yyyy-mm-dd hh24:mi:ss'),maint_remark='" + mntRemark.Text + "',FAULT_SCRIPT='" + faultScript.Text +
"' WHERE COMPANY_CODE = '" + theCompanyCode + "' AND SERIAL_NUMBER='" + srlno.Text + "'";
theDc.ExeSql(upSql);
e.Cancel = true;
ASPxGridView1.CancelEdit();
queryFunction();
}
protected void gvDetalleMov_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
var monto = HfMonto["value"];
ASPxTextBox montoMov = null;
ASPxMemo comentario = null;
foreach (GridViewColumn column in gvDetalleMov.Columns)
{
GridViewDataColumn dataColumn = column as GridViewDataColumn;
if (dataColumn == null)
{
continue;
}
if (dataColumn.FieldName != "MontoMovimiento" && dataColumn.FieldName != "Comentario" && dataColumn.FieldName != "Saldo" && dataColumn.FieldName != "" && dataColumn.FieldName != "IdOperacion" && dataColumn.FieldName != "IdAdministracionFondos")
{
if (e.NewValues[dataColumn.FieldName] == null)
{
e.Errors[dataColumn] = "Valor no puede estar vacío.";
}
}
else
{
montoMov = (gvDetalleMov.FindEditRowCellTemplateControl(gvDetalleMov.Columns["MontoMovimiento"] as GridViewDataColumn, "txtMontoMovimiento") as ASPxTextBox);
comentario = (gvDetalleMov.FindEditRowCellTemplateControl(gvDetalleMov.Columns["Comentario"] as GridViewDataColumn, "txtComentario") as ASPxMemo);
}
}
if (e.Errors.Count > 0 || string.IsNullOrEmpty(montoMov.Text))
{
e.RowError = "Por favor, complete los datos.";
}
if (e.NewValues["MontoMovimiento"] != null && e.NewValues["MontoMovimiento"].ToString() != "0")
{
AddError(e.Errors, gvDetalleMov.Columns["MontoMovimiento"], "Monto de movimiento debe ser mayor a cero.");
}
else
{
//validar que el monto del movimiento no sea mayor que el monto del certificado
//double montoCertificado = util.GetValorDouble(monto.ToString());
//if (Convert.ToDouble(e.NewValues["MontoMovimiento"]) > montoCertificado)
// AddError(e.Errors, gvDetalleMov.Columns["MontoMovimiento"], "Monto de movimiento debe ser menor o igual al monto disponible en el certificado");
}
}
protected void grid_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
//e.NewValues["PartyName"] = SafeValue.SafeString(e.NewValues["PartyName"]);
//e.NewValues["TransportName"] = SafeValue.SafeString(e.NewValues["TransportName"]);
//e.NewValues["TransportStatus"] = SafeValue.SafeString(e.NewValues["TransportStatus"]);
//e.NewValues["DriverName"] = SafeValue.SafeString(e.NewValues["DriverName"]);
//e.NewValues["DriverIC"] = SafeValue.SafeString(e.NewValues["DriverIC"]);
//e.NewValues["DriverTel"] = SafeValue.SafeString(e.NewValues["DriverTel"]);
//e.NewValues["TptJobNo"] = SafeValue.SafeString(e.NewValues["TptJobNo"]);
//e.NewValues["TransportStart"] = SafeValue.SafeDate(e.NewValues["TransportStart"],DateTime.Today);
//e.NewValues["Remarks"] = SafeValue.SafeString(e.NewValues["Remarks"]);
string userId = HttpContext.Current.User.Identity.Name;
ASPxTextBox txt_Id = grid.FindEditRowCellTemplateControl(null, "txt_Id") as ASPxTextBox;
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(WhDo), "Id='" + txt_Id.Text + "'");
WhDo whDo = C2.Manager.ORManager.GetObject(query) as WhDo;
ASPxComboBox txt_TransportStatus = grid.FindEditRowCellTemplateControl(null, "txt_TransportStatus") as ASPxComboBox;
ASPxTextBox txt_DriveName = grid.FindEditRowCellTemplateControl(null, "txt_DriveName") as ASPxTextBox;
ASPxTextBox txt_DriverIC = grid.FindEditRowCellTemplateControl(null, "txt_DriverIC") as ASPxTextBox;
ASPxTextBox txt_DriverTel = grid.FindEditRowCellTemplateControl(null, "txt_DriverTel") as ASPxTextBox;
ASPxTextBox txt_VechicleNo = grid.FindEditRowCellTemplateControl(null, "txt_VechicleNo") as ASPxTextBox;
ASPxTextBox txt_TptJobNo = grid.FindEditRowCellTemplateControl(null, "txt_TptJobNo") as ASPxTextBox;
ASPxDateEdit date_TransportStart = grid.FindEditRowCellTemplateControl(null, "date_TransportStart") as ASPxDateEdit;
ASPxMemo meno_Remark = grid.FindEditRowCellTemplateControl(null, "meno_Remark") as ASPxMemo;
whDo.TransportStatus = SafeValue.SafeString(txt_TransportStatus.Text);
whDo.DriverName = SafeValue.SafeString(txt_DriveName.Text);
whDo.DriverIC = SafeValue.SafeString(txt_DriverIC.Text);
whDo.DriverTel = SafeValue.SafeString(txt_DriverTel.Text);
whDo.VehicleNo = SafeValue.SafeString(txt_VechicleNo.Text);
whDo.TptJobNo = SafeValue.SafeString(txt_TptJobNo.Text);
whDo.TransportStart = SafeValue.SafeDate(txt_TransportStatus.Text, DateTime.Today);
whDo.Remarks = SafeValue.SafeString(meno_Remark.Text);
whDo.UpdateBy = userId;
whDo.UpdateDateTime = DateTime.Now;
Manager.ORManager.StartTracking(whDo, Wilson.ORMapper.InitialState.Updated);
Manager.ORManager.PersistChanges(whDo);
btn_search_Click(null, null);
}
private void Unitchange(string para)
{
int IDProduct = Convert.ToInt32(para);
//sL
ASPxSpinEdit SpinEdit = gridImportPro.FindRowCellTemplateControlByKey(IDProduct, (GridViewDataColumn)gridImportPro.Columns["Số lượng"], "spUnitReturn") as ASPxSpinEdit;
int TonKhoThucTeNew = Convert.ToInt32(SpinEdit.Number);
// nguyên nhân kiểm kho
ASPxMemo DienGiai = gridImportPro.FindRowCellTemplateControlByKey(IDProduct, (GridViewDataColumn)gridImportPro.Columns["Diễn giải"], "memoDienGiai") as ASPxMemo;
string memoDienGiai = DienGiai.Text;
// cập nhật
var sourceRow = listReceiptProducts.Where(x => x.STT == IDProduct).SingleOrDefault();
sourceRow.TonKhoThucTe = TonKhoThucTeNew;
sourceRow.ChenhLech = sourceRow.TonKhoThucTe - sourceRow.TonKhoHeThong;
sourceRow.DienGiai = memoDienGiai;
sourceRow.TrangThai = 1;
}
protected void grid_bkg_RowInserted(object sender, DevExpress.Web.Data.ASPxDataInsertedEventArgs e)
{
ASPxGridView grd = sender as ASPxGridView;
ASPxPageControl pageControl = this.grid_ref.FindEditFormTemplateControl("pageControl") as ASPxPageControl;
ASPxTextBox refNo = pageControl.FindControl("txt_RefN") as ASPxTextBox;
//ASPxTextBox jobNo = grd.FindEditFormTemplateControl("txtHouseNo") as ASPxTextBox;
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;
C2Setup.SetNextNo("ExportBooking", SafeValue.SafeString(e.NewValues["BkgRefNo"]));
C2.SeaExportMkg expMkg = new C2.SeaExportMkg();
expMkg.RefNo = refNo.Text;
expMkg.JobNo = SafeValue.SafeString(e.NewValues["JobNo"]);
expMkg.Qty = SafeValue.SafeInt(qty.Value, 0);
expMkg.PackageType = pkgType.Text;
expMkg.Volume = SafeValue.SafeDecimal(m3.Value, 0);
expMkg.Weight = SafeValue.SafeDecimal(wt.Value, 0);
expMkg.Description = des.Text;
expMkg.Marking = mkg.Text;
expMkg.MkgType = "BL";
expMkg.ContainerNo = "";
expMkg.SealNo = "";
expMkg.ContainerType = "";
expMkg.CreateBy = EzshipHelper.GetUserName();
expMkg.CreateDateTime = DateTime.Now;
expMkg.GrossWt = 0;
expMkg.NetWt = 0;
expMkg.UpdateBy = EzshipHelper.GetUserName();
expMkg.UpdateDateTime = DateTime.Now;
C2.Manager.ORManager.StartTracking(expMkg, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(expMkg);
}
private void OnLoad()
{
int start = 0; // this.ASPxGridView1.PageIndex * ASPxGridView1.SettingsPager.PageSize;
int end = 1000; // (ASPxGridView1.PageIndex + 1) * ASPxGridView1.SettingsPager.PageSize;
for (int i = start; i < end; i++)
{
ASPxCheckBox isPay = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Id"], "ack_IsPay") as ASPxCheckBox;
ASPxLabel Id = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Id"], "lbl_Id") as ASPxLabel;
ASPxLabel JobNo = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["JobNo"], "lbl_JobNo") as ASPxLabel;
ASPxComboBox txt_ContNo = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["ContainerNo"], "cbbContainer") as ASPxComboBox;
ASPxLabel lbl_ContIndex = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["ContainerNo"], "lbl_ContIndex") as ASPxLabel;
ASPxDateEdit date_ScheduleDate = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["ScheduleDate"], "date_ScheduleDate") as ASPxDateEdit;
ASPxTextBox txt_SealNo = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["SealNo"], "txt_SealNo") as ASPxTextBox;
ASPxComboBox cbbContType = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["ContainerType"], "cbbContType") as ASPxComboBox;
ASPxDateEdit date_CustomsClearDate = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["CustomsClearDate"], "date_CustomsClearDate") as ASPxDateEdit;
ASPxComboBox cmb_CustomsClearStatus = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["CustomsClearStatus"], "cmb_CustomsClearStatus") as ASPxComboBox;
ASPxComboBox cmb_CustomsVerifyInd = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["CustomsVerifyInd"], "cmb_CustomsVerifyInd") as ASPxComboBox;
ASPxDateEdit date_CustomsVerifyDate = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["CustomsVerifyDate"], "date_CustomsVerifyDate") as ASPxDateEdit;
ASPxMemo memo_CustomsRemark = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["CustomsRemark"], "memo_CustomsRemark") as ASPxMemo;
ASPxDateEdit date_ValiDate = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["ValiDate"], "date_ValiDate") as ASPxDateEdit;
ASPxDateEdit date_ScheduleStartDate = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["ScheduleStartDate"], "date_ScheduleStartDate") as ASPxDateEdit;
ASPxDateEdit date_BillingDate = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["BillingDate"], "date_BillingDate") as ASPxDateEdit;
ASPxDateEdit date_DispatchDate = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["DispatchDate"], "date_DispatchDate") as ASPxDateEdit;
ASPxDateEdit date_EtaDate = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["EtaDate"], "date_EtaDate") as ASPxDateEdit;
if (Id != null)
{
list.Add(new Record(SafeValue.SafeInt(Id.Text, 0), JobNo.Text, txt_ContNo.Text, date_ScheduleDate.Date, txt_SealNo.Text, SafeValue.SafeString(cbbContType.Value),
SafeValue.SafeString(cmb_CustomsClearStatus.Value), date_CustomsClearDate.Date, SafeValue.SafeString(cmb_CustomsVerifyInd.Value),
date_CustomsVerifyDate.Date, memo_CustomsRemark.Text, lbl_ContIndex.Text, date_ValiDate.Date, date_ScheduleStartDate.Date, date_ValiDate.Date, date_DispatchDate.Date, date_EtaDate.Date));
insert_container(txt_ContNo.Text, SafeValue.SafeString(cbbContType.Value));
}
else
{
if (Id == null)
{
break;
}
}
}
}
protected string ObtenerValorTxt(string strComponente, int intTipoComponente)
{
string strValor = string.Empty;
try
{
//ASPxPageControl pageControl = grvDatosEmpleado.FindEmptyDataRowTemplateControl("pageControl") as ASPxPageControl;
switch (intTipoComponente)
{
case (int)EnumTipoComponente.TextBox: // textbox
ASPxTextBox txtTmp = grvDatosEmpleado.FindEditFormTemplateControl(strComponente) as ASPxTextBox;
strValor = txtTmp.Text;
break;
case (int)EnumTipoComponente.Memo: // Memo
ASPxMemo memTmp = grvDatosEmpleado.FindEditFormTemplateControl(strComponente) as ASPxMemo;
strValor = memTmp.Text;
break;
case (int)EnumTipoComponente.ComboBox: // Combo
ASPxComboBox cboTmp = grvDatosEmpleado.FindEditFormTemplateControl(strComponente) as ASPxComboBox;
strValor = cboTmp.Text;
break;
case (int)EnumTipoComponente.DateEdit: // Datetime
ASPxDateEdit dteTmp = grvDatosEmpleado.FindEditFormTemplateControl(strComponente) as ASPxDateEdit;
strValor = dteTmp.Text.ToString();
break;
case (int)EnumTipoComponente.SpinEdit: // SpinEdit
ASPxSpinEdit speTmp = grvDatosEmpleado.FindEditFormTemplateControl(strComponente) as ASPxSpinEdit;
strValor = speTmp.Text;
break;
}
}
catch (Exception)
{
throw;
}
return(strValor);
}
protected override void AssignControllerValues()
{
base.AssignControllerValues();
ASPxTextBox tbSubject = (ASPxTextBox)FindControlByID("ASPxTextBoxSubject");
ASPxDateEdit deStart = (ASPxDateEdit)FindControlByID("ASPxDateEditStart");
ASPxDateEdit deEnd = (ASPxDateEdit)FindControlByID("ASPxDateEditEnd");
ASPxMemo tbDescription = (ASPxMemo)FindControlByID("ASPxTextBoxDescription");
ASPxTextBox tbCustomInfo = (ASPxTextBox)FindControlByID("ASPxTextBoxCustomInfo");
Controller.Subject = tbSubject.Text;
Controller.Start = Convert.ToDateTime(deStart.Value);
Controller.End = Convert.ToDateTime(deEnd.Value);
Controller.Description = tbDescription.Text;
Controller.CustomInfoField = tbCustomInfo.Text;
if (Controller.ResourceId == ResourceEmpty.Id)
{
Controller.ResourceId = Control.SelectedResource.Id;
}
}
protected override void AssignControllerValues()
{
ASPxTextBox tbSubject = (ASPxTextBox)FindControlByID("tbSubject");
ASPxTextBox tbLocation = (ASPxTextBox)FindControlByID("tbLocation");
ASPxTextBox tbPrice = (ASPxTextBox)FindControlByID("tbPrice");
ASPxDateEdit edtStartDate = (ASPxDateEdit)FindControlByID("edtStartDate");
ASPxDateEdit edtEndDate = (ASPxDateEdit)FindControlByID("edtEndDate");
ASPxMemo memDescription = (ASPxMemo)FindControlByID("memDescription");
Controller.Subject = tbSubject.Text;
Controller.Location = tbLocation.Text;
Controller.Description = memDescription.Text;
Controller.Start = edtStartDate.Date;
Controller.End = edtEndDate.Date;
// custom fields
Controller.Price = Convert.ToDouble(tbPrice.Text);
DateTime clientStart = FromClientTime(Controller.Start);
AssignControllerRecurrenceValues(clientStart);
}
public List<WebControl> RenderControl(System.Xml.XmlNode xmlControl)
{
base.Initialize(xmlControl);
ASPxMemo aspxMemo = new ASPxMemo
{
ID = _PropertyMapper.GetID(),
NullText = "Ingrese Comentario",
Rows = 5,
Width = new Unit(80, UnitType.Percentage),
ReadOnly = _PropertyMapper.ReadOnly()
};
_Controls.Add(aspxMemo);
aspxMemo.ValidationSettings.SetFocusOnError = true;
aspxMemo.ValidationSettings.RequiredField.IsRequired = _PropertyMapper.Required();
aspxMemo.ValidationSettings.RequiredField.ErrorText = "Campo Requerido";
aspxMemo.ValidationSettings.ValidationGroup = "InputValidation";
return _Controls;
}
protected void gridKhoaDaoTaoKeHoach_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxComboBox cmb_trinhdo = gridKhoaDaoTaoKeHoach.FindEditFormTemplateControl("cmb_trinhdo") as ASPxComboBox;
ASPxTextBox txt_tenkhoadaotao = gridKhoaDaoTaoKeHoach.FindEditFormTemplateControl("txt_tenkhoadaotao") as ASPxTextBox;
ASPxTextBox txt_cosodaotao = gridKhoaDaoTaoKeHoach.FindEditFormTemplateControl("txt_cosodaotao") as ASPxTextBox;
ASPxTextBox txt_soluonghocvien = gridKhoaDaoTaoKeHoach.FindEditFormTemplateControl("txt_soluonghocvien") as ASPxTextBox;
ASPxTextBox txt_dongia = gridKhoaDaoTaoKeHoach.FindEditFormTemplateControl("txt_dongia") as ASPxTextBox;
ASPxComboBox cmb_namkehoach = gridKhoaDaoTaoKeHoach.FindEditFormTemplateControl("cmb_namkehoach") as ASPxComboBox;
//ASPxDateEdit date_tungay = gridKhoaDaoTaoKeHoach.FindEditFormTemplateControl("date_tungay") as ASPxDateEdit;
//ASPxDateEdit date_denngay = gridKhoaDaoTaoKeHoach.FindEditFormTemplateControl("date_denngay") as ASPxDateEdit;
ASPxMemo memo_ghichu = gridKhoaDaoTaoKeHoach.FindEditFormTemplateControl("memo_ghichu") as ASPxMemo;
double dongia = txt_dongia.Text == string.Empty ? 0 : Convert.ToDouble(txt_dongia.Text);
DateTime tungay = new DateTime(Convert.ToInt32(cmb_namkehoach.Value), 1, 1);
SqlHelper.ExecuteNonQuery(strconn, "[HRM_KHOADAOTAODAIHAN_UI]", e.Keys["id"], cmb_trinhdo.Value, txt_tenkhoadaotao.Text, txt_cosodaotao.Text,
txt_soluonghocvien.Text, txt_dongia.Text, tungay, null, memo_ghichu.Text, 1);
gridKhoaDaoTaoKeHoach.CancelEdit();
e.Cancel = true;
load_data_grid(cmb_nam.Value);
}
protected override void AssignControllerValues()
{
base.AssignControllerValues();
ASPxTextBox tbSubject = (ASPxTextBox)FindControlByID("ASPxTextBoxSubject");
ASPxDateEdit deStart = (ASPxDateEdit)FindControlByID("ASPxDateEditStart");
ASPxDateEdit deEnd = (ASPxDateEdit)FindControlByID("ASPxDateEditEnd");
ASPxMemo tbDescription = (ASPxMemo)FindControlByID("ASPxMemoDescription");
ASPxComboBox cbCompany = (ASPxComboBox)FindControlByID("ASPxComboBoxCompany");
ASPxComboBox cbContact = (ASPxComboBox)FindControlByID("ASPxComboBoxContact");
Controller.Subject = tbSubject.Text;
Controller.Start = Convert.ToDateTime(deStart.Value);
Controller.End = Convert.ToDateTime(deEnd.Value);
Controller.Description = tbDescription.Text;
Controller.CompanyIDField = Convert.ToInt32(cbCompany.Value);
Controller.ContactIDField = Convert.ToInt32(cbContact.Value);
if (Controller.ResourceId == ResourceEmpty.Id)
{
Controller.ResourceId = Control.SelectedResource.Id;
}
}
private void EnableSet()
{
foreach (Control c in basetable.Controls)
{
foreach (Control c1 in c.Controls)
{
foreach (Control c2 in c1.Controls)
{
string name = c2.GetType().Name;
if (name == "ASPxMemo")
{
ASPxMemo am = (ASPxMemo)c2;
am.Enabled = false;
}
if (name == "ASPxComboBox")
{
ASPxComboBox am = (ASPxComboBox)c2;
am.Enabled = false;
}
}
}
}
ASPxComboBox10.Enabled = false;
}
public static void AddParagraphQuestionAdvanced(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;
//-----
ASPxMemo txtAnswer = new ASPxMemo();
txtAnswer.ID = String.Format("Answer{0}", Q.FormFieldValues[0].FormFieldValueId);
txtAnswer.Width = new Unit(400);
txtAnswer.Height = new Unit(100);
if (Q.IsRequired)
{
txtAnswer.ValidationSettings.CausesValidation = true;
txtAnswer.ValidationSettings.ErrorDisplayMode = ErrorDisplayMode.Text;
txtAnswer.ValidationSettings.RequiredField.IsRequired = true;
}
//-----
ControlsAdder(QuestionPanel, QuestionsTemplates.Paragraph, new Control[4] { QuestionTitle, IsReqired, HelpText, txtAnswer }, new String[4] { "@QuestionTitle", "@IsRequired", "@HelpText", "@AnswerTextBox" });
}
public List<HtmlTableCell> BuildMemoText(string fieldtext, string id, string helptext, string SkinID, 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();
lb.Text = fieldtext;
cell.Controls.Add(lb);
HtmlTableCell celledit = new HtmlTableCell();
celledit.Attributes.Add("class", "tblFormViewtdValue");
celledit.Style.Add("Width", "30%");
ASPxMemo mm = new ASPxMemo() { SkinID = SkinID, ID = id, Rows = 2, /*mm.Enabled = alowEdit;*/NullText = helptext, Width = Unit.Percentage(99), ReadOnly = isReadOnly };
mm.Text = controlValue;
mm.Theme = "DevEx";
mm.AutoPostBack = false;
celledit.Controls.Add(mm);
c.Add(cell);
c.Add(celledit);
cot += 2;
}
catch (Exception)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), Guid.NewGuid().ToString(),
"<script> alert('buildMemoText fieldname" + id + "'); </script>",
false);
}
return c;
}
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);
}
public static void SetMemoValue(ASPxMemo Memo, object objects)
{
try
{
if (objects != null)
Memo.Text = objects.ToString();
}
catch (Exception ex)
{
SiAuto.Main.LogString("Lỗi SetMemoValue :", ex.ToString());
}
}
