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));
}
