Пример #1
0
        public string GetRandNO(string TrustdeedNo)
        {
            boxNO = GeneralCommon.Gf_CodeFind(GeneralCommon.M_CN1, getSql);
            if (boxNO == "")
            {
                GeneralCommon.Gp_MsgBoxDisplay("该种类试样盒为空,请添加试样盒!", "", "");
                throw (new Exception());
                return("");
            }
            //更新样盒所处位置
            SetBoxPlace("2", boxNO, boxType);

            //更新样盒所装试样的委托单号
            string sqlstr = "UPDATE TF_SMP_BOX SET trustdeed_no =\'" + TrustdeedNo + "\'  WHERE  smp_box_no=\'" + boxNO + "\' And box_type =\'" + boxType + "\'";

            BaseManu.ExecSql(sqlstr);
            return(boxNO);
        }
Пример #2
0
        public static void SetBoxPlace(string bPlace, string bNo, string bType)
        {
            string sqlstr = "UPDATE TF_SMP_BOX SET box_place = \'" + bPlace + "\' WHERE  smp_box_no=\'" + bNo + "\' And box_type =\'" + bType + "\'";

            BaseManu.ExecSql(sqlstr);
        }