Ejemplo n.º 1
0
        /// <summary>
        /// 修改工单BOM表
        /// </summary>
        /// <param name="obj">Model_T_Bllb_wocodeBom_tbwb对象</param>
        /// <returns></returns>
        public static bool Update_Bom(Model_Bllb_wocodeBom_tbwb obj)
        {
            string strSql = string.Format(@"UPDATE T_Bllb_wocodeBom_tbwb SET
                                        BOM_QTY='{1}',WoCode='{2}'
                                        where
                                        TBWB_ID='{0}'
                                        ",
                                          obj.TBWB_ID,
                                          obj.BOM_QTY,
                                          obj.WoCode);

            return(CIT.Wcf.Utils.NMS.ExecTransql(CIT.MES.PubUtils.uContext, strSql));
        }
Ejemplo n.º 2
0
        /// <summary>
        /// 添加工单BOM表
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public static bool Insert_Bom(Model_Bllb_wocodeBom_tbwb obj)
        {
            string strSql = string.Format(@"INSERT INTO T_Bllb_wocodeBom_tbwb(
                                        TBWB_ID,WoCode,MaterialCode,
                                        BOM_QTY)
                                        VALUES( 
                                        '{0}',
                                        '{1}',
                                        '{2}',
                                        '{3}')",
                                          obj.TBWB_ID,
                                          obj.WoCode,
                                          obj.MaterialCode,
                                          obj.BOM_QTY);

            return(CIT.Wcf.Utils.NMS.ExecTransql(CIT.MES.PubUtils.uContext, strSql));
        }