protected void butSubmit_Click(object sender, EventArgs e) { try { SolutionModel model = new SolutionModel(); model.SlnName = txtDescption.Text.Trim(); model.Namespace = txtNamespace.Text.Trim(); model.RefNamespace = txtRefNamespace.Text.Trim(); model.GameID = Convert.ToInt32((string)txtGameID.Text); model.Url = txtUrl.Text.Trim(); model.SerUseScript = ddSerUseScript.Text; model.CliUseScript = ddCliUseScript.Text; model.RespContentType = ddResponseContentType.Text.ToInt(); model.IsDParam = ckIsDParam.Checked; if (DbDataLoader.Add(model) > 0) { BindData(); } } catch (Exception ex) { Page.RegisterStartupScript("", "<script language=javascript>alert('添加失败,填写重复!')</script>"); } }
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { try { int id = Convert.ToInt32((string)GridView1.DataKeys[e.RowIndex].Values[0].ToString()); string SlnName = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("SlnName")).Text; string Namespace = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("Namespace")).Text; string RefNamespace = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("RefNamespace")).Text; string url = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("Url")).Text; string gameid = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("gameid")).Text; SolutionModel mode = new SolutionModel(); mode.SlnID = id; mode.SlnName = SlnName; mode.Namespace = Namespace; mode.RefNamespace = RefNamespace; mode.Url = url; mode.GameID = Convert.ToInt32(gameid); if (DbDataLoader.Update(mode)) { GridView1.EditIndex = -1; BindData(); } } catch (Exception erro) { Response.Write("错误信息:" + erro.Message); } }
/// <summary> /// ɾ��һ������ /// </summary> public static bool Delete(SolutionModel model) { var command = _dbBaseProvider.CreateCommandStruct("Solutions", CommandMode.Delete); command.Filter = _dbBaseProvider.CreateCommandFilter(); command.Filter.Condition = _dbBaseProvider.FormatFilterParam("SlnID"); command.Filter.AddParam("SlnID", model.SlnID); command.Parser(); return _dbBaseProvider.ExecuteQuery(CommandType.Text, command.Sql, command.Parameters) > 0; }
public static int Add(SolutionModel model) { var command = _dbBaseProvider.CreateCommandStruct("Solutions", CommandMode.Insert); command.AddParameter("SlnName", model.SlnName); command.AddParameter("Namespace", model.Namespace); command.AddParameter("Url", model.Url); command.AddParameter("GameID", model.GameID); command.ReturnIdentity = true; command.Parser(); return _dbBaseProvider.ExecuteQuery(CommandType.Text, command.Sql, command.Parameters); }
public static bool Update(SolutionModel model) { var command = _dbBaseProvider.CreateCommandStruct("Solutions", CommandMode.Modify); command.AddParameter("SlnName", model.SlnName); command.AddParameter("Namespace", model.Namespace); command.AddParameter("RefNamespace", model.RefNamespace); command.AddParameter("Url", model.Url); command.AddParameter("GameID", model.GameID); command.Filter = _dbBaseProvider.CreateCommandFilter(); command.Filter.Condition = _dbBaseProvider.FormatFilterParam("SlnID"); command.Filter.AddParam("SlnID", model.SlnID); command.Parser(); return _dbBaseProvider.ExecuteQuery(CommandType.Text, command.Sql, command.Parameters) > 0; }
public static string FormatActionDefineTemp(string content, List<ContractModel> contractList, SolutionModel slnRecord) { string[] expressList = new string[] { "##FieldList##", "##Namespace##", "##RefNamespace##" }; foreach (string exp in expressList) { StringBuilder fieldBuilder = new StringBuilder(); fieldBuilder.Append(exp.Replace("##", "")); if (fieldBuilder.ToString() == "Namespace") { fieldBuilder.Remove(0, fieldBuilder.Length); fieldBuilder.Append(slnRecord == null ? "" : slnRecord.Namespace); } else if (fieldBuilder.ToString() == "RefNamespace") { fieldBuilder.Remove(0, fieldBuilder.Length); fieldBuilder.Append(slnRecord == null ? "" : slnRecord.RefNamespace); } else if (fieldBuilder.ToString() == "FieldList") { string currIndent = GetSpaceIndent(2, 0); fieldBuilder.Remove(0, fieldBuilder.Length); foreach (var contract in contractList) { fieldBuilder.Append("///<summary>"); fieldBuilder.Append(Environment.NewLine); fieldBuilder.Append(currIndent); fieldBuilder.AppendFormat("///{0}", contract.Descption); fieldBuilder.Append(Environment.NewLine); fieldBuilder.Append(currIndent); fieldBuilder.Append("///</summary>"); fieldBuilder.Append(Environment.NewLine); fieldBuilder.Append(currIndent); fieldBuilder.AppendFormat("public const Int16 Cst_Action{0} = {0};", contract.ID); fieldBuilder.Append(Environment.NewLine); fieldBuilder.Append(Environment.NewLine); fieldBuilder.Append(currIndent); } } content = content.Replace(exp, fieldBuilder.ToString()); } return content; }
protected void butSubmit_Click(object sender, EventArgs e) { try { SolutionModel model = new SolutionModel(); model.SlnName = txtDescption.Text.Trim(); model.Namespace = txtNamespace.Text.Trim(); model.RefNamespace = txtRefNamespace.Text.Trim(); model.GameID = Convert.ToInt32((string) txtGameID.Text); model.Url = txtUrl.Text.Trim(); if (DbDataLoader.Add(model) > 0) { Response.Redirect("SolutionsList.aspx"); } } catch(Exception ex) { Page.RegisterStartupScript("", "<script language=javascript>alert('添加失败,填写重复!')</script>"); } }
public static List<SolutionModel> GetSolution(Action<CommandFilter> match) { var command = _dbBaseProvider.CreateCommandStruct("Solutions", CommandMode.Inquiry); command.Columns = "SlnID,SlnName,Namespace,RefNamespace,Url,GameID"; command.OrderBy = "SlnID ASC"; command.Filter = _dbBaseProvider.CreateCommandFilter(); if (match != null) { match(command.Filter); } command.Parser(); var list = new List<SolutionModel>(); using (var reader = _dbBaseProvider.ExecuteReader(CommandType.Text, command.Sql, command.Parameters)) { while (reader.Read()) { SolutionModel model = new SolutionModel(); model.SlnID = reader["SlnID"].ToInt(); model.GameID = reader["GameID"].ToInt(); model.SlnName = reader["SlnName"].ToNotNullString(); model.Namespace = reader["Namespace"].ToNotNullString(); model.RefNamespace = reader["RefNamespace"].ToNotNullString(); model.Url = reader["Url"].ToNotNullString(); list.Add(model); } } return list; }
internal static string FormatPython(string content, List<ParamInfoModel> paramList, List<ParamInfoModel> reqParams, SolutionModel slnRecord, string title) { string[] expressList = new string[] { "##Description##", "##UrlParam##", "##getUrlElement##", "##actionResult##", "##buildPacket##" }; foreach (string exp in expressList) { StringBuilder fieldBuilder = new StringBuilder(); switch (exp) { case "##Description##": fieldBuilder.Append(title); break; case "##UrlParam##": { string currIndent = GetSpaceIndent(2, 0); foreach (var paramInfo in paramList) { FieldType fieldType = paramInfo.FieldType; if (FieldType.Record.Equals(fieldType) || FieldType.End.Equals(fieldType)) { continue; } if (paramInfo.ParamType == 1) { fieldBuilder.Append(currIndent); if (fieldType == FieldType.Byte || fieldType == FieldType.Int || fieldType == FieldType.Short || fieldType == FieldType.Long || fieldType == FieldType.UInt || fieldType == FieldType.UShort || fieldType == FieldType.ULong ) { fieldBuilder.Append(string.Format("self.{0} = 0", ToMemberVarName(paramInfo.Field))); } else if (fieldType == FieldType.String || fieldType == FieldType.Password) { fieldBuilder.Append(string.Format("self.{0} = ''", ToMemberVarName(paramInfo.Field))); } fieldBuilder.Append(Environment.NewLine); } } } break; case "##getUrlElement##": ReplacePythonCheckRequest(fieldBuilder, reqParams); break; case "##actionResult##": ReplacePythonAction(fieldBuilder, paramList); break; case "##buildPacket##": ReplacePythonBuildPacket(fieldBuilder, paramList); break; } content = content.Replace(exp, fieldBuilder.ToString()); } return content; }
/// <summary> /// 赋值模板 /// </summary> /// <param name="content"></param> /// <param name="paramList"></param> /// <param name="slnRecord"></param> /// <param name="title"></param> /// <param name="reqParams"></param> /// <returns></returns> public static string FormatTemp(string content, int contractId, List<ParamInfoModel> paramList, List<ParamInfoModel> reqParams, SolutionModel slnRecord, string title) { string[] expressList = new string[] { "##ID##", "##Description##", "##Field##", "##Namespace##", "##RefNamespace##" }; foreach (string exp in expressList) { StringBuilder fieldBuilder = new StringBuilder(); fieldBuilder.Append(exp.Replace("##", "")); if (fieldBuilder.ToString() == "ID") { fieldBuilder.Remove(0, fieldBuilder.Length); fieldBuilder.Append(contractId); } else if (fieldBuilder.ToString() == "Description") { fieldBuilder.Remove(0, fieldBuilder.Length); fieldBuilder.Append(title); } else if (fieldBuilder.ToString() == "Namespace") { fieldBuilder.Remove(0, fieldBuilder.Length); fieldBuilder.Append(slnRecord == null ? "" : slnRecord.Namespace); } else if (fieldBuilder.ToString() == "RefNamespace") { fieldBuilder.Remove(0, fieldBuilder.Length); fieldBuilder.Append(slnRecord == null ? "" : slnRecord.RefNamespace); } else if (fieldBuilder.ToString() == "Field") { int depth = 0; string listVar = "_dsItemList"; string className; int recordIndex = 0; int[] indexList = new int[forVarChars.Length]; fieldBuilder.Remove(0, fieldBuilder.Length); var list = new List<ParamInfoModel>(reqParams.Where(t => t.FieldType != FieldType.Void)); list.AddRange(paramList.Where(t => t.FieldType != FieldType.Void)); var classList = new List<StringBuilder>(); var classStack = new Stack<StringBuilder>(); StringBuilder memberBuilder = new StringBuilder(); foreach (var paramInfo in list) { string descp = paramInfo.Descption + paramInfo.Remark; string spaceString = GetSpaceIndent(2, depth); FieldType fieldType = paramInfo.FieldType; if (fieldType == FieldType.Void) continue; if (FieldType.Record.Equals(fieldType)) { if (depth < indexList.Length) { recordIndex = indexList[depth]; recordIndex++; indexList[depth] = recordIndex; } string memberName = string.IsNullOrEmpty(paramInfo.Field) ? listVar + "_" + recordIndex : paramInfo.Field + "List"; listVar = listVar + "_" + recordIndex; className = string.IsNullOrEmpty(paramInfo.Field) ? listVar.Replace("_dsItemList", "Class") : paramInfo.Field; //add class's member if (depth > 0) { var classMemberBuilder = classStack.Peek(); BuildMemberCodeByList(classMemberBuilder, GetSpaceIndent(2, depth), className, descp, memberName, true); } else { BuildMemberCodeByList(memberBuilder, spaceString, className, descp, memberName); } var classBuilder = new StringBuilder(); BuildClassCode(classBuilder, GetSpaceIndent(2, 0), descp, className); classBuilder.Append(GetSpaceIndent(1, 0)); classStack.Push(classBuilder); depth++; continue; } if (FieldType.End.Equals(fieldType)) { listVar = listVar.Substring(0, listVar.LastIndexOf('_')); var classMemberBuilder = classStack.Pop(); classMemberBuilder.AppendLine(""); classMemberBuilder.Append(GetSpaceIndent(2, 0)); classMemberBuilder.AppendLine("}"); classList.Add(classMemberBuilder); depth--; continue; } if (depth > 0) { var classMemberBuilder = classStack.Peek(); BuildMemberCode(classMemberBuilder, GetSpaceIndent(2, 1), paramInfo, true); continue; } BuildMemberCode(memberBuilder, spaceString, paramInfo); } fieldBuilder.AppendLine(); fieldBuilder.Append(GetSpaceIndent(2, 0)); fieldBuilder.AppendLine("#region class object"); foreach (var builder in classList) { fieldBuilder.Append(builder); fieldBuilder.AppendLine(); } fieldBuilder.Append(GetSpaceIndent(2, 0)); fieldBuilder.AppendLine("#endregion"); fieldBuilder.AppendLine(); fieldBuilder.Append(GetSpaceIndent(2, 0)); fieldBuilder.Append(memberBuilder); } content = content.Replace(exp, fieldBuilder.ToString()); } content = ReplaceCheckRequest(content, reqParams); content = ReplaceBuildPack(content, paramList); return content; }
public static string FormatLua(string content, int contractId, List<ParamInfoModel> responseParams, List<ParamInfoModel> requestParams, SolutionModel slnRecord, string title) { string[] expressList = new string[] { "##ID##", "##Description##", "##getUrlElement##", "##buildPacket##" }; foreach (string exp in expressList) { StringBuilder fieldBuilder = new StringBuilder(); switch (exp) { case "##ID##": fieldBuilder.Append(contractId); break; case "##Description##": fieldBuilder.Append(title); break; case "##getUrlElement##": ReplaceLuaCheckRequest(fieldBuilder, requestParams); break; case "##buildPacket##": ReplaceLuaBuildPacket(fieldBuilder, responseParams); break; } content = content.Replace(exp, fieldBuilder.ToString()); } return content; }
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { try { int id = Convert.ToInt32((string)GridView1.DataKeys[e.RowIndex].Values[0].ToString()); string SlnName = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("SlnName")).Text; string Namespace = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("Namespace")).Text; string RefNamespace = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("RefNamespace")).Text; string url = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("Url")).Text; string gameid = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("gameid")).Text; string SerUseScript = ((DropDownList)GridView1.Rows[e.RowIndex].FindControl("SerUseScript")).Text; string CliUseScript = ((DropDownList)GridView1.Rows[e.RowIndex].FindControl("CliUseScript")).Text; string RespContentType = ((DropDownList)GridView1.Rows[e.RowIndex].FindControl("RespContentType")).Text; bool IsDParam = ((CheckBox)GridView1.Rows[e.RowIndex].FindControl("IsDParam")).Checked; SolutionModel mode = new SolutionModel(); mode.SlnID = id; mode.SlnName = SlnName; mode.Namespace = Namespace; mode.RefNamespace = RefNamespace; mode.Url = url; mode.GameID = Convert.ToInt32(gameid); mode.SerUseScript = SerUseScript; mode.CliUseScript = CliUseScript; mode.RespContentType = RespContentType.ToInt(); mode.IsDParam = IsDParam; if (DbDataLoader.Update(mode)) { GridView1.EditIndex = -1; BindData(); } } catch (Exception erro) { Response.Write("错误信息:" + erro.Message); } }
/// <summary> /// 赋值模板 /// </summary> /// <param name="content"></param> /// <param name="paramList"></param> /// <param name="slnRecord"></param> /// <param name="title"></param> /// <param name="reqParams"></param> /// <returns></returns> public static string FormatTemp(string content, int contractId, List<ParamInfoModel> paramList, List<ParamInfoModel> reqParams, SolutionModel slnRecord, string title) { int n = 8; string[] expressList = new string[] { "##ID##", "##Description##", "##Field##", "##Namespace##", "##RefNamespace##" }; foreach (string exp in expressList) { StringBuilder fieldBuilder = new StringBuilder(); fieldBuilder.Append(exp.Replace("##", "")); if (fieldBuilder.ToString() == "ID") { fieldBuilder.Remove(0, fieldBuilder.Length); fieldBuilder.Append(contractId); } else if (fieldBuilder.ToString() == "Description") { fieldBuilder.Remove(0, fieldBuilder.Length); fieldBuilder.Append(title); } else if (fieldBuilder.ToString() == "Namespace") { fieldBuilder.Remove(0, fieldBuilder.Length); fieldBuilder.Append(slnRecord == null ? "" : slnRecord.Namespace); } else if (fieldBuilder.ToString() == "RefNamespace") { fieldBuilder.Remove(0, fieldBuilder.Length); fieldBuilder.Append(slnRecord == null ? "" : slnRecord.RefNamespace); } else if (fieldBuilder.ToString() == "Field") { fieldBuilder.Remove(0, fieldBuilder.Length); var list = new List<ParamInfoModel>(reqParams); list.AddRange(paramList); foreach (var paramInfo in list) { FieldType fieldType = paramInfo.FieldType; if (FieldType.Record.Equals(fieldType) || FieldType.End.Equals(fieldType)) { continue; } fieldBuilder.Append("private "); fieldBuilder.Append(fieldType.ToString().ToLower()); fieldBuilder.Append(" "); fieldBuilder.Append(paramInfo.Field); fieldBuilder.Append(";"); fieldBuilder.Append(Environment.NewLine); fieldBuilder.Append(GetspaceIndent(n)); } } content = content.Replace(exp, fieldBuilder.ToString()); } content = ReplaceJudge(content, reqParams); content = Replacejohc(content, paramList); return content; }
/// <summary> /// 赋值模板 /// </summary> /// <param name="content"></param> /// <param name="paramList"></param> /// <param name="slnRecord"></param> /// <param name="title"></param> /// <param name="reqParams"></param> /// <returns></returns> public static string FormatTemp(string content, int contractId, List<ParamInfoModel> paramList, List<ParamInfoModel> reqParams, SolutionModel slnRecord, string title) { string[] expressList = new string[] { "##ID##", "##Description##", "##Field##", "##Namespace##", "##RefNamespace##" }; foreach (string exp in expressList) { StringBuilder fieldBuilder = new StringBuilder(); fieldBuilder.Append(exp.Replace("##", "")); if (fieldBuilder.ToString() == "ID") { fieldBuilder.Remove(0, fieldBuilder.Length); fieldBuilder.Append(contractId); } else if (fieldBuilder.ToString() == "Description") { fieldBuilder.Remove(0, fieldBuilder.Length); fieldBuilder.Append(title); } else if (fieldBuilder.ToString() == "Namespace") { fieldBuilder.Remove(0, fieldBuilder.Length); fieldBuilder.Append(slnRecord == null ? "" : slnRecord.Namespace); } else if (fieldBuilder.ToString() == "RefNamespace") { fieldBuilder.Remove(0, fieldBuilder.Length); fieldBuilder.Append(slnRecord == null ? "" : slnRecord.RefNamespace); } else if (fieldBuilder.ToString() == "Field") { int depth = 0; string listVar = "_dsItemList"; int recordIndex = 0; int[] indexList = new int[forVarChars.Length]; fieldBuilder.Remove(0, fieldBuilder.Length); var list = new List<ParamInfoModel>(reqParams); list.AddRange(paramList); foreach (var paramInfo in list) { FieldType fieldType = paramInfo.FieldType; if (FieldType.Record.Equals(fieldType)) { if (depth < indexList.Length) { recordIndex = indexList[depth]; recordIndex++; indexList[depth] = recordIndex; } listVar = listVar + "_" + recordIndex; fieldBuilder.AppendFormat("private List<Object> {0};", listVar); fieldBuilder.Append(Environment.NewLine); fieldBuilder.Append(GetSpaceIndent(0, 2)); depth++; continue; } if (FieldType.End.Equals(fieldType)) { listVar = listVar.Substring(0, listVar.LastIndexOf('_')); depth--; continue; } if (depth > 0) { continue; } fieldBuilder.Append("private "); fieldBuilder.Append(fieldType.ToString().ToLower()); fieldBuilder.Append(" "); fieldBuilder.Append(ToMemberVarName(paramInfo.Field)); fieldBuilder.Append(";"); fieldBuilder.Append(Environment.NewLine); fieldBuilder.Append(GetSpaceIndent(0, 2)); } } content = content.Replace(exp, fieldBuilder.ToString()); } content = ReplaceCheckRequest(content, reqParams); content = ReplaceBuildPack(content, paramList); return content; }