public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(txtMultiUserID.Text)) { strErr += "MultiUserID格式错误!\\n"; } if (!PageValidate.IsNumber(txtCardID.Text)) { strErr += "CardID格式错误!\\n"; } if (!PageValidate.IsDateTime(txtLostDate.Text)) { strErr += "LostDate格式错误!\\n"; } if (!PageValidate.IsDateTime(txtDownloadDate.Text)) { strErr += "DownloadDate格式错误!\\n"; } if (!PageValidate.IsNumber(txtSuccessMeterID.Text)) { strErr += "SuccessMeterID格式错误!\\n"; } if (!PageValidate.IsDateTime(txtSuccessDate.Text)) { strErr += "SuccessDate格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int LostID = int.Parse(this.lblLostID.Text); int MultiUserID = int.Parse(this.txtMultiUserID.Text); int CardID = int.Parse(this.txtCardID.Text); DateTime LostDate = DateTime.Parse(this.txtLostDate.Text); DateTime DownloadDate = DateTime.Parse(this.txtDownloadDate.Text); int SuccessMeterID = int.Parse(this.txtSuccessMeterID.Text); DateTime SuccessDate = DateTime.Parse(this.txtSuccessDate.Text); WebDemo.Model.WebDemo.LostInfo model = new WebDemo.Model.WebDemo.LostInfo(); model.LostID = LostID; model.MultiUserID = MultiUserID; model.CardID = CardID; model.LostDate = LostDate; model.DownloadDate = DownloadDate; model.SuccessMeterID = SuccessMeterID; model.SuccessDate = SuccessDate; WebDemo.BLL.WebDemo.LostInfo bll = new WebDemo.BLL.WebDemo.LostInfo(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }
private void ShowInfo(int LostID) { WebDemo.BLL.WebDemo.LostInfo bll = new WebDemo.BLL.WebDemo.LostInfo(); WebDemo.Model.WebDemo.LostInfo model = bll.GetModel(LostID); this.lblLostID.Text = model.LostID.ToString(); this.lblMultiUserID.Text = model.MultiUserID.ToString(); this.lblCardID.Text = model.CardID.ToString(); this.lblLostDate.Text = model.LostDate.ToString(); this.lblDownloadDate.Text = model.DownloadDate.ToString(); this.lblSuccessMeterID.Text = model.SuccessMeterID.ToString(); this.lblSuccessDate.Text = model.SuccessDate.ToString(); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WebDemo.Model.WebDemo.LostInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update LostInfo set "); strSql.Append("MultiUserID=@MultiUserID,"); strSql.Append("CardID=@CardID,"); strSql.Append("LostDate=@LostDate,"); strSql.Append("DownloadDate=@DownloadDate,"); strSql.Append("SuccessMeterID=@SuccessMeterID,"); strSql.Append("SuccessDate=@SuccessDate"); strSql.Append(" where LostID=@LostID"); SqlParameter[] parameters = { new SqlParameter("@MultiUserID", SqlDbType.Int, 4), new SqlParameter("@CardID", SqlDbType.Int, 4), new SqlParameter("@LostDate", SqlDbType.DateTime), new SqlParameter("@DownloadDate", SqlDbType.DateTime), new SqlParameter("@SuccessMeterID", SqlDbType.Int, 4), new SqlParameter("@SuccessDate", SqlDbType.DateTime), new SqlParameter("@LostID", SqlDbType.Int, 4) }; parameters[0].Value = model.MultiUserID; parameters[1].Value = model.CardID; parameters[2].Value = model.LostDate; parameters[3].Value = model.DownloadDate; parameters[4].Value = model.SuccessMeterID; parameters[5].Value = model.SuccessDate; parameters[6].Value = model.LostID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(WebDemo.Model.WebDemo.LostInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into LostInfo("); strSql.Append("MultiUserID,CardID,LostDate,DownloadDate,SuccessMeterID,SuccessDate)"); strSql.Append(" values ("); strSql.Append("@MultiUserID,@CardID,@LostDate,@DownloadDate,@SuccessMeterID,@SuccessDate)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@MultiUserID", SqlDbType.Int, 4), new SqlParameter("@CardID", SqlDbType.Int, 4), new SqlParameter("@LostDate", SqlDbType.DateTime), new SqlParameter("@DownloadDate", SqlDbType.DateTime), new SqlParameter("@SuccessMeterID", SqlDbType.Int, 4), new SqlParameter("@SuccessDate", SqlDbType.DateTime) }; parameters[0].Value = model.MultiUserID; parameters[1].Value = model.CardID; parameters[2].Value = model.LostDate; parameters[3].Value = model.DownloadDate; parameters[4].Value = model.SuccessMeterID; parameters[5].Value = model.SuccessDate; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.LostInfo DataRowToModel(DataRow row) { WebDemo.Model.WebDemo.LostInfo model = new WebDemo.Model.WebDemo.LostInfo(); if (row != null) { if (row["LostID"] != null && row["LostID"].ToString() != "") { model.LostID = int.Parse(row["LostID"].ToString()); } if (row["MultiUserID"] != null && row["MultiUserID"].ToString() != "") { model.MultiUserID = int.Parse(row["MultiUserID"].ToString()); } if (row["CardID"] != null && row["CardID"].ToString() != "") { model.CardID = int.Parse(row["CardID"].ToString()); } if (row["LostDate"] != null && row["LostDate"].ToString() != "") { model.LostDate = DateTime.Parse(row["LostDate"].ToString()); } if (row["DownloadDate"] != null && row["DownloadDate"].ToString() != "") { model.DownloadDate = DateTime.Parse(row["DownloadDate"].ToString()); } if (row["SuccessMeterID"] != null && row["SuccessMeterID"].ToString() != "") { model.SuccessMeterID = int.Parse(row["SuccessMeterID"].ToString()); } if (row["SuccessDate"] != null && row["SuccessDate"].ToString() != "") { model.SuccessDate = DateTime.Parse(row["SuccessDate"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.LostInfo GetModel(int LostID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 LostID,MultiUserID,CardID,LostDate,DownloadDate,SuccessMeterID,SuccessDate from LostInfo "); strSql.Append(" where LostID=@LostID"); SqlParameter[] parameters = { new SqlParameter("@LostID", SqlDbType.Int, 4) }; parameters[0].Value = LostID; WebDemo.Model.WebDemo.LostInfo model = new WebDemo.Model.WebDemo.LostInfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }