void showracelistinfo() { RC_RaceDAL dal = new RC_RaceDAL(); DataSet ds = dal.GetRaceDetail(strID); RC_Race model = DataConvert.DataRowToModel <RC_Race>(ds.Tables[0].Rows[0]); Rtitle.Text = model.Rtitle; hd_content.Value = model.RaceDesc; starttime.Text = model.StartTime; movenum.Text = model.MoveNum.ToString(); endtime.Text = model.EndTime; appid.Text = model.AppID; if (model.CodeImg != null && model.CodeImg != "") { img0.Src = "../../WXWall/" + model.CodeImg; } if (strAction == "show") { this.btnReset.Visible = false; this.btnSave.Visible = false; starttime.ReadOnly = true; endtime.ReadOnly = true; movenum.ReadOnly = true; } else { starttime.Attributes.Add("onclick", "WdatePicker({dateFmt:'yyyy-MM-dd HH:mm:ss'})"); endtime.Attributes.Add("onclick", "WdatePicker({dateFmt:'yyyy-MM-dd HH:mm:ss'})"); } }
/// <summary> /// 添加赛跑信息说明 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddRCRace(RC_Race model) { string sql = @"INSERT INTO [RC_Race] ([ID],[SiteCode],[Rtitle],[RaceDesc],[AppID],[CodeImg],[MoveNum],[StartTime],[EndTime],[IsDel],[AddTime]) VALUES (@ID,@SiteCode,@Rtitle,@RaceDesc,@AppID,@CodeImg,@MoveNum,@StartTime,@EndTime,@IsDel,@AddTime)"; System.Data.SqlClient.SqlParameter[] paras = new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@ID", model.ID), new System.Data.SqlClient.SqlParameter("@SiteCode", model.SiteCode), new System.Data.SqlClient.SqlParameter("@Rtitle", model.Rtitle), new System.Data.SqlClient.SqlParameter("@RaceDesc", model.RaceDesc), new System.Data.SqlClient.SqlParameter("@AppID", model.AppID), new System.Data.SqlClient.SqlParameter("@CodeImg", model.CodeImg), new System.Data.SqlClient.SqlParameter("@MoveNum", model.MoveNum), new System.Data.SqlClient.SqlParameter("@StartTime", model.StartTime), new System.Data.SqlClient.SqlParameter("@EndTime", model.EndTime), new System.Data.SqlClient.SqlParameter("@IsDel", (model.IsDel == 1?1:0)), new System.Data.SqlClient.SqlParameter("@AddTime", DateTime.Now) }; int rowsAffected = DbHelperSQL.ExecuteSql(sql.ToString(), paras); if (rowsAffected > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新赛跑信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateRCRace(RC_Race model) { string safesql = ""; safesql = " update RC_Race set "; if (model.SiteCode != null && model.SiteCode != "") { safesql += "[SiteCode]='" + model.SiteCode + "',"; } if (model.Rtitle != null && model.Rtitle != "") { safesql += "[Rtitle]='" + model.Rtitle + "',"; } if (model.RaceDesc != null && model.RaceDesc != "") { safesql += "[RaceDesc]='" + model.RaceDesc + "',"; } if (model.StartTime != null && model.StartTime.ToString() != "") { safesql += "[StartTime]='" + model.StartTime + "',"; } if (model.EndTime != null && model.EndTime.ToString() != "") { safesql += "[EndTime]='" + model.EndTime + "',"; } if (model.CodeImg != null && model.CodeImg.ToString() != "") { safesql += "[CodeImg]='" + model.CodeImg + "',"; } if (model.AppID != null && model.AppID.ToString() != "") { safesql += "[AppID]='" + model.AppID + "',"; } safesql += "[MoveNum]=" + (model.MoveNum > 0 ? model.MoveNum : 3000) + ","; safesql += "[IsDel]=" + (model.IsDel == 1 ? 1 : 0); safesql += " where id='" + model.ID + "'"; int rowsAffected = DbHelperSQL.ExecuteSql(safesql.ToString()); if (rowsAffected > 0) { return(true); } else { return(false); } }
protected void btnSave_Click(object sender, EventArgs e) { if (null == Session["strSiteName"] || null == Session["strSiteCode"] || null == Session["strLoginName"]) { Response.Write("<script language=JavaScript>;parent.location.href='../Index.aspx';</script>"); Response.End(); } //上传图像 string strIconFileName = string.Empty; //图像路径 string strIconSaveFileName = string.Empty; //网址路径 try { if (this.file0.PostedFile.FileName == "") { strIconSaveFileName = ""; } else { if (!System.IO.Directory.Exists(Server.MapPath("~") + @"/Images")) { System.IO.Directory.CreateDirectory(Server.MapPath("~") + @"/Images"); } if (!System.IO.Directory.Exists(String.Format(@"{0}/WXWall/images/{1}", Server.MapPath("~"), Session["strSiteCode"].ToString()))) { System.IO.Directory.CreateDirectory(String.Format(@"{0}/WXWall/images/{1}", Server.MapPath("~"), Session["strSiteCode"].ToString())); } string orignalName = this.file0.PostedFile.FileName; //获取客户机上传文件的文件名 string extendName = orignalName.Substring(orignalName.LastIndexOf(".")); //获取扩展名 if (extendName != ".gif" && extendName != ".jpg" && extendName != ".jpeg" && extendName != ".png") { MessageBox.Show(this, "文件格式有误!"); return; }//检查文件格式 string newName = String.Format("{0}_{1}{2}", DateTime.Now.Millisecond, file0.PostedFile.ContentLength, extendName);//对文件进行重命名 strIconFileName = String.Format(@"{0}WXWall/images/{1}/{2}", Server.MapPath("~"), Session["strSiteCode"].ToString(), newName); strIconSaveFileName = String.Format(@"images/{0}/{1}", Session["strSiteCode"].ToString(), newName); file0.PostedFile.SaveAs(strIconFileName); } } catch (Exception ex) { MessageBox.Show(this, "上传发生错误!原因是:" + ex.ToString()); } if (Rtitle.Text.Trim() != null && Rtitle.Text.Trim() != "") { RC_RaceDAL dal = new RC_RaceDAL(); RC_Race model = new RC_Race(); string strSiteCode = Session["strSiteCode"].ToString(); model.SiteCode = strSiteCode; model.Rtitle = Rtitle.Text; model.RaceDesc = hd_content.Value; if (starttime.Text.Trim() != null && starttime.Text.Trim() != "") { model.StartTime = starttime.Text; } if (endtime.Text.Trim() != null && endtime.Text.Trim() != "") { model.EndTime = endtime.Text; } if (appid.Text.Trim() != null && appid.Text.Trim() != "") { model.AppID = appid.Text; } if (movenum.Text.Trim() != null && movenum.Text.Trim() != "") { model.MoveNum = Convert.ToInt32(movenum.Text); } if (strIconSaveFileName.Trim() != null && strIconSaveFileName.Trim() != "") { model.CodeImg = strIconSaveFileName; } model.IsDel = 0; model.ID = strID; if (dal.UpdateRCRace(model)) { MessageBox.Show(this, "操作成功!"); } else { MessageBox.Show(this, "操作失败!"); } } else { MessageBox.Show(this, "请输入相应标题名称!"); } }