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); }
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); }