private void DataBindGridview()
{
//绑定表数据
List <WorkShopEntity> workShop = WorkShopFactory.GetUserWorkShops(theUserID);
string sql = "select * from vw_data_sn_process_union t where exists(select * from data_project a where t.PROJECT_CODE=a.project_code and a.workshop_id='" + workShop[0].RMES_ID + "')";
DataTable dt = dc.GetTable(sql);
ASPxGridView1.DataSource = dt;
//ASPxGridView1.DataSource = db.Fetch<SNProcessEntity>("where company_code=@0 order by pline_code", theCompanyCode);
GridViewDataComboBoxColumn col = ASPxGridView1.Columns["PLINE_CODE"] as GridViewDataComboBoxColumn;
col.PropertiesComboBox.DataSource = ProductLineFactory.GetByWorkShopID(workShop[0].RMES_ID);
col.PropertiesComboBox.ValueField = "RMES_ID";
col.PropertiesComboBox.TextField = "PLINE_NAME";
//GridViewDataComboBoxColumn col1 = ASPxGridView1.Columns["LOCATION_CODE"] as GridViewDataComboBoxColumn;
//col1.PropertiesComboBox.DataSource = db.Fetch<LocationEntity>("");
//col1.PropertiesComboBox.ValueField = "RMES_ID";
//col1.PropertiesComboBox.TextField = "LOCATION_NAME";
ASPxGridView1.DataBind();
}
private void setCondition()
{
//绑定表数据
ASPxGridView1.DataSource = WorkShopFactory.GetAll();
ASPxGridView1.DataBind();
}
private void setCondition()
{
//绑定表数据
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
string theUserId = theUserManager.getUserId();
List <WorkShopEntity> workShop = WorkShopFactory.GetUserWorkShops(theUserId);
ASPxGridView1.DataSource = LineSideStockFactory.GetByWorkShopID(workShop[0].RMES_ID);
GridViewDataComboBoxColumn col = ASPxGridView1.Columns["PLINE_CODE"] as GridViewDataComboBoxColumn;
col.PropertiesComboBox.DataSource = ProductLineFactory.GetAll();
col.PropertiesComboBox.ValueField = "RMES_ID";
col.PropertiesComboBox.TextField = "PLINE_NAME";
GridViewDataComboBoxColumn col1 = ASPxGridView1.Columns["LOCATION_CODE"] as GridViewDataComboBoxColumn;
col1.PropertiesComboBox.DataSource = db.Fetch <LocationEntity>("");
col1.PropertiesComboBox.ValueField = "RMES_ID";
col1.PropertiesComboBox.TextField = "LOCATION_NAME";
ASPxGridView1.DataBind();
}
protected void WorkshopCode_DataBinding(object sender, EventArgs e)
{
ASPxComboBox workshop = (ASPxComboBox)sender;
workshop.DataSource = WorkShopFactory.GetAll();
workshop.ValueField = "WORKSHOP_CODE";
workshop.TextField = "WORKSHOP_NAME";
}
protected void ASPxGridView1_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
{
//判断当前记录是否可以删除
string strCode = e.Values["RMES_ID"].ToString();
WorkShopEntity entSub = WorkShopFactory.GetByNumber(strCode);
db.Delete(entSub);
setCondition();
e.Cancel = true;
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserID = theUserManager.getUserId();
List <WorkShopEntity> workShop = WorkShopFactory.GetUserWorkShops(theUserID);
string strWorkShop = workShop[0].RMES_ID;
string sql = "select PROJECT_CODE,PROJECT_CODE||' | '||PROJECT_NAME as SHOWNAME from DATA_PROJECT WHERE STATUS='Y'and WORKSHOP_ID = '" + strWorkShop + "' order by project_code";
comboProject.DataSource = dc.GetTable(sql);
comboProject.DataBind();
}
private void initComboBoxByCompany()
{
initing = true;
object val = null;
val = comboBox1.SelectedValue;
try
{
if (val != null)
{
comboBox2.DataSource = ProductLineFactory.GetByCompanyCode(val.ToString());
comboBox2.SelectedValue = DB.ReadConfigLocal("PRODUCTLINE_CODE");
setComboxBoxCurrent(comboBox2);
val = comboBox2.SelectedValue;
if (val != null)
{
comboBox3.DataSource = StationFactory.GetByProductLine(val.ToString());
}
else
{
List <StationEntity> stas = StationFactory.GetAll();
var sta1 = from ss in stas
where ss.COMPANY_CODE == LoginInfo.CompanyInfo.COMPANY_CODE
select ss;
comboBox3.DataSource = sta1.ToList <StationEntity>();
}
comboBox6.SelectedValue = DB.ReadConfigLocal("WORKSHOP_CODE");
comboBox6.DataSource = WorkShopFactory.GetAll();
setComboxBoxCurrent(comboBox6);
comboBox3.SelectedValue = DB.ReadConfigLocal("STATION_CODE");
setComboxBoxCurrent(comboBox3);
comboBox4.DataSource = ShiftFactory.GetAll();
comboBox4.SelectedValue = DB.ReadConfigLocal("SHIFT_CODE");
setComboxBoxCurrent(comboBox4);
comboBox5.DataSource = TeamFactory.GetByPlineCode(val.ToString());
comboBox5.SelectedValue = DB.ReadConfigLocal("TEAM_CODE");
setComboxBoxCurrent(comboBox5);
}
}
catch
{
}
initing = false;
}
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
//修改记录
string strCode = e.OldValues["RMES_ID"].ToString();
WorkShopEntity entSub = WorkShopFactory.GetByNumber(strCode);
entSub.WORKSHOP_CODE = e.NewValues["WORKSHOP_CODE"].ToString();
entSub.WORKSHOP_NAME = e.NewValues["WORKSHOP_NAME"].ToString();
entSub.WORKSHOP_ADDRESS = e.NewValues["WORKSHOP_ADDRESS"].ToString();
db.Update(entSub);
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
private void setCondition()
{
//绑定表数据
string sql = "select * from REL_WORKSHOP_PLINE where pline_code in (select pline_code from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "') order by workshop_code";
DataTable dt = dc.GetTable(sql);
ASPxGridView1.DataSource = dt;
GridViewDataComboBoxColumn col = ASPxGridView1.Columns["PLINE_CODE"] as GridViewDataComboBoxColumn;
col.PropertiesComboBox.DataSource = ProductLineFactory.GetByUserID(theUserId, theProgramCode);
col.PropertiesComboBox.ValueField = "PLINE_CODE";
col.PropertiesComboBox.TextField = "PLINE_NAME";
ASPxComboBox plinecode = new ASPxComboBox();
GridViewDataComboBoxColumn col1 = ASPxGridView1.Columns["WORKSHOP_CODE"] as GridViewDataComboBoxColumn;
col1.PropertiesComboBox.DataSource = WorkShopFactory.GetAll();
col1.PropertiesComboBox.ValueField = "WORKSHOP_CODE";
col1.PropertiesComboBox.TextField = "WORKSHOP_NAME";
ASPxGridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theUserId = theUserManager.getUserId();
dt.Columns.Add("PROJECT_CODE");
dt.Columns.Add("ASSEMBLY_CODE");
dt.Columns.Add("TEAM_CODE");
dt.Columns.Add("ITEM_CODE");
dt.Columns.Add("ITEM_NAME");
dt.Columns.Add("PLAN_QTY");
dt.Columns.Add("SEND_QTY");
dt.Columns.Add("RECEIVE_QTY");
dt.Columns.Add("CALCULATE_QTY");
if (!IsPostBack)
{
List <WorkShopEntity> workShop = WorkShopFactory.GetUserWorkShops(theUserId);
string strWorkShop = workShop[0].RMES_ID;
string sql = "select PROJECT_CODE,PROJECT_CODE||' | '||PROJECT_NAME as SHOWNAME from DATA_PROJECT WHERE STATUS='Y'and WORKSHOP_ID = '" + strWorkShop + "' order by project_code";
ASPxComboBoxProject.DataSource = dc.GetTable(sql);
ASPxComboBoxProject.TextField = "SHOWNAME";
ASPxComboBoxProject.ValueField = "PROJECT_CODE";
ASPxComboBoxProject.DataBind();
List <TeamEntity> team = TeamFactory.GetByUserID(theUserId);
List <TeamEntity> orderTeam = (from c in team orderby c.TEAM_NAME select c).ToList <TeamEntity>();
ASPxComboBoxTeam.DataSource = orderTeam;
ASPxComboBoxTeam.TextField = "TEAM_NAME";
ASPxComboBoxTeam.ValueField = "RMES_ID";
ASPxComboBoxTeam.DataBind();
ASPxComboBoxTeam.SelectedIndex = -1;
}
BindData();
}
protected void Page_Load(object sender, EventArgs e)
{
user = Session["theUserManager"] as userManager;
if (user == null)
{
Response.End();
}
userManager theUserManager = (userManager)Session["theUserManager"];
string theCompanyCode = theUserManager.getCompanyCode();
string theUserId = theUserManager.getUserId();
List <WorkShopEntity> workShop = WorkShopFactory.GetUserWorkShops(theUserId);
//ASPxGridView1.CustomColumnDisplayText += new DevExpress.Web.ASPxGridView.ASPxGridViewColumnDisplayTextEventHandler(ASPxGridView1_CustomColumnDisplayText);
GridViewDataComboBoxColumn column1 = (ASPxGridView1.Columns["LLXZZZ"] as GridViewDataComboBoxColumn);
{
column1.PropertiesComboBox.DataSource = UserFactory.GetAll();
column1.PropertiesComboBox.ValueField = "USER_CODE";
column1.PropertiesComboBox.TextField = "USER_NAME";
}
GridViewDataComboBoxColumn column2 = (ASPxGridView1.Columns["LLZPXZ"] as GridViewDataComboBoxColumn);
{
column2.PropertiesComboBox.DataSource = TeamFactory.GetByWorkShopID("CK_WS01");
column2.PropertiesComboBox.ValueField = "RMES_ID";
column2.PropertiesComboBox.TextField = "TEAM_NAME";
}
GridViewDataComboBoxColumn column3 = (ASPxGridView1.Columns["LLBS"] as GridViewDataComboBoxColumn);
{
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add("value");
dt.Columns.Add("text");
dt.Rows.Add("W", "新建");
dt.Rows.Add("N", "已发库房");
dt.Rows.Add("Y", "已领料");
dt.Rows.Add("E", "无价格");
column3.PropertiesComboBox.DataSource = dt;
column3.PropertiesComboBox.ValueField = "value";
column3.PropertiesComboBox.TextField = "text";
}
List <InterIssueEntity> allEntity = InterIssueFactory.GetByWorkShopCode("8101-B1");
GridViewDataComboBoxColumn colGZH = (ASPxGridView1.Columns["LLGZH"] as GridViewDataComboBoxColumn);
var a = ((from s in allEntity where !string.IsNullOrWhiteSpace(s.LLGZH) select s.LLGZH).Distinct()).ToList <string>();
colGZH.PropertiesComboBox.DataSource = a;
GridViewDataComboBoxColumn colGCH = (ASPxGridView1.Columns["LLGCH"] as GridViewDataComboBoxColumn);
var b = (from s in allEntity select s.LLGCH).Distinct().ToList <string>();;
colGCH.PropertiesComboBox.DataSource = b;
GridViewDataComboBoxColumn colZJDH = (ASPxGridView1.Columns["LLZJDH"] as GridViewDataComboBoxColumn);
var c = (from s in allEntity select s.LLZJDH).Distinct().ToList <string>();
for (int i = 0; i < c.Count; i++)
{
if (c[i] == null)
{
c[i] = "";
}
}
colZJDH.PropertiesComboBox.DataSource = c;
DataTable d = new DataTable();
d.Columns.Add("LLGCH");
d.Columns.Add("LLGZH");
d.Columns.Add("LLZJDH");
d.Columns.Add("LLXMDH");
d.Columns.Add("LLXMMC");
d.Columns.Add("LLSL");
d.Columns.Add("YSSL");
d.Columns.Add("LLRQ");
d.Columns.Add("LLCJRQ");
d.Columns.Add("LLZPXZ");
d.Columns.Add("LLXZZZ");
d.Columns.Add("PLAN_CODE");
d.Columns.Add("LLBS");
d.Columns.Add("TMBH");
foreach (InterIssueEntity i in allEntity)
{
List <IssueReceivedEntity> rs = IssueReceivedFactory.GetByDetailCode(i.TMBH);
float sum = 0;
foreach (IssueReceivedEntity r in rs)
{
sum += (int)r.ITEM_QTY;
}
d.Rows.Add(i.LLGCH, i.LLGZH, i.LLZJDH, i.LLXMDH, i.LLXMMC, i.LLSL, sum, i.LLRQ, i.LLCJRQ, i.LLZPXZ, i.LLXZZZ, i.PLAN_CODE, i.LLBS, i.TMBH);
}
ASPxGridView1.DataSource = d;
ASPxGridView1.DataBind();
//用后台的配置开关，设置是否允许手动添加要料单，在code_config_system中
if (DB.ReadConfigServer("INV2300_ALLOW_MANUAL_ADD").Equals("FALSE"))
{
btnNewBill.Visible = false;
}
else
{
btnNewBill.Visible = true;
ASPxComboBox cbGCH = ASPxPopupControl1.FindControl("LLGCH") as ASPxComboBox;
if (cbGCH != null)
{
List <WorkShopEntity> workshops = WorkShopFactory.GetUserWorkShops(user.getUserId());
List <ProjectEntity> projects = new List <ProjectEntity>();
foreach (WorkShopEntity w in workshops)
{
projects.AddRange(ProjectFactory.GetByWorkShop(w.RMES_ID));
}
foreach (ProjectEntity p in projects)
{
cbGCH.Items.Add(p.PROJECT_CODE + " | " + p.PROJECT_NAME, p.PROJECT_CODE);
}
cbGCH.ClientSideEvents.SelectedIndexChanged = "function(s,e){ initWorkCode(s.GetValue().toString());}";
ASPxComboBox cbGZH = ASPxPopupControl1.FindControl("LLGZH") as ASPxComboBox;
if (cbGZH != null)
{
cbGZH.Callback += new DevExpress.Web.ASPxClasses.CallbackEventHandlerBase(cbGZH_Callback);
}
cbGCH.SelectedIndexChanged += new EventHandler(cbGCH_SelectedIndexChanged);
}
ASPxComboBox cbTeam = ASPxPopupControl1.FindControl("LLZPXZ") as ASPxComboBox;
if (cbTeam != null)
{
List <TeamEntity> teams = TeamFactory.GetByUserID(user.getUserId());
foreach (TeamEntity t in teams)
{
cbTeam.Items.Add(t.TEAM_NAME, t.TEAM_CODE);
}
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
ASPxComboBox cbGCH = ASPxPopupControl1.FindControl("LLGCH") as ASPxComboBox;
if (cbGCH == null)
{
return;
}
ASPxComboBox cbGZH = ASPxPopupControl1.FindControl("LLGZH") as ASPxComboBox;
if (cbGZH == null)
{
return;
}
ASPxTextBox txtPGDH = ASPxPopupControl1.FindControl("LLPGDH") as ASPxTextBox;
if (txtPGDH == null)
{
return;
}
ASPxTextBox txtXMDH = ASPxPopupControl1.FindControl("LLXMDH") as ASPxTextBox;
if (txtXMDH == null)
{
return;
}
ASPxTextBox txtXMMC = ASPxPopupControl1.FindControl("LLXMMC") as ASPxTextBox;
if (txtXMMC == null)
{
return;
}
ASPxTextBox txtLLSL = ASPxPopupControl1.FindControl("LLSL") as ASPxTextBox;
if (txtLLSL == null)
{
return;
}
ASPxComboBox cbTEAM = ASPxPopupControl1.FindControl("LLZPXZ") as ASPxComboBox;
if (cbTEAM == null)
{
return;
}
ASPxDateEdit cbLLRQ = ASPxPopupControl1.FindControl("LYRQ") as ASPxDateEdit;
if (cbLLRQ == null)
{
return;
}
ASPxTextBox txtXMLX = ASPxPopupControl1.FindControl("LLXMLX") as ASPxTextBox;
if (txtXMLX == null)
{
return;
}
string project_code = cbGCH.SelectedItem.Value.ToString();
string work_code = cbGZH.SelectedItem.Value.ToString();
string billno = txtPGDH.Text;
string item_code = txtXMDH.Text;
string item_name = txtXMMC.Text;
int item_qty = Convert.ToInt32(txtLLSL.Text);
string team_cdoe = cbTEAM.SelectedItem.Value.ToString();
string llxmlx = txtXMLX.Text;
DateTime need_date = cbLLRQ.Date;
UserEntity u = UserFactory.GetByID(user.getUserId());
TeamEntity t = TeamFactory.GetByTeamCode(team_cdoe);
UserEntity leader = UserFactory.GetByUserCode(t.LEADER_CODE);
if (string.IsNullOrWhiteSpace(project_code) || string.IsNullOrWhiteSpace(work_code) || string.IsNullOrWhiteSpace(billno) ||
string.IsNullOrWhiteSpace(item_code) || string.IsNullOrWhiteSpace(team_cdoe) || string.IsNullOrWhiteSpace(item_name) ||
string.IsNullOrWhiteSpace(llxmlx))
{
return;
}
if (item_qty < 1 || item_qty > 999999)
{
return;
}
if ((need_date - DateTime.Now).TotalMinutes < 0)
{
return;
}
ProjectEntity project = ProjectFactory.GetByProjectCode(project_code);
List <WorkShopEntity> workshops = WorkShopFactory.GetUserWorkShops(user.getUserId());
if (workshops.Count > 0)
{
workshop = workshops[0];
}
else
{
return;
}
if (project != null)
{
string barCode = DB.GetInstance().ExecuteScalar <string>("select 'RMESL'||TRIM(TO_CHAR(SEQ_ISSUE_BARCODE.NEXTVAL,'0000000000')) from dual");
InterIssueEntity interEntity = new InterIssueEntity
{
LLGCH = project_code, //领料合同号
LLGZH = work_code, //领料工作号
LLCPXH = project.PRODUCT_SERIES, //领料产品型号
LLZJDH = "MANUAL", //领料组件代号
PLAN_CODE = "R" + billno, //领料派工单号 - 临改单
LLLYDW = workshop.WORKSHOP_CODE, //领用单位 - 车间
LLZPXZ = team_cdoe, //装配小组
LLXH = 1, //领料序号
LLXMDH = item_code, //项目代号 - 图号
LLLYPC = "1", //领用批次
LLSL = item_qty, //领料数量
LLCJYH = u.USER_CODE + "/" + u.USER_NAME, //单据创建人
LLCJRQ = DateTime.Now, //单据创建日期
LLNY = need_date.ToString("yyMM"), //领料年月
LLRQ = need_date, //领料日期
LLXMMC = item_name, //领料项目名称
TMBH = barCode, //领料条码编号
LLBS = "W", //领料标识
LLXZZZ = leader.USER_CODE + "/" + leader.USER_NAME,
LLSPYH = u.USER_CODE + "/" + u.USER_NAME,
LLR = leader.USER_CODE + "/" + leader.USER_NAME,
LLXMLX = llxmlx.ToUpper()
};
object obj = DB.GetInstance().Insert("INTER_ISSUE", "", false, interEntity);
if (obj.ToString().ToUpper().Equals("TRUE"))
{
Response.Write("<script>alert('添加成功！');</script>");
Response.Redirect(Request.Url.ToString());
}
}
}
