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, "请输入相应标题名称！");
}
}
