protected void gv_RowCommand(object sender, GridViewCommandEventArgs e) { string[] arr = e.CommandArgument.ToString().Split('|'); IM_NewsInfo newModel = new IM_NewsInfo(); newModel.SendUserID = userInfo.UserID; newModel.ReceiveUserID = new Guid(arr[0]); newModel.BusinessType = 2; newModel.BusinessID = ddlGroup.SelectedValue; newModel.Note = "群\"" + ddlGroup.SelectedItem.Text + "\"提出添加申请!"; newModel.State = 0; new IM_NewsBLL().Add(newModel); lbError.Text = "已发出申请"; }
protected void gv_RowCommand(object sender, GridViewCommandEventArgs e) { string[] arr = e.CommandArgument.ToString().Split('|'); IM_NewsInfo newModel = new IM_NewsInfo(); newModel.SendUserID = userInfo.UserID; newModel.ReceiveUserID = new Guid(arr[1]); newModel.BusinessType = 3; newModel.BusinessID = arr[0]; newModel.Note = "用户\"" + userInfo.UserName + "\"申请加入\"" + arr[2] + "\"群!"; newModel.State = 0; new IM_NewsBLL().Add(newModel); lbError.Text = "已发出申请"; }
/// <summary> /// 得到一个对象实体 /// </summary> public IM_NewsInfo DataRowToModel(DataRow row) { IM_NewsInfo model = new IM_NewsInfo(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = new Guid(row["ID"].ToString()); } if (row["SendUserID"] != null && row["SendUserID"].ToString() != "") { model.SendUserID = new Guid(row["SendUserID"].ToString()); } if (row["ReceiveUserID"] != null && row["ReceiveUserID"].ToString() != "") { model.ReceiveUserID = new Guid(row["ReceiveUserID"].ToString()); } if (row["BusinessType"] != null && row["BusinessType"].ToString() != "") { model.BusinessType = int.Parse(row["BusinessType"].ToString()); } if (row["BusinessID"] != null) { model.BusinessID = row["BusinessID"].ToString(); } if (row["Note"] != null) { model.Note = row["Note"].ToString(); } if (row["State"] != null && row["State"].ToString() != "") { model.State = int.Parse(row["State"].ToString()); } if (row["CreateDate"] != null && row["CreateDate"].ToString() != "") { model.CreateDate = DateTime.Parse(row["CreateDate"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// <param name="model">实体</param> /// </summary> public bool Add(IM_NewsInfo model) { StringBuilder strSql = new StringBuilder(); int n = 0; strSql.Append("insert into IM_News("); strSql.Append("SendUserID,ReceiveUserID,BusinessType,BusinessID,Note,State)"); strSql.Append(" values ("); strSql.Append("@SendUserID,@ReceiveUserID,@BusinessType,@BusinessID,@Note,@State)"); SqlParameter[] parameters = { new SqlParameter("@SendUserID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@ReceiveUserID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@BusinessType", SqlDbType.Int, 4), new SqlParameter("@BusinessID", SqlDbType.VarChar, 50), new SqlParameter("@Note", SqlDbType.NVarChar), new SqlParameter("@State", SqlDbType.Int, 4) }; parameters[n++].Value = model.SendUserID; parameters[n++].Value = model.ReceiveUserID; parameters[n++].Value = model.BusinessType; parameters[n++].Value = model.BusinessID; parameters[n++].Value = model.Note; parameters[n++].Value = model.State; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// <param name="ID">ID</param> /// </summary> public IM_NewsInfo GetModel(Guid ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,SendUserID,ReceiveUserID,BusinessType,BusinessID,Note,State,CreateDate from IM_News "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, 16) }; parameters[0].Value = ID; IM_NewsInfo model = new IM_NewsInfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// <param name="model">实体</param> /// </summary> public bool Add(IM_NewsInfo model) { return(dal.Add(model)); }