public string remoteCheck(CheckExits model) { Sql sql = new NPoco.Sql(string.Format("select count(1) from {0} where {1}='{2}'", model.TableName, model.ValidField, model.ValidValue)); if (!string.IsNullOrEmpty(model.DataID)) { sql.Append(string.Format(" and {0}<>'{1}' ", model.KeyField, model.DataID)); } if (model.Filter != null) { sql.Append(ConditionParser.Serialize(model.Filter)); } if (this.Db.Single <long>(sql) > 0) { return(string.Format("{0}的值已存在", model.Label)); } return(""); // }
public string remoteCheck(CheckExits model, string frmID, string dataModelID) { Sql sql = new NPoco.Sql(string.Format("select count(1) from {0} where {1}='{2}'", model.TableName, model.ValidField, model.ValidValue)); if (!string.IsNullOrEmpty(model.DataID)) { sql.Append(string.Format(" and {0}<>'{1}' ", model.KeyField, model.DataID)); } if (model.Filter != null) { sql.Append(ConditionParser.Serialize(model.Filter)); } var ds = DataModelCom.getDataSource(dataModelID, this.Db); Database ywdb = DataBaseManger.GetDB(ds); if (ywdb.Single <long>(sql) > 0) { return(string.Format("{0}的值已存在", model.Label)); } return(""); }
public Sql <T> On(string onClause, params object[] args) { _sql.Append("ON " + onClause, args); return(_sql); }
public Sql On(string onClause, params object[] args) { return(_sql.Append("ON " + onClause, args)); }