//根据adoptID 获取对应的信息
public CTAdoptPet GetAdoptInfoByAdoptID(string adoptID)
{
CTAdoptPet adoptInfo = new CTAdoptPet();
SqlParameter parm = new SqlParameter();
parm.ParameterName = PARM_ADOPT_ID;
parm.Value = adoptID;
try
{
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_ADOPTPET_BY_ADIPTID, parm))
{
while (reader.Read())
{
CTAdoptPet adoptPet = new CTAdoptPet();
adoptPet.AdoptID = reader["AdoptID"].ToString();
adoptPet.UserID = reader["UserID"].ToString();
adoptPet.AddressID = reader["AddressID"].ToString();
adoptPet.AdoptInfo = reader["AdoptInfo"].ToString();
adoptPet.AdoptTitle = reader["AdoptTitle"].ToString();
adoptPet.PetCategoryID = reader["PetCategoryID"].ToString();
adoptPet.PriorityScore = int.Parse(reader["PriorityScore"].ToString());
adoptPet.WeiBoID = reader["WeiBoID"].ToString();
bool tempIsAdopt = true;
adoptPet.IsAdopt = bool.TryParse(reader["IsAdopt"].ToString(), out tempIsAdopt) ? tempIsAdopt : true;
DateTime tempLastEditTime = DateTime.Now;
tempLastEditTime = DateTime.TryParse(reader["LastEditTime"].ToString(), out tempLastEditTime) ? tempLastEditTime : DateTime.Now;
adoptPet.LastEditTime = tempLastEditTime.ToString("yyyy/MM/dd hh:mm:ss");
DateTime tempAdoptTime = DateTime.Now;
tempAdoptTime = DateTime.TryParse(reader["AdoptTime"].ToString(), out tempAdoptTime) ? tempAdoptTime : DateTime.Now;
adoptPet.AdoptTime = tempAdoptTime.ToString("yyyy/MM/dd hh:mm:ss");
adoptPet.IsVisible = bool.Parse(reader["IsVisible"].ToString());
adoptPet.IP = reader["IP"].ToString();
int tempFocusNum = 0;
adoptPet.FocusNum = int.TryParse(reader["FocusNum"].ToString(), out tempFocusNum) ? tempFocusNum : 0;
adoptInfo=adoptPet;
break;
}
}
}
catch (Exception ex)
{
}
return adoptInfo;
}
protected void BtnAdd_Click(object sender, EventArgs e)
{
string title = tbTitle.Text.Trim().ToString();
string content = tbContent.Text.ToString();
string userID = ddlUser.SelectedValue.ToString();
string categoryID = ddlCategoryAdd.SelectedValue.ToString();
string addressID = ddlAddressAdd.SelectedValue.ToString();
string adoptID = Guid.NewGuid().ToString();
bool isAdopt = bool.Parse(CheckBox1.Checked.ToString());
//获取本机IP
IPHostEntry ipe = Dns.GetHostEntry(Dns.GetHostName());
IPAddress ipa = ipe.AddressList[0];
string ip=ipa.ToString();
CTAdoptPet adoptPet = new CTAdoptPet();
adoptPet.AddressID = addressID;
adoptPet.PetCategoryID = categoryID;
adoptPet.AdoptID = adoptID;
adoptPet.AdoptInfo = content;
adoptPet.AdoptTime = DateTime.Now.ToString("yyyy/MM/dd hh:mm:ss");
adoptPet.LastEditTime = DateTime.Now.ToString("yyyy/MM/dd hh:mm:ss");
adoptPet.AdoptTitle = title;
adoptPet.FocusNum = 0;
adoptPet.IP = ip;
adoptPet.IsVisible = true;
adoptPet.PriorityScore = 0;
adoptPet.WeiBoID = "";
adoptPet.UserID = userID;
adoptPet.IsAdopt = isAdopt;
AdoptPet adoptPetone = new AdoptPet();
int insertStatus = 0;
insertStatus=adoptPetone.InsertAdoptPet(adoptPet);
if (insertStatus == 1)
{
Response.Write("<script>alert('添加成功!')</script>");
}
else
{
Response.Write("<script>alert('添加失败!')</script>");
}
}
protected void Btn_Save_Click(object sender, EventArgs e)
{
CTAdoptPet ctadopt = new CTAdoptPet();
ctadopt.AdoptID = TextBox_AdoptID.Text;
ctadopt.AdoptInfo = TextBox_AdoptInfo.Text;
ctadopt.AddressID = TextBox_AddressID.Text;
ctadopt.AdoptTime = TextBox_AdoptTime.Text.ToString();
ctadopt.AdoptTitle = TextBox_AdoptTitle.Text.ToString();
ctadopt.FocusNum =int.Parse(TextBox_FocusNum.Text.ToString());
ctadopt.IP = TextBox_IP.Text.ToString();
ctadopt.PetCategoryID = TextBox_PetCategoryID.Text.ToString();
ctadopt.PriorityScore = int.Parse(TextBox_PriorityScore.Text.ToString());
ctadopt.UserID = TextBox_UserID.Text.ToString();
ctadopt.WeiBoID = TextBox_WeiBoID.Text.ToString();
ctadopt.LastEditTime = DateTime.Now.ToShortDateString();
AdoptPet adoptPet = new AdoptPet();
int editStatus = 0;
editStatus=adoptPet.EditAdoptInfo(ctadopt);
if (editStatus == 1)
{
Response.Write("<script>alert('Edit成功!')</script>");
}
else
{
Response.Write("<script>alert('Edit失败!')</script>");
}
}
protected void BtnEdit_Click(object sender, EventArgs e)
{
string sqlstr=string.Empty;
int checkNumber = 0;
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();
checkNumber++;
break;
}
}
if (checkNumber > 1 || checkNumber < 1)
{
Response.Write("<script>alert('请选择一个!')</script>");
}
else
{
AdoptPet adoptPet = new AdoptPet();
CTAdoptPet ctadopt = new CTAdoptPet();
ctadopt = adoptPet.GetPetAdoptPetByAdoptID(sqlstr);
TextBox_AdoptID.Text = ctadopt.AdoptID;
TextBox_AdoptInfo.Text = ctadopt.AdoptInfo;
TextBox_AddressID.Text = ctadopt.AddressID;
TextBox_AdoptTime.Text = ctadopt.AdoptTime.ToString();
TextBox_AdoptTitle.Text = ctadopt.AdoptTitle.ToString();
TextBox_FocusNum.Text = ctadopt.FocusNum.ToString();
TextBox_IP.Text = ctadopt.IP.ToString();
TextBox_PetCategoryID.Text = ctadopt.PetCategoryID.ToString();
TextBox_PriorityScore.Text = ctadopt.PriorityScore.ToString();
TextBox_UserID.Text = ctadopt.UserID.ToString();
TextBox_WeiBoID.Text = ctadopt.WeiBoID.ToString();
}
}
//更新记录
public int UpdateAdoptPet(CTAdoptPet AdoptPetInfo)
{
int updateStatus = 0;
//得到所有的参数数组
SqlParameter[] adoptPetParams = null;
adoptPetParams = new SqlParameter[]
{
new SqlParameter("@AdoptID",SqlDbType.NVarChar,32),
new SqlParameter("@AddressID",SqlDbType.NVarChar,20),
new SqlParameter("@PetCategoryID",SqlDbType.NVarChar,20),
new SqlParameter("@AdoptTitle",SqlDbType.NVarChar,20),
new SqlParameter("@LastEditTime",SqlDbType.DateTime ),
new SqlParameter("@AdoptInfo",SqlDbType.NVarChar),
new SqlParameter("@IP",SqlDbType.NVarChar,20),
};
adoptPetParams[0].Value = AdoptPetInfo.AdoptID;
adoptPetParams[1].Value = AdoptPetInfo.AddressID;
adoptPetParams[2].Value = AdoptPetInfo.PetCategoryID;
adoptPetParams[3].Value = AdoptPetInfo.AdoptTitle;
adoptPetParams[4].Value = Convert.ToDateTime(AdoptPetInfo.LastEditTime);
adoptPetParams[5].Value = AdoptPetInfo.AdoptInfo;
adoptPetParams[6].Value = AdoptPetInfo.IP;
try
{
using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringOrderDistributedTransaction))
{
updateStatus = SqlHelper.ExecuteNonQuery(conn, CommandType.Text, SQL_UPDATE_ADOPTPET, adoptPetParams);
}
}
catch (Exception ex)
{
}
return updateStatus;
}
//添加新记录
public int InsertAdoptPet(CTAdoptPet AdoptPetInfo)
{
int insertStatus = 0;
//得到所有的参数数组
SqlParameter[] adoptPetParams = null;
adoptPetParams = new SqlParameter[]
{
new SqlParameter("@AdoptID",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("@AdoptTitle",SqlDbType.NVarChar,20),
new SqlParameter("@AdoptTime",SqlDbType.DateTime ),
new SqlParameter("@LastEditTime",SqlDbType.DateTime ),
new SqlParameter("@AdoptInfo",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("@IsAdopt",SqlDbType.Bit),
};
adoptPetParams[0].Value = AdoptPetInfo.AdoptID;
adoptPetParams[1].Value = AdoptPetInfo.UserID;
adoptPetParams[2].Value = AdoptPetInfo.AddressID;
adoptPetParams[3].Value = AdoptPetInfo.PetCategoryID;
adoptPetParams[4].Value = AdoptPetInfo.WeiBoID;
adoptPetParams[5].Value = AdoptPetInfo.AdoptTitle;
adoptPetParams[6].Value = Convert.ToDateTime(AdoptPetInfo.AdoptTime);
adoptPetParams[7].Value = Convert.ToDateTime(AdoptPetInfo.LastEditTime);
adoptPetParams[8].Value = AdoptPetInfo.AdoptInfo;
adoptPetParams[9].Value = AdoptPetInfo.IP;
adoptPetParams[10].Value = AdoptPetInfo.PriorityScore;
adoptPetParams[11].Value = AdoptPetInfo.FocusNum;
adoptPetParams[12].Value = AdoptPetInfo.IsVisible;
adoptPetParams[13].Value = AdoptPetInfo.IsAdopt;
try
{
using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringOrderDistributedTransaction))
{
insertStatus = SqlHelper.ExecuteNonQuery(conn, CommandType.Text, SQL_INSERT_ADOPTPET, adoptPetParams);
}
}
catch (Exception ex)
{
}
return insertStatus;
}
//获取所有的petlist
public List<CTAdoptPet> GetAllAdoptPetList()
{
List<CTAdoptPet> AdoptPetList = new List<CTAdoptPet>();
try
{
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_ADOPTPET, null))
{
while (reader.Read())
{
CTAdoptPet adoptPet = new CTAdoptPet();
adoptPet.AdoptID = reader["AdoptID"].ToString();
adoptPet.UserID = reader["UserID"].ToString();
adoptPet.AddressID = reader["AddressID"].ToString();
adoptPet.AdoptInfo = reader["AdoptInfo"].ToString();
adoptPet.AdoptTitle = reader["AdoptTitle"].ToString();
adoptPet.PetCategoryID = reader["PetCategoryID"].ToString();
adoptPet.PriorityScore = int.Parse(reader["PriorityScore"].ToString());
adoptPet.WeiBoID = reader["WeiBoID"].ToString();
bool tempIsAdopt = true;
adoptPet.IsAdopt = bool.TryParse(reader["IsAdopt"].ToString(), out tempIsAdopt) ? tempIsAdopt : true;
DateTime tempLastEditTime = DateTime.Now;
tempLastEditTime = DateTime.TryParse(reader["LastEditTime"].ToString(), out tempLastEditTime) ? tempLastEditTime : DateTime.Now;
adoptPet.LastEditTime = tempLastEditTime.ToString("yyyy/MM/dd hh:mm:ss");
DateTime tempAdoptTime = DateTime.Now;
tempAdoptTime = DateTime.TryParse(reader["AdoptTime"].ToString(), out tempAdoptTime) ? tempAdoptTime : DateTime.Now;
adoptPet.AdoptTime = tempAdoptTime.ToString("yyyy/MM/dd hh:mm:ss");
adoptPet.IsVisible = bool.Parse(reader["IsVisible"].ToString());
adoptPet.IP = reader["IP"].ToString();
int tempFocusNum = 0;
adoptPet.FocusNum = int.TryParse(reader["FocusNum"].ToString(), out tempFocusNum) ? tempFocusNum : 0;
AdoptPetList.Add(adoptPet);
}
}
}
catch (Exception ex)
{
}
return AdoptPetList;
}
//根据userID获取其发布petlist
public List<CTAdoptPet> GetAdoptPetListByUser(string UserID)
{
List<CTAdoptPet> AdoptPetList = new List<CTAdoptPet>();
SqlParameter parm = new SqlParameter(PARM_USER_ID, SqlDbType.NVarChar);
parm.Value = UserID;
try
{
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_ADOPTPET_BY_USERID, parm))
{
while (reader.Read())
{
CTAdoptPet adoptPet = new CTAdoptPet();
adoptPet.AdoptID = reader["AdoptID"].ToString();
adoptPet.UserID = reader["UserID"].ToString();
adoptPet.AddressID = reader["AddressID"].ToString();
adoptPet.AdoptInfo = reader["AdoptInfo"].ToString();
adoptPet.AdoptTitle = reader["AdoptTitle"].ToString();
adoptPet.PetCategoryID = reader["PetCategoryID"].ToString();
adoptPet.PriorityScore = int.Parse(reader["PriorityScore"].ToString());
adoptPet.WeiBoID = reader["WeiBoID"].ToString();
DateTime tempLastEditTime = DateTime.Now;
tempLastEditTime = DateTime.TryParse(reader["LastEditTime"].ToString(), out tempLastEditTime) ? tempLastEditTime : DateTime.Now;
adoptPet.LastEditTime = tempLastEditTime.ToString("yyyy/MM/dd hh:mm:ss");
DateTime tempKnowledgeTime = DateTime.Now;
tempKnowledgeTime = DateTime.TryParse(reader["AdoptTime"].ToString(), out tempKnowledgeTime) ? tempKnowledgeTime : DateTime.Now;
adoptPet.AdoptTime = tempKnowledgeTime.ToString("yyyy/MM/dd hh:mm:ss");
adoptPet.IsVisible = bool.Parse(reader["IsVisible"].ToString());
adoptPet.IP = reader["IP"].ToString();
adoptPet.IsAdopt = bool.Parse(reader["IsAdopt"].ToString());
int tempFocusNum = 0;
adoptPet.FocusNum = int.TryParse(reader["FocusNum"].ToString(), out tempFocusNum) ? tempFocusNum : 0;
AdoptPetList.Add(adoptPet);
}
}
}
catch (Exception ex)
{
}
return AdoptPetList;
}