protected void InfoGrid_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxGridView grid = sender as ASPxGridView;
ASPxComboBox code = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["Code"], "Code") as ASPxComboBox;
ASPxHiddenField errorvalue = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["Code"], "ErrorHiddenValue") as ASPxHiddenField;
ASPxTextBox prefix = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["Prefix"], "Prefix") as ASPxTextBox;
ASPxTextBox series = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["BeforeSeries"], "BeforeSeries") as ASPxTextBox;
ASPxTextBox max = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["MaxNumber"], "MaxNumber") as ASPxTextBox;
ASPxTextBox last = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["LastNumber"], "LastNumber") as ASPxTextBox;
SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString());
conn.Open();
string insert = "INSERT INTO [dbo].[tbl_PONumber] ([EntityCode], [Prefix], [BeforeSeries], [MaxNumber], [LastNumber]) VALUES (@EntityCode, @Prefix, @BeforeSeries, @MaxNumber, @LastNumber)";
double max_number = Convert.ToDouble(max.Text);
double last_number = Convert.ToDouble(last.Text);
SqlCommand cmd = new SqlCommand(insert, conn);
cmd.Parameters.AddWithValue("@EntityCode", code.Text);
cmd.Parameters.AddWithValue("@Prefix", prefix.Text);
cmd.Parameters.AddWithValue("@BeforeSeries", series.Text);
cmd.Parameters.AddWithValue("@MaxNumber", max_number);
cmd.Parameters.AddWithValue("@LastNumber", last_number);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
conn.Close();
grid.CancelEdit();
e.Cancel = true;
BindInfo();
}
public override System.Web.UI.Control Build()
{
base.Build();
ASPxDropDownEdit ddedit = new ASPxDropDownEdit();
ASPxHiddenField hfddedit = new ASPxHiddenField();
ASPxPanel panel = new ASPxPanel();
ddedit.Width = ModuleField.Width;
ddedit.Height = ModuleField.Height;
ddedit.ValidationSettings.RequiredField.IsRequired = ModuleField.IsRequired;
ddedit.ValidationSettings.RequiredField.ErrorText = ModuleField.ErrorText;
ddedit.ReadOnly = true;
ddedit.Text = ModuleField.CurrentValue == null ? ModuleField.DefaultValue == null ? null : ModuleField.DefaultValue.ToString() : ModuleField.CurrentValue.ToString();
ddedit.ClientInstanceName = "dropdown";
ddedit.DropDownWindowTemplate = new MyTemplate(ModuleField.CodeCat, hfddedit);
ddedit.ClientSideEvents.TextChanged = "SynchronizeListBoxValues";
ddedit.ClientSideEvents.DropDown = "SynchronizeListBoxValues";
//ddedit.Enabled 可用来做只读
//hf
hfddedit.ClientInstanceName = "hfddedit";
hfddedit.Clear();
if (ModuleField.CurrentCode != null)
{
List <string> codelist = ModuleField.CurrentCode.ToString().Split(';').ToList();
foreach (string code in codelist)
{
hfddedit.Add(code, "");
}
}
panel.Controls.Add(ddedit);
panel.Controls.Add(hfddedit);
return(panel);
}
protected void grid_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxTextBox txtLuongCB = grid.FindEditFormTemplateControl("txtLuongCB") as ASPxTextBox;
ASPxDateEdit txtThoiDiem = grid.FindEditFormTemplateControl("txtThoiDiem") as ASPxDateEdit;
ASPxHiddenField HiddentfileKem = grid.FindEditFormTemplateControl("HiddentfileKem") as ASPxHiddenField;
ASPxTextBox txtfilekem = grid.FindEditFormTemplateControl("txtfilekem") as ASPxTextBox;
ASPxTextBox txtQuyetDinh = grid.FindEditFormTemplateControl("txtQuyetDinh") as ASPxTextBox;
this.luongcb = objBaoHiem.GetLuongCBId(Int32.Parse(e.Keys[grid.KeyFieldName].ToString()));
if (this.luongcb != null)
{
this.luongcb.luongcb = Convert.ToDecimal(txtLuongCB.Text.Trim());
this.luongcb.thoidiem = txtThoiDiem.Date;
this.luongcb.soqd = txtQuyetDinh.Text.Trim();
if (HiddentfileKem.Count > 0)
{
this.luongcb.fileKem = "LCB" + DateTime.Now.ToShortDateString().Replace("/", "_") + "_" + HiddentfileKem.Get("filekem").ToString();
}
else
{
this.luongcb.fileKem = "LCB" + DateTime.Now.ToShortDateString().Replace("/", "_") + "_" + txtfilekem.Text.Trim();
}
this.objBaoHiem.UpdateLuongCB(luongcb);
}
grid.CancelEdit();
e.Cancel = true;
this.grid.DataSource = objBaoHiem.GetLuongCBs();
this.grid.DataBind();
}
protected void grid_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxComboBox cboOffice = grid.FindEditFormTemplateControl("cboOffice") as ASPxComboBox;
ASPxTextBox textId = grid.FindEditFormTemplateControl("txtId") as ASPxTextBox;
ASPxComboBox cboState = grid.FindEditFormTemplateControl("cboState") as ASPxComboBox;
ASPxComboBox cboEmp = grid.FindEditFormTemplateControl("cboEmp") as ASPxComboBox;
ASPxHiddenField ASPxHiddenField1 = grid.FindEditFormTemplateControl("ASPxCallbackPanel21").FindControl("ASPxHiddenField1") as ASPxHiddenField;
if (ASPxHiddenField1.Count > 0)
{
this.emp.id = -1;
this.emp.empid = Int32.Parse(ASPxHiddenField1.Get("value").ToString());
this.emp.uid = objEmployees.GetEmployees(Int32.Parse(ASPxHiddenField1.Get("value").ToString())).unitid;
this.emp.unitid = objUnit.GetUnit(objEmployees.GetEmployees(Int32.Parse(ASPxHiddenField1.Get("value").ToString())).unitid).parentid;
this.emp.officeid = Int32.Parse(cboOffice.SelectedItem.Value.ToString());
this.emp.statemanagementid = Int32.Parse(cboState.SelectedItem.Value.ToString());
this.objectEmp.AddEmpOffice(emp);
}
grid.CancelEdit();
e.Cancel = true;
if (Session["Id"] != null)
{
grid.DataSource = objectEmp.GetEmpOfficeByUnit(Int32.Parse(Session["Id"].ToString()));
grid.DataBind();
}
else
{
grid.DataSource = objectEmp.GetEmpOffices();
grid.DataBind();
}
}
private void load_data_combo()
{
if (!grid.IsNewRowEditing)
{
ASPxHiddenField hf_idQLNN = grid.FindEditFormTemplateControl("hf_idQLNN") as ASPxHiddenField;
}
}
protected void grdCreator_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxGridView grid = sender as ASPxGridView;
ASPxHiddenField masterKey = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["MasterKey"], "ASPxCreatorMasterKeyHiddenField") as ASPxHiddenField;
ASPxDateEdit effectDate = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["EffectDate"], "CreatorEffectDate") as ASPxDateEdit;
ASPxComboBox sCreator = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["UserCompleteName"], "Creator") as ASPxComboBox;
ASPxComboBox sCreatorStat = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["StatusDesc"], "CreatorStatus") as ASPxComboBox;
SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString());
conn.Open();
string sLastModified = DateTime.Now.ToString();
string insert = "INSERT INTO tbl_System_BusinessUnit_Creator (MasterKey, UserKey, EffectDate, StatusKey) VALUES (@MasterKey, @UserKey, @EffectDate, @StatusKey)";
SqlCommand cmd = new SqlCommand(insert, conn);
cmd.Parameters.AddWithValue("@MasterKey", iBUSSUMasterKey.ToString());
cmd.Parameters.AddWithValue("@UserKey", sCreator.Value.ToString());
cmd.Parameters.AddWithValue("@EffectDate", effectDate.Value.ToString());
cmd.Parameters.AddWithValue("@StatusKey", sCreatorStat.Value.ToString());
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
string updateMaster = "UPDATE tbl_System_BusinessUnit SET [LastModified] = @LastModified WHERE ([PK] = @PK)";
SqlCommand cmd1 = new SqlCommand(updateMaster, conn);
cmd1.Parameters.AddWithValue("@PK", iBUSSUMasterKey.ToString());
cmd1.Parameters.AddWithValue("@LastModified", sLastModified.ToString());
cmd1.CommandType = CommandType.Text;
cmd1.ExecuteNonQuery();
e.Cancel = true;
grid.CancelEdit();
//BindSCMProcOff_Details(Convert.ToInt32(sMasterKey.Value));
//BindSCMProcOff_Details(iProcOffMaster);
BindBUSSUListCreator(iBUSSUMasterKey);
grdBUSSU.Enabled = true;
int pk_latest = 0;
string query_pk = "SELECT TOP 1 [PK] FROM tbl_System_BusinessUnit_Creator 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 override void OnInit(EventArgs e)
{
base.OnInit(e);
tbControl = new Table()
{
CellPadding = 0, CellSpacing = 0
};
TableRow row = new TableRow();
row.Cells.Add(new TableCell()
{
HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Left,
VerticalAlign = System.Web.UI.WebControls.VerticalAlign.Middle
});
row.Cells.Add(new TableCell()
{
HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Left,
VerticalAlign = System.Web.UI.WebControls.VerticalAlign.Middle
});
tbControl.Rows.Add(row);
tbControl.Rows[0].Cells[1].Attributes.Add("style", "padding-left:2px");
lblName = new ASPxLabel()
{
ID = "lblName",
ClientInstanceName = this.ClientID + "_lblName",
};
hddData = new ASPxHiddenField()
{
ID = "hddData",
ClientInstanceName = this.ClientID + "_hddData",
};
sqlDataSource = new SqlDataSource()
{
ID = this.ClientID + "_sqlDataSource",
SelectCommandType = SqlDataSourceCommandType.Text,
};
cbClickGdvRow = new ASPxCallback()
{
ID = "cbClickGdvRow",
ClientInstanceName = this.ClientID + "_cbClickGdvRow",
};
bteTextInput = new ASPxButtonEdit()
{
ID = "bteTextInput",
ClientInstanceName = this.ClientID + "_bteTextInput",
};
popDataList = new ASPxPopupControl()
{
ID = "popDataList",
ClientInstanceName = this.ClientID + "_popDataList",
};
gdvDataList = new ASPxGridView()
{
ID = "gdvDataList",
ClientInstanceName = this.ClientID + "_gdvDataList",
EnableRowsCache = false,
EnableViewState = false,
};
}
private void Initialize(ASPxHiddenField clientStateField)
{
foreach (KeyValuePair <string, object> pair in clientStateField)
{
HttpContext.Current.Items.Add(pair.Key, pair.Value);
}
HttpContext.Current.Items.Add(stateInitizedKey, true);
}
protected void Page_Init(object sender, EventArgs e)
{
MasterPage = (RootMaster)Page.Master.Master;
rootParameters = MasterPage.masterParameters;
//TODO temporarily disabled, fills the quick scores. currently hardwired to 0-5
PrepareDropdown();
}
/// <summary>
/// 用一个foreach的函数填入相关信息
/// </summary>
/// <returns></returns>
public override System.Web.UI.Control Build()
{
base.Build();
ASPxPanel panel = new ASPxPanel();
ASPxCheckBox checkbox;
ASPxHiddenField CBhiddenfield = new ASPxHiddenField();
ASPxHiddenField CBhiddenfieldc = new ASPxHiddenField();
ASPxHiddenField CBhiddenfieldall = new ASPxHiddenField();
CBhiddenfield.ClientInstanceName = "CBhiddenfield";
CBhiddenfield.Clear();
CBhiddenfieldc.ClientInstanceName = "CBhiddenfieldc";
CBhiddenfieldc.Clear();
CBhiddenfieldall.ClientInstanceName = "CBhiddenfieldall";
CBhiddenfieldall.Clear();
//先添加隐藏控件
panel.Controls.Add(CBhiddenfield);
panel.Controls.Add(CBhiddenfieldc);
panel.Controls.Add(CBhiddenfieldall);
string selected = ModuleField.CurrentValue == null ? ModuleField.DefaultValue == null ? null : ModuleField.DefaultValue.ToString() : ModuleField.CurrentValue.ToString();
List <string> selectedlist = new List <string>();
if (selected != null)
{
string[] selectedarray = selected.Split(';');
selectedlist = selectedarray.ToList <string>();
}
List <DictionaryItem> itemslist = new List <DictionaryItem>();
using (TestDBEntities entity = new TestDBEntities())
{
itemslist = entity.DictionaryItem.Where(oo => oo.DictionaryItemCode.StartsWith(ModuleField.CodeCat) && oo.DictionaryItemCode.Length == 7).ToList();
}
foreach (DictionaryItem item in itemslist)
{
checkbox = new ASPxCheckBox();
checkbox.Text = item.DictionaryItemName;
checkbox.Value = item.DictionaryItemValue;
CBhiddenfieldall.Add(item.DictionaryItemName, item.DictionaryItemValue);
checkbox.ClientSideEvents.CheckedChanged = "function (s,e) {CBchange(s,e);}";
if (selected != null)
{
foreach (string defaultchecked in selectedlist)
{
if (item.DictionaryItemName == defaultchecked)
{
checkbox.Checked = true;
CBhiddenfield.Add(item.DictionaryItemName, "");
CBhiddenfield.Add(item.DictionaryItemValue, "");
}
}
}
panel.Controls.Add(checkbox);
}
//排列方式
return(panel);
}
protected void grdSCMProcurementOffDetails_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxGridView grid = sender as ASPxGridView;
ASPxHiddenField masterKey = grdSCMProcurementOffDetails.FindEditRowCellTemplateControl((GridViewDataColumn)grdSCMProcurementOffDetails.Columns["MasterKey"], "ASPxMasterKeyHiddenField") as ASPxHiddenField;
ASPxComboBox scmProfCat = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["ProcCatDesc"], "ProcurementCat") as ASPxComboBox;
SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString());
conn.Open();
string sLastModified = DateTime.Now.ToString();
string insert = "INSERT INTO tbl_System_SCMProcurementOfficer_Details ([MasterKey], [ProcCat]) " +
" VALUES (@MasterKey, @ProcCat)";
SqlCommand cmd = new SqlCommand(insert, conn);
//cmd.Parameters.AddWithValue("@MasterKey", sMasterKey.Value.ToString());
cmd.Parameters.AddWithValue("@MasterKey", iProcOffMaster.ToString());
cmd.Parameters.AddWithValue("@ProcCat", scmProfCat.Value.ToString());
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
string updateMaster = "UPDATE tbl_System_SCMProcurementOfficer " +
" SET [LastModified] = @LastModified " +
" WHERE ([PK] = @PK)";
SqlCommand cmd1 = new SqlCommand(updateMaster, conn);
cmd1.Parameters.AddWithValue("@PK", iProcOffMaster.ToString());
cmd1.Parameters.AddWithValue("@LastModified", sLastModified.ToString());
cmd1.CommandType = CommandType.Text;
cmd1.ExecuteNonQuery();
e.Cancel = true;
grid.CancelEdit();
//BindSCMProcOff_Details(Convert.ToInt32(sMasterKey.Value));
BindSCMProcOff_Details(iProcOffMaster);
//grdSCMProcurementOff.Enabled = true;
int pk_latest = 0;
string query_pk = "SELECT TOP 1 [PK] FROM tbl_System_SCMProcurementOfficer_Details 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 hfCustomIntervals_Init(object sender, EventArgs e)
{
ASPxHiddenField hiddenField = sender as ASPxHiddenField;
hiddenField["Cherries"] = 2000;
hiddenField["Raspberry"] = 5000;
hiddenField["Strawberry"] = 1000;
hiddenField["Tomatoes"] = 4000;
}
public RibbonStateController(ASPxHiddenField clientStateField)
{
stateKeyPrefix = defaultPrefix + clientStateField.ClientID;
stateInitizedKey = defaultPrefix + "Initialized" + clientStateField.ClientID;
if (!IsInitialized)
{
Initialize(clientStateField);
}
this.clientStateField = clientStateField;
}
protected void ASPxCallbackPanel21_Callback(object source, DevExpress.Web.ASPxClasses.CallbackEventArgsBase e)
{
ASPxHiddenField ASPxHiddenField1 = grid.FindEditFormTemplateControl("ASPxCallbackPanel21").FindControl("ASPxHiddenField1") as ASPxHiddenField;
string id = e.Parameter.ToString();
this.employees = objEmployees.GetEmployees(Int32.Parse(id));
if (this.employees != null)
{
ASPxHiddenField1["value"] = this.employees.id;
}
}
protected void Page_Init(object sender, EventArgs e)
{
MasterPage = (RootMaster)Page.Master.Master;
rootParameters = MasterPage.masterParameters;
//if (!(rc_services.CheckPermission("pro_RTM_Responses_edit")))
//{
// dropMilestone.ReadOnly = true;
// dropAssessment.ReadOnly = true;
// txResponse.Settings.AllowHtmlView = false;
// txResponse.Settings.AllowPreview = true;
// txResponse.Settings.AllowDesignView = false;
//}
}
protected void hfEditorData_Init(object sender, EventArgs e)
{
ASPxHiddenField hiddenField = sender as ASPxHiddenField;
GridViewEditFormTemplateContainer container = hiddenField.NamingContainer as GridViewEditFormTemplateContainer;
foreach (GridViewColumn col in container.Grid.Columns)
{
GridViewDataColumn dataCol = col as GridViewDataColumn;
if ((dataCol != null) && (!hiddenField.Contains(dataCol.FieldName)))
{
hiddenField[dataCol.FieldName] = DataBinder.Eval(container.DataItem, dataCol.FieldName);
}
}
}
void cellEditor_Init(object sender, EventArgs e)
{
ASPxEdit editor = sender as ASPxEdit;
GridViewDataItemTemplateContainer container = editor.NamingContainer as GridViewDataItemTemplateContainer;
editor.Width = new Unit(100, UnitType.Percentage);
ASPxHiddenField hfData = container.Grid.FindTitleTemplateControl("hfData") as ASPxHiddenField;
string fieldKey = String.Format("{0}_{1}", container.KeyValue, container.Column.FieldName);
editor.Value = (hfData != null && hfData.Contains(fieldKey)) ? hfData[fieldKey] : DataBinder.Eval(container.DataItem, container.Column.FieldName);
editor.SetClientSideEventHandler("ValueChanged", String.Format("function(s, e) {{ {0}_hfData.Set('{1}', s.GetValue()); }}", container.Grid.UniqueID, fieldKey));
}
public override void DataBind()
{
base.DataBind();
AppointmentFormTemplateContainer container = (AppointmentFormTemplateContainer)Parent;
Appointment apt = container.Appointment;
edtLabel.SelectedIndex = apt.LabelId;
edtStatus.SelectedIndex = apt.StatusId;
AppointmentRecurrenceForm1.Visible = container.ShouldShowRecurrence;
if (container.Appointment.HasReminder)
{
cbReminder.Value = container.Appointment.Reminder.TimeBeforeStart.ToString();
chkReminder.Checked = true;
}
else
{
cbReminder.ClientEnabled = false;
}
IList resources = container.ResourceDataSource as IList;
int count = this.rpResources.Items.Count;
for (int i = 0; i < count; i++)
{
string resourceIdString = ((ListEditItem)resources[i]).Value.ToString();
string caption = ((ListEditItem)resources[i]).Text;
if (resourceIdString == "null")
{
continue;
}
int resourceId = int.Parse(resourceIdString);
RepeaterItem repeaterItem = this.rpResources.Items[i];
ASPxCheckBox chkBox = repeaterItem.FindControl("chkResource") as ASPxCheckBox;
ASPxHiddenField hiddenField = repeaterItem.FindControl("hfResource") as ASPxHiddenField;
chkBox.Text = caption;
chkBox.Checked = apt.ResourceIds.Contains(resourceId);
hiddenField.Set("resourceId", resourceId);
}
btnOk.ClientSideEvents.Click = container.SaveHandler;
btnCancel.ClientSideEvents.Click = container.CancelHandler;
btnDelete.ClientSideEvents.Click = container.DeleteHandler;
}
public override System.Web.UI.Control Build()
{
base.Build();
ASPxPanel panel = new ASPxPanel();
ASPxRadioButtonList radioList = new ASPxRadioButtonList();
radioList.ClientInstanceName = "radioList";
//是否必填
radioList.ValidationSettings.RequiredField.IsRequired = ModuleField.IsRequired;
//选项为空的提示
radioList.ValidationSettings.RequiredField.ErrorText = ModuleField.ErrorText;
//排列方式
radioList.RepeatDirection = RepeatDirection.Horizontal;
//代码分类
List <DictionaryItem> itemslist = new List <DictionaryItem>();
using (TestDBEntities entity = new TestDBEntities())
{
itemslist = entity.DictionaryItem.Where(oo => oo.DictionaryItemCode.StartsWith(ModuleField.CodeCat) && oo.DictionaryItemCode.Length == 7).ToList();
}
foreach (DictionaryItem item in itemslist)
{
radioList.Items.Add(item.DictionaryItemName, item.DictionaryItemValue);
}
//默认值与当前值
string selected = ModuleField.CurrentValue == null ? ModuleField.DefaultValue == null ? null : ModuleField.DefaultValue.ToString() : ModuleField.CurrentValue.ToString();
if (selected != null)
{
radioList.Items.FindByText(selected).Selected = true;
}
//为RBlist添加改变事件
radioList.ClientSideEvents.SelectedIndexChanged = "function (s,e){RBchange(s);}";
//添加一个隐藏控件
ASPxHiddenField RBhiddenfield = new ASPxHiddenField();
RBhiddenfield.ClientInstanceName = "RBhiddenfield";
RBhiddenfield.Clear();
//写入值
if (selected != null)
{
RBhiddenfield.Add(radioList.Items.FindByText(selected).Text, radioList.Items.FindByText(selected).Value);
}
panel.Controls.Add(radioList);
panel.Controls.Add(RBhiddenfield);
return(panel);
}
protected void gvProducts_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxGridView gridView = sender as ASPxGridView;
ASPxHiddenField hfEditorData = gridView.FindEditFormTemplateControl("hfEditorData") as ASPxHiddenField;
foreach (GridViewColumn col in gridView.Columns)
{
GridViewDataColumn dataCol = col as GridViewDataColumn;
if (dataCol != null)
{
e.NewValues[dataCol.FieldName] = hfEditorData[dataCol.FieldName];
}
}
//Comment next line to allow editing
throw new Exception("Data modifications are not allowed in this example.");
}
public void InstantiateIn(Control container)
{
GridViewTitleTemplateContainer titleContainer = container as GridViewTitleTemplateContainer;
ASPxHiddenField hiddenField = new ASPxHiddenField();
hiddenField.ID = "hfData";
hiddenField.ClientInstanceName = String.Format("{0}_hfData", titleContainer.Grid.UniqueID);
titleContainer.Controls.Add(hiddenField);
ASPxButton btUpdate = new ASPxButton();
btUpdate.ID = "btUpdate";
btUpdate.Text = "Apply changes";
btUpdate.AutoPostBack = false;
btUpdate.ClientSideEvents.Click = String.Format("function(s, e) {{ {0}.PerformCallback(); }}", titleContainer.Grid.ClientInstanceName);
titleContainer.Controls.Add(btUpdate);
}
protected void Page_Load(object sender, EventArgs e)
{
CheckCreatorKey();
if (!Page.IsPostBack)
{
//ScriptManager.RegisterStartupScript(this.Page, typeof(string), "Resize", "changeWidth.resizeWidth();", true);
ASPxHiddenField entText = MainTable.FindHeaderTemplateControl(MainTable.Columns[0], "ASPxHiddenFieldEnt") as ASPxHiddenField;
entText["hidden_value"] = Session["EntityCode"].ToString();
}
BindMRP(Convert.ToInt32(Session["viewAllMRP"]), Session["EntityCode"].ToString(), Session["BUCode"].ToString());
if (!Page.IsAsync)
{
//ASPxHiddenFieldEnt
}
}
protected void grdSCMProcurementOffDetails_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxGridView grid = sender as ASPxGridView;
ASPxHiddenField masterKey = grdSCMProcurementOffDetails.FindEditRowCellTemplateControl((GridViewDataColumn)grdSCMProcurementOffDetails.Columns["MasterKey"], "ASPxMasterKeyHiddenField") as ASPxHiddenField;
ASPxComboBox scmProfCat = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["ProcCatDesc"], "ProcurementCat") as ASPxComboBox;
SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString());
conn.Open();
string sLastModified = DateTime.Now.ToString();
string PK = e.Keys[0].ToString();
string update = "UPDATE tbl_System_SCMProcurementOfficer_Details " +
" SET [ProcCat] = @ProcCat " +
" WHERE ([PK] = @PK)";
SqlCommand cmd = new SqlCommand(update, conn);
cmd.Parameters.AddWithValue("@PK", PK);
cmd.Parameters.AddWithValue("@ProcCat", scmProfCat.Value.ToString());
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
string updateMaster = "UPDATE tbl_System_SCMProcurementOfficer " +
" SET [LastModified] = @LastModified " +
" WHERE ([PK] = @PK)";
SqlCommand cmd1 = new SqlCommand(updateMaster, conn);
cmd1.Parameters.AddWithValue("@PK", iProcOffMaster.ToString());
cmd1.Parameters.AddWithValue("@LastModified", sLastModified.ToString());
cmd1.CommandType = CommandType.Text;
cmd1.ExecuteNonQuery();
conn.Close();
e.Cancel = true;
grid.CancelEdit();
BindSCMProcOff_Details(iProcOffMaster);
}
protected void HLSSOAList_CustomButtonCallback(object sender, ASPxGridViewCustomButtonCallbackEventArgs e)
{
//MRPClass.PrintString(e.ButtonID);
ASPxHiddenField InvoiceNum = HLSSOAList.FindHeaderTemplateControl(HLSSOAList.Columns[0], "HLSSOAInvHiddenVal") as ASPxHiddenField;
if (e.ButtonID == "Delete")
{
//MRPClass.PrintString("pass delete");
if (HLSSOAList.FocusedRowIndex > -1)
{
string BillInvNum = HLSSOAList.GetRowValues(HLSSOAList.FocusedRowIndex, "BillingInv").ToString();
InvoiceNum["hidden_value"] = BillInvNum.Trim();
//if (BillInvNum.Trim() != "")
//{
// txtError.Text = "Can't delete. Already invoiced. ";
// PopUpControlError.HeaderText = "Error...";
// PopUpControlError.ShowOnPageLoad = true;
//}
//else
//{
// //MRPClass.PrintString("pass popup");
// PopupDelete.HeaderText = "Confirm";
// PopupDelete.ShowOnPageLoad = true;
//}
}
}
if (e.ButtonID == "Preview")
{
if (HLSSOAList.FocusedRowIndex > -1)
{
Session["HLS_Trans"] = "View";
Session["HLS_Add_Year"] = HLSSOAList.GetRowValues(HLSSOAList.FocusedRowIndex, "Year").ToString();
Session["HLS_Add_WeekNum"] = HLSSOAList.GetRowValues(HLSSOAList.FocusedRowIndex, "WeekNum").ToString();
Session["HLS_Add_CustCode"] = HLSSOAList.GetRowValues(HLSSOAList.FocusedRowIndex, "CustCode").ToString();
Session["HLS_Add_SOANum"] = HLSSOAList.GetRowValues(HLSSOAList.FocusedRowIndex, "SOANum").ToString();
//Response.Redirect("hlsSOA_Add.aspx");
Response.RedirectLocation = "hlsSOA_Add.aspx";
}
}
}
protected void grid_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
ASPxGridView gridView = sender as ASPxGridView;
ASPxHiddenField hfData = gridView.FindTitleTemplateControl("hfData") as ASPxHiddenField;
OleDbConnection connection = GetConnection();
if (connection == null)
{
return;
}
for (int i = 0; i < gridView.VisibleRowCount; i++)
{
bool isRowUpdated = false;
object[] values = new object[gridView.Columns.Count];
foreach (GridViewDataColumn column in gridView.Columns)
{
string fieldKey = String.Format("{0}_{1}", gridView.GetRowValues(i, gridView.KeyFieldName), column.FieldName);
if (hfData.Contains(fieldKey))
{
values[column.Index] = hfData[fieldKey];
isRowUpdated = true;
}
else
{
values[column.Index] = gridView.GetRowValues(i, column.FieldName);
}
}
if (isRowUpdated)
{
UpdateGrid(connection, gridView, values);
}
}
connection.Close();
gridView.DataBind();
}
public HiddenFieldStateContainer(ASPxHiddenField persistedDataContainer)
{
DataContainer = persistedDataContainer;
}
protected override void OnInit(EventArgs e)
{
base.OnInit(e);
Page.RegisterRequiresControlState(this);
hddData = new ASPxHiddenField()
{
ID = "hddData",
ClientInstanceName = this.ClientID + "_hddData",
};
sqlDataSource = new SqlDataSource()
{
ID = this.ClientID + "_sqlDataSource",
SelectCommandType = SqlDataSourceCommandType.Text,
};
bteTextInput = new ASPxButtonEdit()
{
ID = "bteTextInput",
ClientInstanceName = this.ClientID + "_bteTextInput",
ReadOnly = true,
Width = this.Width,
};
bteTextInput.ReadOnlyStyle.BackColor = System.Drawing.Color.WhiteSmoke;
popDataList = new ASPxPopupControl()
{
ID = "popDataList",
ClientInstanceName = this.ClientID + "_popDataList",
};
tree = new ASPxTreeList()
{
ID = "tree",
ClientInstanceName = this.ClientID + "_tree",
DataCacheMode = TreeListDataCacheMode.Disabled,
EnableViewState = false,
DataSourceID = sqlDataSource.ID,
KeyFieldName = "NodeID",
ParentFieldName = "ParentNodeID",
Width = Unit.Percentage(100),
};
tree.Columns.Add(new TreeListDataColumn()
{
Name = "Code",
FieldName = "Code",
Caption = "Code",
});
tree.Columns.Add(new TreeListDataColumn()
{
Name = "Title",
FieldName = "Title",
Caption = "Title",
});
tree.SettingsBehavior.ExpandCollapseAction = TreeListExpandCollapseAction.NodeDblClick;
tree.SettingsBehavior.AutoExpandAllNodes = true;
tree.HtmlRowPrepared += new TreeListHtmlRowEventHandler(tree_HtmlRowPrepared);
panel = new Panel()
{
ID = "panel",
Height = Unit.Pixel(500),
};
panel.ScrollBars = ScrollBars.Vertical;
}
//public Boolean IsSelecting // must use control with default value of false
//{
// get { if (rootParameters.Contains("attacherIsSelecting")) { return (bool)rootParameters["attacherIsSelecting"]; } else { return false; }; }
// set { rootParameters.Set("attacherIsSelecting", value); }
//}
protected void Page_Init(object sender, EventArgs e)
{
MasterPage = (RootMaster)Page.Master.Master;
rootParameters = MasterPage.masterParameters;
}
public MyTemplate(string codecat, ASPxHiddenField hfddedit)
{
CodeCat = codecat;
}
public override System.Web.UI.Control Build()
{
base.Build();
ASPxPanel panel = new ASPxPanel();
ASPxUploadControl upload = new ASPxUploadControl();
ASPxButton uploadbotton = new ASPxButton();
ASPxLabel uploadurl = new ASPxLabel();
ASPxButton clippingbutton = new ASPxButton();
ASPxButton previewbutton = new ASPxButton();
ASPxButton clippingWH = new ASPxButton();
ASPxButton clippingSubmit = new ASPxButton();
ASPxButton clippingCancel = new ASPxButton();
ASPxPopupControl clipping = new ASPxPopupControl();
ASPxPopupControl preview = new ASPxPopupControl();
ASPxCallback callbackpic = new ASPxCallback();
ASPxLabel uploadfinishname = new ASPxLabel();
ASPxButton imagedelete = new ASPxButton();
ASPxCallback callbackdelete = new ASPxCallback();
ASPxHiddenField picturehf = new ASPxHiddenField();
//定义upload
upload.ClientInstanceName = "upload";
upload.ShowProgressPanel = true;
upload.BrowseButton.Text = "浏览";
upload.FileUploadComplete += new EventHandler <FileUploadCompleteEventArgs>(uc_FileUploadComplete);
//upload.ClientSideEvents.FilesUploadComplete = "function(s, e) { Uploader_PicturesUploadComplete(e); }";
upload.ClientSideEvents.FileUploadComplete = "function(s, e) { Uploader_PictureUploadComplete(e); }";
upload.ClientSideEvents.FileUploadStart = "function(s, e) { Uploader_PictureUploadStart(); }";
upload.ClientSideEvents.TextChanged = "function(s, e) { PictureUpdateUploadButton(); }";
upload.ValidationSettings.MaxFileSize = 4194304;
string[] fileExtensions = new string[4] {
".jpg", ".jpeg", ".jpe", ".gif"
};
upload.ValidationSettings.AllowedFileExtensions = fileExtensions;
//定义上传按钮
uploadbotton.AutoPostBack = false;
uploadbotton.Text = "上传";
uploadbotton.ClientInstanceName = "uploadpicturebotton";
uploadbotton.ClientEnabled = false;
uploadbotton.ClientSideEvents.Click = "function(s, e) { imagedelete();upload.Upload();}";
//定义剪裁按钮
clippingbutton.AutoPostBack = false;
clippingbutton.Text = "剪裁";
clippingbutton.ClientInstanceName = "clippingbutton";
clippingbutton.ClientEnabled = false;
clippingbutton.ClientSideEvents.Click = "function(s, e) { clipping();initialization();}";
//弹出的剪裁窗口定义
clipping.CloseAction = CloseAction.CloseButton;
clipping.Modal = true;
clipping.PopupHorizontalAlign = PopupHorizontalAlign.WindowCenter;
clipping.PopupVerticalAlign = PopupVerticalAlign.WindowCenter;
clipping.ClientInstanceName = "clippingview";
clipping.HeaderText = "图片剪裁";
clipping.AllowDragging = true;
clipping.EnableAnimation = false;
clipping.EnableViewState = false;
clipping.MinWidth = 500;
clipping.MinHeight = 400;
clipping.ClientSideEvents.CloseButtonClick = "function(s, e) { destroy();}";
clipping.ClientSideEvents.Init = "function(s, e){s.hideBodyScrollWhenModal = false;}";
//弹出剪裁窗口中的控件定义
clippingWH.AutoPostBack = false;
clippingWH.Text = "更改长宽";
clippingWH.ClientSideEvents.Click = "function(s, e) { clippingWHclick();}";
clippingSubmit.AutoPostBack = false;
clippingSubmit.Text = "剪裁";
clippingSubmit.ClientSideEvents.Click = "function(s, e) { clippingSubmit();}";
//callback接收剪裁数据
callbackpic.ClientInstanceName = "callbackpic";
callbackpic.Callback += new CallbackEventHandler(OnCallbackComplete);
callbackpic.ClientSideEvents.CallbackComplete = "function(s, e) { CallbackComplete(e);}";
clippingCancel.AutoPostBack = false;
clippingCancel.Text = "取消";
clippingCancel.ClientSideEvents.Click = "function(s, e) { clippingview.Hide();destroy();}";
clipping.Controls.Add(new LiteralControl("<table><tr><td>"));
clipping.Controls.Add(new LiteralControl("<img src='' id='clippingpicture' alt='' />"));
clipping.Controls.Add(new LiteralControl("</td><td>"));
clipping.Controls.Add(new LiteralControl("<div style='width:150px;height:150px;overflow:hidden;' id='divsmall'>"));
clipping.Controls.Add(new LiteralControl("<img src='' id='small' alt='' />"));
clipping.Controls.Add(new LiteralControl("</div></td></tr></table>"));
clipping.Controls.Add(new LiteralControl("<br />"));
clipping.Controls.Add(new LiteralControl("<table><tr><td colspan='6'>可自定义框体长宽：</td>"));
clipping.Controls.Add(new LiteralControl("<tr><td><label>X1 <input type='text' size='4' id='x1' name='x1' readonly='readonly' /></label></td>"));
clipping.Controls.Add(new LiteralControl("<td><label>Y1 <input type='text' size='4' id='y1' name='y1' readonly='readonly' /></label></td>"));
clipping.Controls.Add(new LiteralControl("<td><label>X2 <input type='text' size='4' id='x2' name='x2' readonly='readonly' /></label></td>"));
clipping.Controls.Add(new LiteralControl("<td><label>Y2 <input type='text' size='4' id='y2' name='y2' readonly='readonly' /></label></td>"));
clipping.Controls.Add(new LiteralControl("<td><label>W <input type='text' size='4' id='w' name='w' /></label></td>"));
clipping.Controls.Add(new LiteralControl("<td><label>H <input type='text' size='4' id='h' name='h' /></label></td></tr>"));
clipping.Controls.Add(new LiteralControl("<tr><td colspan='4'></td>"));
clipping.Controls.Add(new LiteralControl("<td colspan='2' align='middle'>"));
clipping.Controls.Add(clippingWH);
clipping.Controls.Add(new LiteralControl("</td></tr>"));
clipping.Controls.Add(new LiteralControl("<tr><td>"));
clipping.Controls.Add(clippingSubmit);
clipping.Controls.Add(new LiteralControl("</td>"));
clipping.Controls.Add(new LiteralControl("<td>"));
clipping.Controls.Add(clippingCancel);
clipping.Controls.Add(new LiteralControl("</td>"));
clipping.Controls.Add(new LiteralControl("<td>"));
clipping.Controls.Add(new LiteralControl("<input type='checkbox' id='ar_lock'/><label for='ar_lock'>比例固定</label>"));
clipping.Controls.Add(new LiteralControl("</td>"));
clipping.Controls.Add(new LiteralControl("<td colspan='5'></td></tr></table>"));
//定义Label
uploadurl.Text = "";//文件名
uploadurl.ClientInstanceName = "uploadurl";
//定义预览按钮
previewbutton.AutoPostBack = false;
previewbutton.Text = "预览";
previewbutton.ClientInstanceName = "previewbutton";
previewbutton.ClientEnabled = false;
previewbutton.ClientSideEvents.Click = "function(s, e) { preview(); }";
//弹出的预览窗口定义
preview.CloseAction = CloseAction.CloseButton;
preview.Modal = true;
preview.PopupHorizontalAlign = PopupHorizontalAlign.WindowCenter;
preview.PopupVerticalAlign = PopupVerticalAlign.WindowCenter;
preview.ClientInstanceName = "previewview";
preview.HeaderText = "图片预览";
preview.AllowDragging = true;
preview.EnableAnimation = false;
preview.EnableViewState = false;
preview.Controls.Add(new LiteralControl("<img id='previewpicture' alt='' src=''"));
preview.ClientSideEvents.Init = "function(s, e){s.hideBodyScrollWhenModal = false;}";
//定义上传后保存的文件名。uploadfinishname
uploadfinishname.Text = "";
uploadfinishname.ClientInstanceName = "uploadfinishname";
//上传后，删除按钮
imagedelete.AutoPostBack = false;
imagedelete.Text = "删除";
imagedelete.ClientInstanceName = "imagedeletebutton";
imagedelete.ClientEnabled = false;
imagedelete.ClientSideEvents.Click = "function(s, e) { imagedelete(); }";
//点击删除按钮callback服务器删除对应图片
callbackdelete.ClientInstanceName = "callbackdeleteimg";
callbackdelete.Callback += new CallbackEventHandler(OnCallbackDeleteImg);
//隐藏控件保存图片地址
picturehf.ClientInstanceName = "picturehf";
panel.Controls.Add(new LiteralControl("<table><tr><td>"));
panel.Controls.Add(upload);
panel.Controls.Add(new LiteralControl("</td><td>"));
panel.Controls.Add(uploadbotton);
panel.Controls.Add(new LiteralControl("</td></tr><tr><td>"));
panel.Controls.Add(uploadurl);
panel.Controls.Add(new LiteralControl("</td><td>"));
panel.Controls.Add(clippingbutton);
panel.Controls.Add(clipping);
panel.Controls.Add(new LiteralControl("</td></tr><tr><td>"));
panel.Controls.Add(uploadfinishname);
panel.Controls.Add(new LiteralControl("</td><td>"));
panel.Controls.Add(imagedelete);
panel.Controls.Add(previewbutton);
panel.Controls.Add(preview);
panel.Controls.Add(new LiteralControl("</td></tr></table>"));
panel.Controls.Add(callbackpic);
panel.Controls.Add(callbackdelete);
panel.Controls.Add(picturehf);
return(panel);
}
public static void RegisterStateHiddenField(ASPxHiddenField hf)
{
StateHiddenField = hf;
}
