示例#1
0
    public static string SetLOCATE_SECTIONOnBlur(string strItem, string strPeriod, string strLOCATE_NO, string strLOCATE_SECTION, string strSTOCKTAKE_NO, string strONHD_QTY_CID)
    {
        string rtnValue = string.Empty;
        string strONHD_QTY = "0";


        IVMModel.IVM043_BCO BCO = new IVMModel.IVM043_BCO(ConntionDB);

        if ((strItem != "") && (strPeriod != "") && (strSTOCKTAKE_NO != "") && (strLOCATE_SECTION != ""))
        {
            ParameterList.Clear();
            ParameterList.Add(strSTOCKTAKE_NO);
            ParameterList.Add(strLOCATE_NO);
            ParameterList.Add(strLOCATE_SECTION);
            ParameterList.Add(strItem);
            ParameterList.Add(strPeriod);
            DataTable dt = BCO.CheckDETL(ParameterList);
            if (dt.Rows.Count > 0)
            {
                strONHD_QTY = dt.Rows[0]["onhd_qty"].ToString();
            }
        }
        rtnValue = strONHD_QTY_CID + ";" + strONHD_QTY;
        return rtnValue;
    }
示例#2
0
    public static string SetItemPeriodOnBlur(string strItem, string strPeriod, string strLOCATE_NO, string strLOCATE_SECTION, string strSTOCKTAKE_NO, string strItemName_CID, string strONHD_QTY_CID, string strErrMsg1_CID, string strErrMsg2_CID)
    {
        string rtnValue = string.Empty;
        string strErrMsg1 = string.Empty;
        string strErrMsg2 = string.Empty;
        string strONHD_QTY = "0";
        string strItemName = string.Empty;

        IVMModel.IVM043_BCO BCO = new IVMModel.IVM043_BCO(ConntionDB);

        if (strItem != "")
        {
            DataTable dtItem = BCO.CheckItem(strItem);
            if (dtItem.Rows.Count > 0)
            {
                strItemName = dtItem.Rows[0]["ITEM_NAME"].ToString();
                if (strPeriod != "")
                {
                    DataTable dtPeriod = BCO.CheckPeriod(strItem, strPeriod);
                    if (dtPeriod.Rows.Count > 0)
                    {
                        ParameterList.Clear();
                        ParameterList.Add(strSTOCKTAKE_NO);
                        ParameterList.Add(strLOCATE_NO);
                        ParameterList.Add(strLOCATE_SECTION);
                        ParameterList.Add(strItem);
                        ParameterList.Add(strPeriod);
                        DataTable dt = BCO.CheckDETL(ParameterList);
                        if (dt.Rows.Count > 0)
                        {
                            strONHD_QTY = dt.Rows[0]["onhd_qty"].ToString();
                        }
                    }
                    else
                    {
                        strErrMsg2 = "期別不存在";
                    }
                }
            }
            else
            {
                strErrMsg1 = "品號不存在";
            }
        }
        rtnValue = strErrMsg1_CID + ";" + strErrMsg1 + ";" + strErrMsg2_CID + ";" + strErrMsg2 + ";" + strItemName_CID + ";" + strItemName + ";" + strONHD_QTY_CID + ";" + strONHD_QTY;
        return rtnValue;
    }