//清除条件
private void clearCondition()
{
//领料单编号
TextBoxOrderCode.Text = string.Empty;
//加工单位
TextBoxSupplier.Text = string.Empty;
TextBoxClerk.Text = string.Empty;
TextBoxDate.Text = string.Empty;
TextBoxCode.Text = string.Empty;
TextBoxName.Text = string.Empty;
TextBoxStandard.Text = string.Empty;
TextBoxPTC.Text = string.Empty;
TextBoxAnum.Text = string.Empty;
TextBoxBSHNUM.Text = string.Empty;
TextBoxcaizhi.Text = string.Empty;
TextBoxJhuo.Text = string.Empty;
TextBoxPlanTyple.Text = string.Empty;
TextBoxDep.Text = string.Empty;
TextBoxDnum.Text = string.Empty;
TextBoxgb.Text = string.Empty;
DropDownListOrderState.ClearSelection();
DropDownListOrderState.Items[1].Selected = true;
DropDownListPushState.ClearSelection();
DropDownListPushState.Items[1].Selected = true;
DropDownListFatherLogic.ClearSelection();
DropDownListFatherLogic.Items[0].Selected = true;
DropDownListQCResult.ClearSelection();
DropDownListQCResult.Items[0].Selected = true;
}
private string GetCondition()
{
//总表，从表都不等于0
string condition = "1=1";
string QRcondition = "";
//订单状态
if ((DropDownListOrderState.SelectedValue == "0") && (DropDownListPushState.SelectedValue == "0"))
{
//全部
condition = " totalstate='1' AND detailstate<>'0' ";
addQueryItem(PageName, "DropDownListOrderState", DropDownListOrderState.GetType().ToString(), DropDownListOrderState.SelectedValue);
addQueryItem(PageName, "DropDownListPushState", DropDownListPushState.GetType().ToString(), DropDownListPushState.SelectedValue);
}
else if ((DropDownListOrderState.SelectedValue == "0") && (DropDownListPushState.SelectedValue == "1"))
{
condition = " totalstate='1' AND (detailstate='1' or detailstate='3') and detailcstate='0' ";
addQueryItem(PageName, "DropDownListOrderState", DropDownListOrderState.GetType().ToString(), DropDownListOrderState.SelectedValue);
addQueryItem(PageName, "DropDownListPushState", DropDownListPushState.GetType().ToString(), DropDownListPushState.SelectedValue);
}
else if ((DropDownListOrderState.SelectedValue == "0") && (DropDownListPushState.SelectedValue == "2"))
{
condition = " totalstate='1' AND detailstate='2' and detailcstate='0' ";
addQueryItem(PageName, "DropDownListOrderState", DropDownListOrderState.GetType().ToString(), DropDownListOrderState.SelectedValue);
addQueryItem(PageName, "DropDownListPushState", DropDownListPushState.GetType().ToString(), DropDownListPushState.SelectedValue);
}
else if ((DropDownListOrderState.SelectedValue == "0") && (DropDownListPushState.SelectedValue == "3"))
{
condition = " totalstate='1' AND detailstate='1' and detailcstate='1' ";
addQueryItem(PageName, "DropDownListOrderState", DropDownListOrderState.GetType().ToString(), DropDownListOrderState.SelectedValue);
addQueryItem(PageName, "DropDownListPushState", DropDownListPushState.GetType().ToString(), DropDownListPushState.SelectedValue);
}
else if ((DropDownListOrderState.SelectedValue == "1") && (DropDownListPushState.SelectedValue == "0"))
{
//订单采购中，明细全部
condition = " totalstate='1' and totalcstate='0' AND detailstate<>'0' ";
addQueryItem(PageName, "DropDownListOrderState", DropDownListOrderState.GetType().ToString(), DropDownListOrderState.SelectedValue);
addQueryItem(PageName, "DropDownListPushState", DropDownListPushState.GetType().ToString(), DropDownListPushState.SelectedValue);
}
else if ((DropDownListOrderState.SelectedValue == "1") && (DropDownListPushState.SelectedValue == "1"))
{
//订单采购中，明细采购中
condition = " totalstate='1' and totalcstate='0' AND (detailstate='1' or detailstate='3') and detailcstate='0'";
addQueryItem(PageName, "DropDownListOrderState", DropDownListOrderState.GetType().ToString(), DropDownListOrderState.SelectedValue);
addQueryItem(PageName, "DropDownListPushState", DropDownListPushState.GetType().ToString(), DropDownListPushState.SelectedValue);
}
else if ((DropDownListOrderState.SelectedValue == "1") && (DropDownListPushState.SelectedValue == "2"))
{
//订单采购中，明细采购完毕
condition = " totalstate='1' and totalcstate='0' AND detailstate='2' and detailcstate='0'";
addQueryItem(PageName, "DropDownListOrderState", DropDownListOrderState.GetType().ToString(), DropDownListOrderState.SelectedValue);
addQueryItem(PageName, "DropDownListPushState", DropDownListPushState.GetType().ToString(), DropDownListPushState.SelectedValue);
}
else if ((DropDownListOrderState.SelectedValue == "1") && (DropDownListPushState.SelectedValue == "3"))
{
//订单采购中，明细采购手动关闭
condition = " totalstate='1' and totalcstate='0' AND detailstate='1' and detailcstate='1'";
addQueryItem(PageName, "DropDownListOrderState", DropDownListOrderState.GetType().ToString(), DropDownListOrderState.SelectedValue);
addQueryItem(PageName, "DropDownListPushState", DropDownListPushState.GetType().ToString(), DropDownListPushState.SelectedValue);
}
else if ((DropDownListOrderState.SelectedValue == "2") && (DropDownListPushState.SelectedValue == "0"))
{
//订单采购完毕，明细全部
condition = " totalstate='3' and totalcstate='0' AND detailstate<>'0' ";
addQueryItem(PageName, "DropDownListOrderState", DropDownListOrderState.GetType().ToString(), DropDownListOrderState.SelectedValue);
addQueryItem(PageName, "DropDownListPushState", DropDownListPushState.GetType().ToString(), DropDownListPushState.SelectedValue);
}
else if ((DropDownListOrderState.SelectedValue == "2") && (DropDownListPushState.SelectedValue == "1"))
{
//订单采购完毕，明细采购中
condition = " totalstate='3' and totalcstate='0' AND (detailstate='1' or detailstate='3') and detailcstate='0'";
addQueryItem(PageName, "DropDownListOrderState", DropDownListOrderState.GetType().ToString(), DropDownListOrderState.SelectedValue);
addQueryItem(PageName, "DropDownListPushState", DropDownListPushState.GetType().ToString(), DropDownListPushState.SelectedValue);
}
else if ((DropDownListOrderState.SelectedValue == "2") && (DropDownListPushState.SelectedValue == "2"))
{
//订单采购完毕，明细采购完毕
condition = " totalstate='3' and totalcstate='0' AND detailstate='2' and detailcstate='0'";
addQueryItem(PageName, "DropDownListOrderState", DropDownListOrderState.GetType().ToString(), DropDownListOrderState.SelectedValue);
addQueryItem(PageName, "DropDownListPushState", DropDownListPushState.GetType().ToString(), DropDownListPushState.SelectedValue);
}
else if ((DropDownListOrderState.SelectedValue == "2") && (DropDownListPushState.SelectedValue == "3"))
{
//订单采购完毕，明细手动关闭
condition = " totalstate='3' and totalcstate='0' AND detailstate='1' and detailcstate='1'";
addQueryItem(PageName, "DropDownListOrderState", DropDownListOrderState.GetType().ToString(), DropDownListOrderState.SelectedValue);
addQueryItem(PageName, "DropDownListPushState", DropDownListPushState.GetType().ToString(), DropDownListPushState.SelectedValue);
}
else if ((DropDownListOrderState.SelectedValue == "3") && (DropDownListPushState.SelectedValue == "0"))
{
//订单手动关闭，明细全部
condition = " totalstate='1' and totalcstate='1' AND detailstate<>'0' ";
addQueryItem(PageName, "DropDownListOrderState", DropDownListOrderState.GetType().ToString(), DropDownListOrderState.SelectedValue);
addQueryItem(PageName, "DropDownListPushState", DropDownListPushState.GetType().ToString(), DropDownListPushState.SelectedValue);
}
else if ((DropDownListOrderState.SelectedValue == "3") && (DropDownListPushState.SelectedValue == "1"))
{
//订单手动关闭，明细采购中
condition = " totalstate='1' and totalcstate='1' AND (detailstate='1' or detailstate='3') and detailcstate='0'";
addQueryItem(PageName, "DropDownListOrderState", DropDownListOrderState.GetType().ToString(), DropDownListOrderState.SelectedValue);
addQueryItem(PageName, "DropDownListPushState", DropDownListPushState.GetType().ToString(), DropDownListPushState.SelectedValue);
}
else if ((DropDownListOrderState.SelectedValue == "3") && (DropDownListPushState.SelectedValue == "2"))
{
//订单手动关闭，明细采购完毕
condition = " totalstate='1' and totalcstate='1' AND detailstate='2' and detailcstate='0'";
addQueryItem(PageName, "DropDownListOrderState", DropDownListOrderState.GetType().ToString(), DropDownListOrderState.SelectedValue);
addQueryItem(PageName, "DropDownListPushState", DropDownListPushState.GetType().ToString(), DropDownListPushState.SelectedValue);
}
else if ((DropDownListOrderState.SelectedValue == "3") && (DropDownListPushState.SelectedValue == "3"))
{
//订单手动关闭，明细手动关闭
condition = " totalstate='1' and totalcstate='1' AND detailstate='1' and detailcstate='1'";
addQueryItem(PageName, "DropDownListOrderState", DropDownListOrderState.GetType().ToString(), DropDownListOrderState.SelectedValue);
addQueryItem(PageName, "DropDownListPushState", DropDownListPushState.GetType().ToString(), DropDownListPushState.SelectedValue);
}
//订单号条件
if (TextBoxOrderCode.Text != "")
{
condition += " AND orderno LIKE '%" + TextBoxOrderCode.Text.Trim().PadLeft(8, '0') + "%'";
addQueryItem(PageName, "TextBoxOrderCode", TextBoxOrderCode.GetType().ToString(), TextBoxOrderCode.Text.Trim());
}
//供应商条件
if ((TextBoxSupplier.Text != "") && (condition != ""))
{
condition += " AND " + " suppliernm LIKE '%" + TextBoxSupplier.Text.Trim() + "%'";
addQueryItem(PageName, "TextBoxSupplier", TextBoxSupplier.GetType().ToString(), TextBoxSupplier.Text.Trim());
}
//部门条件
if ((TextBoxDep.Text != "") && (condition != ""))
{
condition += " AND " + " depnm LIKE'%" + TextBoxDep.Text.Trim() + "%'";
addQueryItem(PageName, "TextBoxDep", TextBoxDep.GetType().ToString(), TextBoxDep.Text.Trim());
}
//业务员条件
if ((TextBoxClerk.Text != "") && (condition != ""))
{
condition += " AND " + " ywynm LIKE'%" + TextBoxClerk.Text.Trim() + "%'";
addQueryItem(PageName, "TextBoxClerk", TextBoxClerk.GetType().ToString(), TextBoxClerk.Text.Trim());
}
//下单日期条件
if ((TextBoxDate.Text != "") && (condition != ""))
{
condition += " AND " + " shtime LIKE '%" + TextBoxDate.Text.Trim() + "%'";
addQueryItem(PageName, "TextBoxDate", TextBoxDate.GetType().ToString(), TextBoxDate.Text.Trim());
}
//交货日期
if ((TextBoxJhuo.Text != "") && (condition != ""))
{
condition += " AND " + " recdate LIKE '%" + TextBoxJhuo.Text.Trim() + "%'";
addQueryItem(PageName, "TextBoxJhuo", TextBoxJhuo.GetType().ToString(), TextBoxJhuo.Text.Trim());
}
//物料编码条件
if ((TextBoxCode.Text != "") && (condition != ""))
{
condition += " AND " + " marid LIKE '%" + TextBoxCode.Text.Trim() + "%'";
addQueryItem(PageName, "TextBoxCode", TextBoxCode.GetType().ToString(), TextBoxCode.Text.Trim());
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
if (DropDownListPlanno.SelectedValue != "1")
{
QRcondition += " and marid like '%" + TextBoxCode.Text.Trim() + "%'";
}
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
}
//物料名称条件
if ((TextBoxName.Text != "") && (condition != ""))
{
condition += " AND " + " marnm LIKE '%" + TextBoxName.Text.Trim() + "%'";
addQueryItem(PageName, "TextBoxName", TextBoxName.GetType().ToString(), TextBoxName.Text.Trim());
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
if (DropDownListPlanno.SelectedValue != "1")
{
QRcondition += " and marnm like '%" + TextBoxName.Text.Trim() + "%'";
}
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
}
//规格型号条件
if ((TextBoxStandard.Text != "") && (condition != ""))
{
condition += " AND " + " margg LIKE '%" + TextBoxStandard.Text.Trim() + "%'";
addQueryItem(PageName, "TextBoxStandard", TextBoxStandard.GetType().ToString(), TextBoxStandard.Text.Trim());
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
if (DropDownListPlanno.SelectedValue != "1")
{
QRcondition += " and margg like '%" + TextBoxStandard.Text.Trim() + "%'";
}
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
}
//计划跟踪号条件
if ((TextBoxPTC.Text != "") && (condition != ""))
{
condition += " AND patindex('%" + TextBoxPTC.Text.Trim() + "%',ptcode)>0";
addQueryItem(PageName, "TextBoxPTC", TextBoxPTC.GetType().ToString(), TextBoxPTC.Text.Trim());
}
//材质
if ((TextBoxcaizhi.Text != "") && (condition != ""))
{
condition += " AND " + " marcz LIKE '%" + TextBoxcaizhi.Text.Trim() + "%'";
addQueryItem(PageName, "TextBoxcaizhi", TextBoxcaizhi.GetType().ToString(), TextBoxcaizhi.Text.Trim());
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
if (DropDownListPlanno.SelectedValue != "1")
{
QRcondition += " and marcz like '%" + TextBoxcaizhi.Text.Trim() + "%'";
}
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
}
//国标
if ((TextBoxgb.Text != "") && (condition != ""))
{
condition += " AND " + " margb LIKE '%" + TextBoxgb.Text.Trim() + "%'";
addQueryItem(PageName, "TextBoxgb", TextBoxgb.GetType().ToString(), TextBoxgb.Text.Trim());
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
if (DropDownListPlanno.SelectedValue != "1")
{
QRcondition += " and margb like '%" + TextBoxgb.Text.Trim() + "%'";
}
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
}
//订货数量
if ((TextBoxDnum.Text != "") && (condition != ""))
{
condition += " AND " + " zxnum LIKE '%" + TextBoxDnum.Text.Trim() + "%'";
addQueryItem(PageName, "TextBoxDnum", TextBoxDnum.GetType().ToString(), TextBoxDnum.Text.Trim());
}
//到货数量
if ((TextBoxAnum.Text != "") && (condition != ""))
{
condition += " AND " + " recgdnum LIKE '%" + TextBoxAnum.Text.Trim() + "%'";
addQueryItem(PageName, "TextBoxAnum", TextBoxAnum.GetType().ToString(), TextBoxAnum.Text.Trim());
}
//标识号
if ((TextBoxBSHNUM.Text != "") && (condition != ""))
{
condition += " AND " + " PO_TUHAO LIKE '%" + TextBoxBSHNUM.Text.Trim() + "%'";
addQueryItem(PageName, "TextBoxBSHNUM", TextBoxBSHNUM.GetType().ToString(), TextBoxBSHNUM.Text.Trim());
}
//计划类型
if ((TextBoxPlanTyple.Text != "") && (condition != ""))
{
condition += " AND " + " PO_MASHAPE LIKE '%" + TextBoxPlanTyple.Text.Trim() + "%'";
addQueryItem(PageName, "TextBoxPlanTyple", TextBoxPlanTyple.GetType().ToString(), TextBoxPlanTyple.Text.Trim());
}
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
//是否入库（即是否生成入库单）
if ((DropDownListQRInState.SelectedValue != "") && (condition != ""))
{
condition += " AND " + " QRIn_State='" + DropDownListQRInState.SelectedValue + "'";
addQueryItem(PageName, "DropDownListQRInState", DropDownListQRInState.GetType().ToString(), DropDownListQRInState.SelectedValue);
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
QRcondition += " and QRIn_State='" + DropDownListQRInState.SelectedValue + "'";
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
}
if ((DropDownListQRInState.SelectedValue == "") && (condition != ""))
{
condition += " AND " + " (QRIn_State='0' or QRIn_State='1')";
addQueryItem(PageName, "DropDownListQRInState", DropDownListQRInState.GetType().ToString(), DropDownListQRInState.SelectedValue);
}
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
//质检结果
if ((DropDownListQCResult.SelectedValue != "all") && (condition != ""))
{
if (DropDownListQCResult.SelectedValue.ToString().Trim() == "合格")
{
condition += " AND " + " (RESULT='" + DropDownListQCResult.SelectedValue + "' or RESULT='免检')";
}
else
{
condition += " AND " + " RESULT='" + DropDownListQCResult.SelectedValue + "'";
}
}
if (DropDownListPlanno.SelectedValue == "1")
{
condition = condition;
}
else
{
condition = condition + " or ((QRIn_PTC is null or QRIn_PTC='')" + QRcondition + ")";
}
return(condition);
}
