示例#1
0
        public void UpdateBusinessData(string insCode, string businessCode, int flowSate)
        {
            WFBusinessCodeService service = new WFBusinessCodeService();
            WFBusinessCode        code    = (from c in service
                                             where c.BusinessCode == businessCode
                                             select c).FirstOrDefault <WFBusinessCode>();
            string sql = string.Format("UPDATE {0} SET {1} = {2} WHERE {3} = '{4}'", new object[] { code.LinkTable, code.StateField, flowSate, code.PrimaryField, insCode });

            base.ExcuteSql(sql);
        }
示例#2
0
        public bool IsReSubmit(string insCode, string businessCode)
        {
            WFBusinessCodeService service = new WFBusinessCodeService();
            WFBusinessCode        code    = (from c in service
                                             where c.BusinessCode == businessCode
                                             select c).FirstOrDefault <WFBusinessCode>();
            string         sql  = string.Format("SELECT {0} FROM {1} WHERE {2} = '{3}'", new object[] { code.StateField, code.LinkTable, code.PrimaryField, insCode });
            IList <object> list = base.ExcuteSql(sql);

            if ((list == null) || (list.Count == 0))
            {
                throw new Exception("提交错误");
            }
            string str2 = list[0].ToString();

            if ((!(str2 == "0") && !(str2 == "1")) && !(str2 == "-2"))
            {
                return(false);
            }
            return(true);
        }