protected virtual Dictionary <string, object> GetParm(CrParameter argsInfo) { var data = new Dictionary <string, object>(); var args = argsInfo.SendContent; if (!string.IsNullOrEmpty(args)) { data["cargs"] = args; } data["ruleId"] = SelectedRuleId; data["num"] = argsInfo.UseNum.ToString(CultureInfo.InvariantCulture); return(data); }
/// <summary> /// 获取选择的参数 /// </summary> /// <param name="cArgs"></param> /// <returns></returns> protected CrParameter AnalyzeArgs(IDictionary <string, ItemData> cArgs) { var args = ""; var sign = ""; if (cArgs.ContainsKey(AllField)) { cArgs.Remove(AllField); } var crparam = new CrParameter(args); foreach (var pair in cArgs) { var createData = pair.Value; var view = createData.View; if (view != null) { var state = view.IsValid(); if (!state) { continue; } } else { if (createData.Type != RuleItemType.none) { continue; } } var key = createData.Key; if (key == AllField) { continue; } crparam.AddKeyIfSpecial(key, createData.Value); args = string.Format("{0}{1}{2},{3}", args, sign, createData.Id, createData.Value); sign = ","; var expnum = createData.UseNum; if (expnum <= 0) { continue; } crparam.UseNum = expnum; crparam.UseTyp = createData.UseItem; } YxDebug.Log(args); crparam.SendContent = args; return(crparam); }
public static void Insert(Entity e) { string insertSql = "insert into [{0}]({1}) values({2})"; StringBuilder sbColumns = new StringBuilder(); StringBuilder sbParameters = new StringBuilder(); EntitySchema schema = EntitySchemaList.Instance.GetSchema(e.Name); using (DbManager db = new DbManager()) { foreach (EntityColumnSchema columnSchema in schema.Columns) { if (columnSchema.IsAutoInc) { continue; } sbColumns.Append(columnSchema.Name); if (columnSchema.IsML) { //string lanCode =GetLanguagePostFix(); sbColumns.Append("_EN"); } sbColumns.Append(","); sbParameters.Append("~"); sbParameters.Append(columnSchema.Name); sbParameters.Append(","); CrParameter p = new CrParameter(); p.Name = columnSchema.Name; p.Size = columnSchema.Size; p.Type = columnSchema.Type; p.Value = e.Get <object>(columnSchema.Name); db.Parameters.Add(p); } insertSql = string.Format(insertSql, schema.Name, sbColumns.ToString().TrimEnd(','), sbParameters.ToString().TrimEnd(',')); db.ExecuteNonQuery(insertSql); } }