public void BindWare(DropDownList ddlWare) { using (LWareBB wareBB = new LWareBB()) { DataSet ds = new DataSet(); ds = wareBB.GetList("isDel=0"); ddlWare.DataTextField = "wareNm"; ddlWare.DataValueField = "wareNo"; ddlWare.DataSource = ds.Tables[0]; ddlWare.DataBind(); ddlWare.Items.Insert(0, new ListItem("-请选择-", "")); } }
/// <summary> /// 验证页面信息 /// </summary> /// <param name="strErrorInfo">错误提示信息</param> /// <returns></returns> private bool ValidateData(out string strErrorInfo) { LWareBB wareBB = new LWareBB(); try { strErrorInfo = ""; DataSet ds = new DataSet(); if (this.tbWareNo.Text.Trim() == "") { strErrorInfo = "请首先填写库区编码!"; this.tbWareNo.Focus(); return false; } //判断库区编码是否重复 ds = wareBB.GetList("wareNo='" + this.tbWareNo.Text.Trim().Replace("'", "''") + "' and id<>" + this.IdValue.ToString()); if (ds.Tables[0].Rows.Count > 0) { strErrorInfo = "库区编码重复!"; this.tbWareNo.Focus(); return false; } if (this.tbWareNm.Text.Trim() == "") { strErrorInfo = "请首先填写库区名称!"; this.tbWareNm.Focus(); return false; } if (this.ddlWareType.SelectedValue == "") { strErrorInfo = "请首先选择仓库类别!"; this.ddlWareType.Focus(); return false; } if (this.ddlWareSort.SelectedValue == "") { strErrorInfo = "请首先选择货位分类!"; this.ddlWareSort.Focus(); return false; } return true; } finally { wareBB.Dispose(); } }
public DataTable GetWareByWareNo(string strWareNo) { using (LWareBB wareBB = new LWareBB()) { DataSet ds = new DataSet(); string strWhere = "wareNo='" + strWareNo + "'"; ds = wareBB.GetList(strWhere); return ds.Tables[0]; } }
public bool IsWareLocatorUsing(string strWareLocatorNo) { LWareLocatorBB wareLocatorBB = new LWareLocatorBB(); LWareBB wareBB = new LWareBB(); try { DataTable dtWare = new DataTable(); DataTable dtWareLocator = new DataTable(); dtWare = wareBB.GetList("wareNo='" + strWareLocatorNo + "'").Tables[0];//获取库区 dtWareLocator = wareLocatorBB.GetVList("wareLocatorNo='" + strWareLocatorNo + "'").Tables[0];//获取库位 //如果扫描的为库区,返回true if (dtWare.Rows.Count > 0) { return false; } //判断库位是否正在使用 if (dtWareLocator.Rows.Count == 0) { return true; } else if (dtWareLocator.Rows[0]["wareType"].ToString() == "07" || dtWareLocator.Rows[0]["isUsing"] == DBNull.Value || Convert.ToBoolean(dtWareLocator.Rows[0]["isUsing"]) == false) { return false; } else { return true; } } finally { wareLocatorBB.Dispose(); wareBB.Dispose(); } }
public DataTable GetWare(string strWareType) { using (LWareBB wareBB = new LWareBB()) { DataSet ds = new DataSet(); string strWhere = "isDel=0"; if (strWareType != "") { strWhere += " and wareType='" + strWareType + "'"; } ds = wareBB.GetList(strWhere); return ds.Tables[0]; } }