public void GetClassificationPicking(string cs)
{
try
{
var pResult = "";
var ds = _objPicking.GetClassificationPicking(cs, ref pResult);
if (pResult == "")
{
if (ds.Tables[0].Rows.Count > 0)
{
ASPxComboBox1.DataSource = ds;
ASPxComboBox1.TextField = "NAME_CLASSIFICATION";
ASPxComboBox1.ValueField = "CLASSIFICATION";
ASPxComboBox1.DataBind();
}
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
public void GetClassification()
{
try
{
var pResult = "";
var pResult2 = "";
var objClassification = new WSClassification.SwiftExpressWSClassification();
var ds = objClassification.GetClassification(Session["connectionString"].ToString(), "SKU", ref pResult);
if (pResult == "")
{
ASPxComboBox1.DataSource = ds;
ASPxComboBox1.ValueField = "CLASSIFICATION";
ASPxComboBox1.TextField = "VALUE_TEXT_CLASSIFICATION";
ASPxComboBox1.DataBind();
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
public void BindData()
{
List <DepartmentEntity> dept = DB.GetInstance().Fetch <DepartmentEntity>("");
com_DEPT.DataSource = dept;
com_DEPT.ValueField = "DEPT_CODE";
com_DEPT.TextField = "DEPT_NAME";
com_DEPT.DataBind();
if (com_DEPT.SelectedItem == null)
{
return;
}
string _dept = com_DEPT.SelectedItem.Value.ToString();
List <ProductLineEntity> plines = DB.GetInstance().Fetch <ProductLineEntity>("where pline_code in (select pline_code from REL_DEPT_PLINE where dept_code=@0)", _dept);
ASPxComboBox1.DataSource = plines;
ASPxComboBox1.TextField = "PLINE_NAME";
ASPxComboBox1.ValueField = "PLINE_CODE";
ASPxComboBox1.DataBind();
if (ASPxComboBox1.SelectedItem == null)
{
return;
}
Report_Exp2000_1 report = new Report_Exp2000_1(ASPxComboBox1.SelectedItem.Value.ToString(), com_DEPT.SelectedItem.Value.ToString(), ASPxDateEdit1.Date);
ReportViewer1.Report = report;
}
protected void ASPxCallbackPanel1_Callback(object source, DevExpress.Web.ASPxClasses.CallbackEventArgsBase e)
{
string[] pars = e.Parameter.Split(';');
Session["ProductID"] = pars[0];
ASPxComboBox1.DataBind();
ASPxComboBox1.SelectedIndex = 0;
ASPxPopupControl1.PopupElementID = pars[1];
}
protected void Page_Load(object sender, EventArgs e)
{
ASPxComboBox1.DataSource = new[] { "Tháng 1", "Tháng 2", "Quý 1", "6 tháng đầu năm" };
ASPxComboBox1.DataBind();
gvData.DataSource = ReportMappingConstant.getTaxReportDS();
gvData.DataBind();
if (this.hf.Value != string.Empty)
{
}
}
public void BindData()
{
List <DepartmentEntity> dept = DB.GetInstance().Fetch <DepartmentEntity>("");
com_DEPT.DataSource = dept;
com_DEPT.ValueField = "DEPT_CODE";
com_DEPT.TextField = "DEPT_NAME";
com_DEPT.DataBind();
if (com_DEPT.SelectedItem == null)
{
return;
}
string _dept = com_DEPT.SelectedItem.Value.ToString();
List <ProductLineEntity> plines = DB.GetInstance().Fetch <ProductLineEntity>("where pline_code in (select pline_code from REL_DEPT_PLINE where dept_code=@0)", _dept);
ASPxComboBox1.DataSource = plines;
ASPxComboBox1.TextField = "PLINE_NAME";
ASPxComboBox1.ValueField = "PLINE_CODE";
ASPxComboBox1.DataBind();
if (ASPxComboBox1.SelectedItem == null)
{
return;
}
string _pline = ASPxComboBox1.SelectedItem.Value.ToString();
List <ItemReturnEntity> returns = db.Fetch <ItemReturnEntity>("where order_code in (select order_code from data_plan where pline_code=@0)", _pline);
//List<UserEntity> allusers = UserFactory.GetAll();
//GridViewDataComboBoxColumn create_user = ASPxGridView1.Columns["CREATE_USER"] as GridViewDataComboBoxColumn;
//create_user.PropertiesComboBox.DataSource = allusers;
//create_user.PropertiesComboBox.ValueField = "USER_ID";
//create_user.PropertiesComboBox.TextField = "USER_NAME";
DataTable dt = new DataTable();
dt.Columns.Add("ITEM_CODE");
dt.Columns.Add("ITEM_NAME");
dt.Columns.Add("ITEM_QTY");
dt.Columns.Add("CREATE_USER");
dt.Columns.Add("ORDER_CODE");
dt.Columns.Add("STORE_CODE_1");
dt.Columns.Add("STORE_CODE_2");
dt.Columns.Add("WORK_TIME");
dt.Columns.Add("PLAN_SO");
dt.Columns.Add("PROJECT_CODE");
for (int i = 0; i < returns.Count; i++)
{
string _order = returns[i].ORDER_CODE.ToString();
PlanEntity entity = PlanFactory.GetByOrder(_order);
//dt.Rows.Add(returns[i].ITEM_CODE.ToString(),returns[i].ITEM_NAME.ToString(),returns[i].ITEM_QTY.ToString(),returns[i].CREATE_USER.ToString(),returns[i].ORDER_CODE.ToString(),returns[i].STORE_CODE_1.ToString(),returns[i].STORE_CODE_2.ToString(),returns[i].WORK_TIME.ToString(),entity.PLAN_SO.ToString(),entity.PROJECT_CODE.ToString());
}
Report_Exp1600 re = new Report_Exp1600(dt);
ReportViewer1.Report = re;
// ASPxGridView1.DataSource = returns;
//ASPxGridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
ASPxComboBox1.DataSource = new[] { "Tháng 1", "Tháng 2", "Quý 1", "6 tháng đầu năm" };
ASPxComboBox1.DataBind();
gvData.DataSource = ReportMappingConstant.getDiaryLedgerDS();
gvData.DataBind();
if (this.hf.Value != string.Empty)
{
this.ReportViewer1.Report = ReportMappingConstant.getReportInstance(this.hf.Value);
this.ReportViewer1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
List <ProductLineEntity> all = ProductLineFactory.GetAll();
ASPxComboBox1.DataSource = all;
ASPxComboBox1.TextField = "PLINE_NAME";
ASPxComboBox1.ValueField = "RMES_ID";
ASPxComboBox1.DataBind();
}
BindData();
}
//绑定专业
private void bind()
{
string zyID = Request.QueryString["zyID"].Trim();
string oracletext = "select * from CS_BASEINFOSET where INFOID= " + zyID;
ASPxComboBox1.DataSource = OracleHelper.Query(oracletext);
ASPxComboBox1.DataBind();
ASPxComboBox1.Value = zyID;
ASPxComboBox1.Enabled = false;
oracletext = "select * FROM WORKTASKS_TEMP where STATUS='保存' and PROFESSIONALID = " + ASPxComboBox1.SelectedItem.Value.ToString().Trim() + " ";
ASPxListBox1.DataSource = OracleHelper.Query(oracletext);
ASPxListBox1.DataBind();
ASPxGridView2.Visible = true;
}
public void BindData()
{
List <DepartmentEntity> dept = DB.GetInstance().Fetch <DepartmentEntity>("");
com_DEPT.DataSource = dept;
com_DEPT.ValueField = "DEPT_CODE";
com_DEPT.TextField = "DEPT_NAME";
com_DEPT.DataBind();
if (com_DEPT.SelectedItem == null)
{
return;
}
string _dept = com_DEPT.SelectedItem.Value.ToString();
List <ProductLineEntity> plines = DB.GetInstance().Fetch <ProductLineEntity>("where pline_code in (select pline_code from REL_DEPT_PLINE where dept_code=@0)", _dept);
ASPxComboBox1.DataSource = plines;
ASPxComboBox1.TextField = "PLINE_NAME";
ASPxComboBox1.ValueField = "PLINE_CODE";
ASPxComboBox1.DataBind();
if (ASPxComboBox1.SelectedItem == null)
{
return;
}
string pline = ASPxComboBox1.SelectedItem.Value.ToString();
List <StationEntity> stations = StationFactory.GetByProductLine(pline);
ASPxComboBox2.DataSource = stations;
ASPxComboBox2.TextField = "STATION_NAME";
ASPxComboBox2.ValueField = "WORKUNIT_CODE";
ASPxComboBox2.DataBind();
string workunit = "";
if (ASPxComboBox2.SelectedItem != null)
{
workunit = ASPxComboBox2.SelectedItem.Value.ToString();
}
Report_Exp2200 report = new Report_Exp2200(ASPxComboBox1.SelectedItem.Value.ToString(), workunit, ASPxDateEdit1.Date, ASPxDateEdit2.Date);
ReportViewer1.Report = report;
}
protected void Page_Load(object sender, EventArgs e)
{
ASPxComboBox1.DataBind();
}
protected void Page_Init(object sender, EventArgs e)
{
ASPxComboBox1.DataSource = ThemesProvider.GetThemes();
ASPxComboBox1.DataBind();
}
