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