public Project() { _dictionaryById = new Dictionary <string, Model.Entity.Project>(); const string sql = "select [Project].* from [Project]"; var ds = Data.DBHelper.GetInstance().ExecuteAdapter(CommandType.Text, sql); if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { var item = new Model.Entity.Project { ProjectId = ds.Tables[0].Rows[i]["ProjectId"].ToString(), Name = ds.Tables[0].Rows[i]["Name"].ToString(), SMSKey = ds.Tables[0].Rows[i]["SMSKey"].ToString(), SMSReg = ds.Tables[0].Rows[i]["SMSReg"].ToString(), SMSForgot = ds.Tables[0].Rows[i]["SMSForgot"].ToString(), AppleVersion = int.Parse(ds.Tables[0].Rows[i]["AppleVersion"].ToString()), AppleUrl = ds.Tables[0].Rows[i]["AppleUrl"].ToString(), AppleDescription = ds.Tables[0].Rows[i]["AppleDescription"].ToString(), AndroidVersion = int.Parse(ds.Tables[0].Rows[i]["AndroidVersion"].ToString()), AndroidUrl = ds.Tables[0].Rows[i]["AndroidUrl"].ToString(), AndroidDescription = ds.Tables[0].Rows[i]["AndroidDescription"].ToString(), AD = (ds.Tables[0].Rows[i]["AD"] != DBNull.Value? ds.Tables[0].Rows[i]["AD"].ToString():null) }; _dictionaryById.Add(item.ProjectId, item); } } }
public JsonResult EditProject(Model.Entity.Project project) { Models.User user = BLL.Authorize.GetUser(); try { BLL.Client.Get(user.Server).ManageSaveProject(user.LoginId, project); return(Json(new { Result = 1, Message = "保存成功" })); } catch (Exception ex) { return(Json(new { Result = 0, Message = ex.Message })); } }
public void Save(Model.Entity.Project project) { lock (_dictionaryById) { string sql; if (_dictionaryById.ContainsKey(project.ProjectId)) { sql = "update [Project] set [Name]=@Name,[SMSKey]=@SMSKey,[SMSReg]=@SMSReg,[SMSForgot]=@SMSForgot,[AppleVersion]=@AppleVersion,[AppleUrl]=@AppleUrl,[AppleDescription]=@AppleDescription,[AndroidVersion]=@AndroidVersion,[AndroidUrl]=@AndroidUrl,[AndroidDescription]=@AndroidDescription,[AD]=@AD where [Project].[ProjectId]=@ProjectId"; } else { sql = "insert into [Project] (ProjectId,Name,SMSKey,SMSReg,SMSForgot,AppleVersion,AppleUrl,AppleDescription,AndroidVersion,AndroidUrl,AndroidDescription,AD) values (@ProjectId,@Name,@SMSKey,@SMSReg,@SMSForgot,@AppleVersion,@AppleUrl,@AppleDescription,@AndroidVersion,@AndroidUrl,@AndroidDescription,@AD)"; } var commandParameters = new DbParameter[] { Data.DBHelper.CreateInDbParameter("@ProjectId", DbType.String, CheckIsNull(project.ProjectId)), Data.DBHelper.CreateInDbParameter("@Name", DbType.String, CheckIsNull(project.Name)), Data.DBHelper.CreateInDbParameter("@SMSKey", DbType.String, CheckIsNull(project.SMSKey)), Data.DBHelper.CreateInDbParameter("@SMSReg", DbType.String, CheckIsNull(project.SMSReg)), Data.DBHelper.CreateInDbParameter("@SMSForgot", DbType.String, CheckIsNull(project.SMSForgot)), Data.DBHelper.CreateInDbParameter("@AppleVersion", DbType.Int32, CheckIsNull(project.AppleVersion)), Data.DBHelper.CreateInDbParameter("@AppleUrl", DbType.String, CheckIsNull(project.AppleUrl)), Data.DBHelper.CreateInDbParameter("@AppleDescription", DbType.String, CheckIsNull(project.AppleDescription)), Data.DBHelper.CreateInDbParameter("@AndroidVersion", DbType.Int32, CheckIsNull(project.AndroidVersion)), Data.DBHelper.CreateInDbParameter("@AndroidUrl", DbType.String, CheckIsNull(project.AndroidUrl)), Data.DBHelper.CreateInDbParameter("@AndroidDescription", DbType.String, CheckIsNull(project.AndroidDescription)), Data.DBHelper.CreateInDbParameter("@AD", DbType.String, GetItemValue(CheckIsNull(project.AD))), }; Data.DBHelper.GetInstance().ExecuteNonQuery(CommandType.Text, sql, commandParameters); if (!_dictionaryById.ContainsKey(project.ProjectId)) { _dictionaryById.Add(project.ProjectId, project); } else { _dictionaryById[project.ProjectId].Name = project.Name; _dictionaryById[project.ProjectId].SMSKey = project.SMSKey; _dictionaryById[project.ProjectId].SMSReg = project.SMSReg; _dictionaryById[project.ProjectId].SMSForgot = project.SMSForgot; _dictionaryById[project.ProjectId].AppleVersion = project.AppleVersion; _dictionaryById[project.ProjectId].AppleUrl = project.AppleUrl; _dictionaryById[project.ProjectId].AppleDescription = project.AppleDescription; _dictionaryById[project.ProjectId].AndroidVersion = project.AndroidVersion; _dictionaryById[project.ProjectId].AndroidUrl = project.AndroidUrl; _dictionaryById[project.ProjectId].AndroidDescription = project.AndroidDescription; _dictionaryById[project.ProjectId].AD = project.AD; } } }
public ActionResult EditProject(string projectId) { Models.User user = BLL.Authorize.GetUser(); Model.Entity.Project project; if (string.IsNullOrEmpty(projectId)) { ViewBag.NameType = 0; project = new Model.Entity.Project(); } else { ViewBag.NameType = 1; project = BLL.Client.Get(user.Server).ManageGetProject(user.LoginId, projectId); } ViewBag.User = user; return(View(project)); }