protected void Page_Load(object sender, EventArgs e) { Page.Form.Enctype = "multipart/form-data"; lblDetailsRequired.Visible = false; if (!Page.IsPostBack) { bool EnableFullMode = (SecurityManager.IsStaffOrAdmin); TypeDropDownList.DataSource = SettingsManager.TicketTypesList; TypeDropDownList.DataBind(); PriorityDropDownList.DataSource = SettingsManager.PrioritiesList; PriorityDropDownList.DataBind(); CategoryDropDownList.DataSource = SettingsManager.CategoriesList; CategoryDropDownList.DataBind(); PriorityDropDownList.Enabled = (SecurityManager.SubmitterCanEditPriority || EnableFullMode); OwnerUpdatePanel.Visible = EnableFullMode; OwnerDropDownList.Items.AddRange(GetOwnerUserList()); } }
//清除条件 private void clearCondition() { WarehouseDropDownList.ClearSelection(); WarehouseDropDownList.Items[0].Selected = true; ChildWarehouseDropDownList.ClearSelection(); ChildWarehouseDropDownList.Items[0].Selected = true; TypeDropDownList.ClearSelection(); TypeDropDownList.Items[0].Selected = true; SubTypeDropDownList.ClearSelection(); SubTypeDropDownList.Items[0].Selected = true; DateTextBox.Text = System.DateTime.Now.ToString("yyyy-MM-dd"); TextBoxCode.Text = string.Empty; //物料代码 TextBoxName.Text = string.Empty; //物料名称 TextBoxPTC.Text = string.Empty; //计划跟踪号 TextBoxNO.Text = string.Empty; //标识号 TextBoxLotNumber.Text = string.Empty; //批号 TextBoxLength.Text = string.Empty; //长 TextBoxWidth.Text = string.Empty; //宽 TextBoxAttribute.Text = string.Empty; //材质 TextBoxStandard.Text = string.Empty; //规格型号 TextBoxFixed.Text = string.Empty; //是否定尺 TextBoxNote.Text = string.Empty; //备注查询 TextBoxOrderCode.Text = string.Empty; //订单编号 }
private void GetMaType() { string sql = "SELECT DISTINCT TY_ID,TY_NAME FROM TBMA_TYPEINFO WHERE TY_FATHERID='ROOT' ORDER BY TY_ID"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sql); TypeDropDownList.DataSource = dt; TypeDropDownList.DataTextField = "TY_NAME"; TypeDropDownList.DataValueField = "TY_ID"; TypeDropDownList.DataBind(); ListItem item = new ListItem("--请选择--", "0"); TypeDropDownList.Items.Insert(0, item); }
protected void FillDropDownList() { try { Query = "select type_id , name from ItemType"; dt = cc.GetData(Query); TypeDropDownList.DataValueField = "type_id"; TypeDropDownList.DataTextField = "name"; TypeDropDownList.DataSource = dt; TypeDropDownList.DataBind(); } catch (Exception ex) { Response.Write("<script>alert('" + ex.Message + "');</script>"); } }
public override void DataBind() { base.DataBind(); //load data & default selections TypeDropDownList.DataSource = EnumUtils.GetList <SelectableMetadataType>(); TypeDropDownList.DataBind(); DepthDropDownList.DataSource = Enumerable.Range(2, Settings.MaxSelectableMetadataDepth); DepthDropDownList.DataBind(); SortTypeRadioButtonList.DataSource = EnumUtils.GetList <SelectableMetadataSortType>(); SortTypeRadioButtonList.DataBind(); SortTypeRadioButtonList.SelectedValue = ((int)SelectableMetadataSortType.AlphaNumeric).ToString(); OrderTypeRadioButtonList.DataSource = EnumUtils.GetList <SelectableMetadataOrderType>(); OrderTypeRadioButtonList.DataBind(); ColumnsDropDownList.DataSource = Enumerable.Range(1, 10); ColumnsDropDownList.DataBind(); ApplySelectableTypeLogicToControls(); //init controls depending on supplied selectable metadata setting); if (setting != null && BrandMetadataSelectableSettingId > 0) { TypeDropDownList.SelectedValue = setting.SelectableType.ToString(); DepthDropDownList.SelectedValue = setting.Depth.ToString(); SortTypeRadioButtonList.SelectedValue = setting.SortType.ToString(); OrderTypeRadioButtonList.SelectedValue = setting.OrderType.ToString(); ColumnsDropDownList.SelectedValue = setting.ColumnCount.ToString(); LinearCheckBox.Checked = setting.IsLinear; AllowMultipleCheckbox.Checked = setting.AllowMultiple; if (setting.SelectableType == (int)SelectableMetadataType.Checkboxes) { LayoutOptionsPanel.Visible = setting.IsLinear; } } }
private string GetStrCondition() { string condition = "1=1"; string QRcondition = ""; //以下语句为准备查询条件 //物料代码条件 if (TextBoxCode.Text.Trim() != "") { condition = " QROut_MatCode LIKE '%" + TextBoxCode.Text.Trim() + "%'"; addQueryItem(PageName, "TextBoxCode", TextBoxCode.GetType().ToString(), TextBoxCode.Text.Trim()); //%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% if (DropDownListPlanno.SelectedValue != "1") { QRcondition += " and QROut_MatCode like '%" + TextBoxCode.Text.Trim() + "%'"; } //%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% } //物料名称条件 if ((TextBoxName.Text.Trim() != "") && (condition != "")) { condition += " AND " + " MaterialName LIKE '%" + TextBoxName.Text.Trim() + "%'"; addQueryItem(PageName, "TextBoxName", TextBoxName.GetType().ToString(), TextBoxName.Text.Trim()); //%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% if (DropDownListPlanno.SelectedValue != "1") { QRcondition += " and MaterialName like '%" + TextBoxName.Text.Trim() + "%'"; } //%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% } //标识号 if ((TextBoxNO.Text.Trim() != "") && (condition != "")) { condition += " AND " + " CGMODE LIKE '%" + TextBoxNO.Text.Trim().ToUpper() + "%'"; addQueryItem(PageName, "TextBoxNO", TextBoxNO.GetType().ToString(), TextBoxNO.Text.Trim()); } //计划跟踪号条件 if ((TextBoxPTC.Text.Trim() != "") && (condition != "")) { if (TextBoxPTC.Text.Trim() == "备库") { condition += " AND " + " (PTC LIKE '%备库%' or PTC LIKE '%BEIKU%')"; addQueryItem(PageName, "TextBoxPTC", TextBoxPTC.GetType().ToString(), TextBoxPTC.Text.Trim()); } else { condition += " AND " + " PTC LIKE'%" + TextBoxPTC.Text.Trim() + "%'"; addQueryItem(PageName, "TextBoxPTC", TextBoxPTC.GetType().ToString(), TextBoxPTC.Text.Trim()); } } //批号条件 if ((TextBoxLotNumber.Text != "") && (condition != "")) { condition += " AND " + " PTC LIKE '%" + TextBoxLotNumber.Text.Trim() + "%'"; addQueryItem(PageName, "TextBoxLotNumber", TextBoxLotNumber.GetType().ToString(), TextBoxLotNumber.Text.Trim()); } //型号规格条件 if ((TextBoxStandard.Text != "") && (condition != "")) { condition += " AND " + " Standard LIKE '%" + TextBoxStandard.Text.Trim() + "%'"; addQueryItem(PageName, "TextBoxStandard", TextBoxStandard.GetType().ToString(), TextBoxStandard.Text.Trim()); //%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% if (DropDownListPlanno.SelectedValue != "1") { QRcondition += " and Standard like '%" + TextBoxStandard.Text.Trim() + "%'"; } //%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% } //长度条件 if ((TextBoxLength.Text != "") && (condition != "")) { condition += " AND " + " Length LIKE '%" + TextBoxLength.Text.Trim() + "%'"; addQueryItem(PageName, "TextBoxLength", TextBoxLength.GetType().ToString(), TextBoxLength.Text.Trim()); } //宽度条件 if ((TextBoxWidth.Text != "") && (condition != "")) { condition += " AND " + " Width LIKE '%" + TextBoxWidth.Text.Trim() + "%'"; addQueryItem(PageName, "TextBoxWidth", TextBoxWidth.GetType().ToString(), TextBoxWidth.Text.Trim()); } //材质条件 if ((TextBoxAttribute.Text != "") && (condition != "")) { condition += " AND " + " Attribute LIKE '%" + TextBoxAttribute.Text.Trim() + "%'"; addQueryItem(PageName, "TextBoxAttribute", TextBoxAttribute.GetType().ToString(), TextBoxAttribute.Text.Trim()); //%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% if (DropDownListPlanno.SelectedValue != "1") { QRcondition += " and Attribute like '%" + TextBoxAttribute.Text.Trim() + "%'"; } //%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% } //是否定尺 if ((TextBoxFixed.Text != "") && (condition != "")) { condition += " AND " + " Fixed LIKE '%" + TextBoxFixed.Text.Trim().ToUpper() + "%'"; addQueryItem(PageName, "TextBoxFixed", TextBoxFixed.GetType().ToString(), TextBoxFixed.Text.Trim()); } //备注条件 if ((TextBoxNote.Text != "") && (condition != "")) { condition += " AND " + " Note LIKE '%" + TextBoxNote.Text.Trim() + "%'"; addQueryItem(PageName, "TextBoxNote", TextBoxNote.GetType().ToString(), TextBoxNote.Text.Trim()); } //订单编号条件 if ((TextBoxOrderCode.Text != "") && (condition != "")) { condition += " AND " + " OrderCode LIKE '%" + TextBoxOrderCode.Text.Trim() + "%'"; addQueryItem(PageName, "TextBoxOrderCode", TextBoxOrderCode.GetType().ToString(), TextBoxOrderCode.Text.Trim()); } //%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% //是否出库(即是否生成入库单) if ((DropDownListQROutState.SelectedValue != "") && (condition != "")) { condition += " AND " + " QROut_State='" + DropDownListQROutState.SelectedValue + "'"; addQueryItem(PageName, "DropDownListQROutState", DropDownListQROutState.GetType().ToString(), DropDownListQROutState.SelectedValue); //%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% QRcondition += " and QROut_State='" + DropDownListQROutState.SelectedValue + "'"; //%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% } if ((DropDownListQROutState.SelectedValue == "") && (condition != "")) { condition += " AND " + " (QROut_State='0' or QROut_State='1')"; addQueryItem(PageName, "DropDownListQROutState", DropDownListQROutState.GetType().ToString(), DropDownListQROutState.SelectedValue); } //%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% //仓库条件 if ((WarehouseDropDownList.SelectedValue != "0") && (ChildWarehouseDropDownList.SelectedValue != "0")) { if (condition != "") { condition += " AND " + " WarehouseCode='" + ChildWarehouseDropDownList.SelectedValue + "'"; addQueryItem(PageName, "WarehouseDropDownList", WarehouseDropDownList.GetType().ToString(), WarehouseDropDownList.SelectedValue); addQueryItem(PageName, "ChildWarehouseDropDownList", ChildWarehouseDropDownList.GetType().ToString(), ChildWarehouseDropDownList.SelectedValue); } else { condition += " WarehouseCode='" + ChildWarehouseDropDownList.SelectedValue + "'"; addQueryItem(PageName, "WarehouseDropDownList", WarehouseDropDownList.GetType().ToString(), WarehouseDropDownList.SelectedValue); addQueryItem(PageName, "ChildWarehouseDropDownList", ChildWarehouseDropDownList.GetType().ToString(), ChildWarehouseDropDownList.SelectedValue); } } else if ((WarehouseDropDownList.SelectedValue != "0") && (ChildWarehouseDropDownList.SelectedValue == "0")) { if (condition != "") { condition += " AND " + " WarehouseCode LIKE '" + WarehouseDropDownList.SelectedValue + "%'"; addQueryItem(PageName, "WarehouseDropDownList", WarehouseDropDownList.GetType().ToString(), WarehouseDropDownList.SelectedValue); addQueryItem(PageName, "ChildWarehouseDropDownList", ChildWarehouseDropDownList.GetType().ToString(), ChildWarehouseDropDownList.SelectedValue); } else { condition += " WarehouseCode LIKE '" + WarehouseDropDownList.SelectedValue + "%'"; addQueryItem(PageName, "WarehouseDropDownList", WarehouseDropDownList.GetType().ToString(), WarehouseDropDownList.SelectedValue); addQueryItem(PageName, "ChildWarehouseDropDownList", ChildWarehouseDropDownList.GetType().ToString(), ChildWarehouseDropDownList.SelectedValue); } } //物料条件 if ((TypeDropDownList.SelectedValue != "0") && (SubTypeDropDownList.SelectedValue != "0")) { if (condition != "") { condition += " AND " + " QROut_MatCode LIKE '" + SubTypeDropDownList.SelectedValue + "%'"; addQueryItem(PageName, "TypeDropDownList", TypeDropDownList.GetType().ToString(), TypeDropDownList.SelectedValue); addQueryItem(PageName, "SubTypeDropDownList", SubTypeDropDownList.GetType().ToString(), SubTypeDropDownList.SelectedValue); } else { condition += " QROut_MatCode LIKE '" + SubTypeDropDownList.SelectedValue + "%'"; addQueryItem(PageName, "TypeDropDownList", TypeDropDownList.GetType().ToString(), TypeDropDownList.SelectedValue); addQueryItem(PageName, "SubTypeDropDownList", SubTypeDropDownList.GetType().ToString(), SubTypeDropDownList.SelectedValue); } } else if ((TypeDropDownList.SelectedValue != "0") && (SubTypeDropDownList.SelectedValue == "0")) { if (condition != "") { condition += " AND " + " QROut_MatCode LIKE '" + TypeDropDownList.SelectedValue + "%'"; addQueryItem(PageName, "TypeDropDownList", TypeDropDownList.GetType().ToString(), TypeDropDownList.SelectedValue); addQueryItem(PageName, "SubTypeDropDownList", SubTypeDropDownList.GetType().ToString(), SubTypeDropDownList.SelectedValue); } else { condition += " QROut_MatCode LIKE '" + TypeDropDownList.SelectedValue + "%'"; addQueryItem(PageName, "TypeDropDownList", TypeDropDownList.GetType().ToString(), TypeDropDownList.SelectedValue); addQueryItem(PageName, "SubTypeDropDownList", SubTypeDropDownList.GetType().ToString(), SubTypeDropDownList.SelectedValue); } } if (DropDownListPlanno.SelectedValue == "1") { condition = condition; } else { condition = condition + " or ((PTC is null or PTC='')" + QRcondition + ")"; } return(condition); }