protected void Btn_Save_Click(object sender, EventArgs e) { if (TextBox_MissID.Text == "") { Response.Write("<script>alert('请选择一个编辑!')</script>"); } else { CTMissedPetInfo ctmiss = new CTMissedPetInfo(); ctmiss.MissId = TextBox_MissID.Text; ctmiss.MissInfo = TextBox_MissIDInfo.Text; ctmiss.AddressID = TextBox_AddressID.Text; ctmiss.MissTime = TextBox_MissIDTime.Text.ToString(); ctmiss.MissTitle = TextBox_MissIDTitle.Text.ToString(); ctmiss.FocusNum = int.Parse(TextBox_FocusNum.Text.ToString()); ctmiss.IP = TextBox_IP.Text.ToString(); ctmiss.PetCategoryID = TextBox_PetCategoryID.Text.ToString(); ctmiss.PriorityScore = int.Parse(TextBox_PriorityScore.Text.ToString()); ctmiss.UserID = TextBox_UserID.Text.ToString(); ctmiss.WeiBoID = TextBox_WeiBoID.Text.ToString(); ctmiss.LastEditTime = DateTime.Now.ToShortDateString(); MissedPetInfo MISSPet = new MissedPetInfo(); int editStatus = 0; editStatus = MISSPet.EditPetInfo(ctmiss); if (editStatus == 1) { Response.Write("<script>alert('Edit成功!')</script>"); } else { Response.Write("<script>alert('Edit失败!')</script>"); } } }
//实现接口定义的函数,增加一条信息 public int InsertMissedPet(CTMissedPetInfo MissedPetInfo) { int InsertStatus = 0; SqlParameter[] missPetParams = null; missPetParams = new SqlParameter[] { new SqlParameter("@MissID", SqlDbType.NVarChar, 32), new SqlParameter("@UserID", SqlDbType.NVarChar, 20), new SqlParameter("@AddressID", SqlDbType.NVarChar, 20), new SqlParameter("@PetCategoryID", SqlDbType.NVarChar, 20), new SqlParameter("@WeiBoID", SqlDbType.NVarChar, 20), new SqlParameter("@MissTitle", SqlDbType.NVarChar, 20), new SqlParameter("@MissTime", SqlDbType.DateTime), new SqlParameter("@LastEditTime", SqlDbType.DateTime), new SqlParameter("@MissInfo", SqlDbType.NVarChar), new SqlParameter("@IP", SqlDbType.NVarChar, 20), new SqlParameter("@PriorityScore", SqlDbType.Int), new SqlParameter("@FocusNum", SqlDbType.Int), new SqlParameter("@IsVisible", SqlDbType.Bit), new SqlParameter("@IsRecommand", SqlDbType.Bit), new SqlParameter("@IsEssence", SqlDbType.Bit), new SqlParameter("@LinkUrl", SqlDbType.NVarChar), new SqlParameter("@Status", SqlDbType.NVarChar), new SqlParameter("@PicLocation", SqlDbType.NVarChar), }; missPetParams[0].Value = MissedPetInfo.MissId; missPetParams[1].Value = MissedPetInfo.UserID; missPetParams[2].Value = MissedPetInfo.AddressID; missPetParams[3].Value = MissedPetInfo.PetCategoryID; missPetParams[4].Value = MissedPetInfo.WeiBoID; missPetParams[5].Value = MissedPetInfo.MissTitle; missPetParams[6].Value = MissedPetInfo.MissTime; missPetParams[7].Value = MissedPetInfo.LastEditTime; missPetParams[8].Value = MissedPetInfo.MissInfo; missPetParams[9].Value = MissedPetInfo.IP; missPetParams[10].Value = MissedPetInfo.PriorityScore; missPetParams[11].Value = MissedPetInfo.FocusNum; missPetParams[12].Value = MissedPetInfo.IsVisible; missPetParams[13].Value = MissedPetInfo.IsRecommand; missPetParams[14].Value = MissedPetInfo.IsEssence; missPetParams[15].Value = MissedPetInfo.LinkUrl; missPetParams[16].Value = MissedPetInfo.Status; missPetParams[17].Value = MissedPetInfo.PicLocation; try { using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringInventoryDistributedTransaction)) { InsertStatus = SqlHelper.ExecuteNonQuery(conn, CommandType.Text, SQL_INSERT_MISSEDPETINFO, missPetParams); } } catch (Exception ex) { } return(InsertStatus); }
//根据MissedID查找miss文章信息 public CTMissedPetInfo GetMissedPetByMissedID(string MissedID) { CTMissedPetInfo MissedPetInfo = new CTMissedPetInfo(); SqlParameter parm = new SqlParameter(); parm.Value = MissedID; parm.ParameterName = PARM_MISS_ID; try { using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_MISSEDPETINFO_BY_MISSEDID, parm)) { while (reader.Read()) { CTMissedPetInfo missedPet = new CTMissedPetInfo(); missedPet.MissId = reader["MissID"].ToString(); missedPet.AddressID = reader["AddressID"].ToString(); missedPet.MissInfo = reader["MissInfo"].ToString(); missedPet.MissTitle = reader["MissTitle"].ToString(); missedPet.PetCategoryID = reader["PetCategoryID"].ToString(); missedPet.PriorityScore = int.Parse(reader["PriorityScore"].ToString()); missedPet.PicLocation = reader["PicLocation"].ToString(); missedPet.LinkUrl = reader["LinkUrl"].ToString(); missedPet.Status = reader["Status"].ToString(); missedPet.UserID = reader["UserID"].ToString(); missedPet.WeiBoID = reader["WeiBoID"].ToString(); bool tempIsRecommand = true; missedPet.IsRecommand = bool.TryParse(reader["IsRecommand"].ToString(), out tempIsRecommand) ? tempIsRecommand : true; bool tempIsEssence = true; missedPet.IsEssence = bool.TryParse(reader["IsEssence"].ToString(), out tempIsEssence) ? tempIsEssence : true; DateTime tempLastEditTime = DateTime.Now; tempLastEditTime = DateTime.TryParse(reader["LastEditTime"].ToString(), out tempLastEditTime) ? tempLastEditTime : DateTime.Now; missedPet.LastEditTime = tempLastEditTime.ToString("yyyy/MM/dd hh:mm:ss"); DateTime tempMissTime = DateTime.Now; tempMissTime = DateTime.TryParse(reader["MissTime"].ToString(), out tempMissTime) ? tempMissTime : DateTime.Now; missedPet.MissTime = tempMissTime.ToString("yyyy/MM/dd hh:mm:ss"); missedPet.IP = reader["IP"].ToString(); int tempFocusNum = 0; missedPet.FocusNum = int.TryParse(reader["FocusNum"].ToString(), out tempFocusNum) ? tempFocusNum : 0; MissedPetInfo = missedPet; } reader.Close(); reader.Dispose(); } return(MissedPetInfo); } catch (Exception ex) { throw; } }
//实现接口定义的函数:获得所有的丢失信息 public List <CTMissedPetInfo> GetAllMissedPetInfoList() { List <CTMissedPetInfo> MissedPetInfoList = new List <CTMissedPetInfo>(); try { using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_MISSEDPETINFO, null)) { while (reader.Read()) { CTMissedPetInfo missedPet = new CTMissedPetInfo(); missedPet.MissId = reader["MissID"].ToString(); missedPet.AddressID = reader["AddressID"].ToString(); missedPet.MissInfo = reader["MissInfo"].ToString(); missedPet.MissTitle = reader["MissTitle"].ToString(); missedPet.PetCategoryID = reader["PetCategoryID"].ToString(); missedPet.PriorityScore = int.Parse(reader["PriorityScore"].ToString()); missedPet.PicLocation = reader["PicLocation"].ToString(); missedPet.LinkUrl = reader["LinkUrl"].ToString(); missedPet.Status = reader["Status"].ToString(); bool tempIsRecommand = true; missedPet.IsRecommand = bool.TryParse(reader["IsRecommand"].ToString(), out tempIsRecommand) ? tempIsRecommand : true; bool tempIsEssence = true; missedPet.IsEssence = bool.TryParse(reader["IsEssence"].ToString(), out tempIsEssence) ? tempIsEssence : true; DateTime tempLastEditTime = DateTime.Now; tempLastEditTime = DateTime.TryParse(reader["LastEditTime"].ToString(), out tempLastEditTime) ? tempLastEditTime : DateTime.Now; missedPet.LastEditTime = tempLastEditTime.ToString("yyyy/MM/dd hh:mm:ss"); DateTime tempMissTime = DateTime.Now; tempMissTime = DateTime.TryParse(reader["MissTime"].ToString(), out tempMissTime) ? tempMissTime : DateTime.Now; missedPet.MissTime = tempMissTime.ToString("yyyy/MM/dd hh:mm:ss"); missedPet.IP = reader["IP"].ToString(); int tempFocusNum = 0; missedPet.FocusNum = int.TryParse(reader["FocusNum"].ToString(), out tempFocusNum) ? tempFocusNum : 0; MissedPetInfoList.Add(missedPet); } reader.Close(); reader.Dispose(); } return(MissedPetInfoList); } catch (Exception ex) { throw; } }
//单机增加新文章 protected void BtnAdd_Click(object sender, EventArgs e) { string user = ddlUser.SelectedValue.ToString(); string category = ddlCategoryAdd.SelectedValue.ToString(); string address = ddlAddressAdd.SelectedValue.ToString(); string title = tbTitle.Text.Trim().ToString(); string content = tbContent.Text.Trim().ToString(); //获取本机IP IPHostEntry ipe = Dns.GetHostEntry(Dns.GetHostName()); IPAddress ipa = ipe.AddressList[0]; string ip = ipa.ToString(); CTMissedPetInfo missedInfo = new CTMissedPetInfo(); missedInfo.MissId = Guid.NewGuid().ToString(); missedInfo.IsRecommand = false; missedInfo.IsVisible = true; missedInfo.IsEssence = false; missedInfo.LastEditTime = DateTime.Now.ToShortDateString(); missedInfo.MissTime = DateTime.Now.ToShortDateString(); missedInfo.MissTitle = title; missedInfo.AddressID = address; missedInfo.PetCategoryID = category; missedInfo.PriorityScore = 0; missedInfo.UserID = user; missedInfo.WeiBoID = ""; missedInfo.MissInfo = content; missedInfo.IP = ip; missedInfo.FocusNum = 0; missedInfo.LinkUrl = ""; missedInfo.Status = ""; missedInfo.PicLocation = ""; MissedPetInfo missedPetInfo = new MissedPetInfo(); int insertStatus = 0; insertStatus = missedPetInfo.InsertMissedPetInfo(missedInfo); if (insertStatus == 1) { Response.Write("<script>alert('添加成功!')</script>"); } else { Response.Write("<script>alert('添加失败!')</script>"); } }
public int EditMissedPet(CTMissedPetInfo MissedPetInfo) { int updateStatus = 0; //得到所有的参数数组 SqlParameter[] adoptPetParams = null; adoptPetParams = new SqlParameter[] { new SqlParameter("@MissId", SqlDbType.NVarChar, 32), new SqlParameter("@AddressID", SqlDbType.NVarChar, 20), new SqlParameter("@PetCategoryID", SqlDbType.NVarChar, 20), new SqlParameter("@MissTitle", SqlDbType.NVarChar, 20), new SqlParameter("@LastEditTime", SqlDbType.DateTime), new SqlParameter("@MissInfo", SqlDbType.NVarChar), new SqlParameter("@IP", SqlDbType.NVarChar, 20), }; adoptPetParams[0].Value = MissedPetInfo.MissId; adoptPetParams[1].Value = MissedPetInfo.AddressID; adoptPetParams[2].Value = MissedPetInfo.PetCategoryID; adoptPetParams[3].Value = MissedPetInfo.MissTitle; adoptPetParams[4].Value = Convert.ToDateTime(MissedPetInfo.LastEditTime); adoptPetParams[5].Value = MissedPetInfo.MissInfo; adoptPetParams[6].Value = MissedPetInfo.IP; try { using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringOrderDistributedTransaction)) { updateStatus = SqlHelper.ExecuteNonQuery(conn, CommandType.Text, SQL_UPDATE_MISSPET, adoptPetParams); } } catch (Exception ex) { } return(updateStatus); }
protected void BtnEdit_Click(object sender, EventArgs e) { int selectNumber = 0; string sqlstr = string.Empty; for (int i = 0; i <= GridView1.Rows.Count - 1; i++) { CheckBox cbox = (CheckBox)GridView1.Rows[i].FindControl("CheckBoxs"); if (cbox.Checked == true) { sqlstr = GridView1.DataKeys[i].Value.ToString(); selectNumber++; } } if (selectNumber > 1 || selectNumber < 1) { Response.Write("<script>alert('请选择一个!')</script>"); } else { MissedPetInfo missPet = new MissedPetInfo(); CTMissedPetInfo ctmiss = new CTMissedPetInfo(); ctmiss = missPet.GetMissedInfoByMissedID(sqlstr); TextBox_MissID.Text = ctmiss.MissId; TextBox_MissIDInfo.Text = ctmiss.MissInfo; TextBox_AddressID.Text = ctmiss.AddressID; TextBox_MissIDTime.Text = ctmiss.MissTime.ToString(); TextBox_MissIDTitle.Text = ctmiss.MissTitle.ToString(); TextBox_FocusNum.Text = ctmiss.FocusNum.ToString(); TextBox_IP.Text = ctmiss.IP.ToString(); TextBox_PetCategoryID.Text = ctmiss.PetCategoryID.ToString(); TextBox_PriorityScore.Text = ctmiss.PriorityScore.ToString(); TextBox_UserID.Text = ctmiss.UserID.ToString(); TextBox_WeiBoID.Text = ctmiss.WeiBoID.ToString(); } }
//插入丢失信息 public int InsertMissedPetInfo(CTMissedPetInfo missedPetInfo) { return(dal.InsertMissedPet(missedPetInfo)); }
//编辑Miss 信息 public int EditPetInfo(CTMissedPetInfo missPetInfo) { return(dal.EditMissedPet(missPetInfo)); }