//根据knowledgeID 获取knowledge信息
public CTKnowledgePet GetKnowledgePetInfoByKnowledgeID(string knowledgeID)
{
CTKnowledgePet KnowledgePet = new CTKnowledgePet();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_KNOWLEDGEPET, null))
{
while (reader.Read())
{
CTKnowledgePet knowledgepet = new CTKnowledgePet();
knowledgepet.KnowledgeID = reader["KnowledgeID"].ToString();
knowledgepet.UserID = reader["UserID"].ToString();
knowledgepet.AddressID = reader["AddressID"].ToString();
knowledgepet.KnowledgeInfo = reader["KnowledgeInfo"].ToString();
knowledgepet.KnowledgeTitle = reader["KnowledgeTitle"].ToString();
knowledgepet.PetCategoryID = reader["PetCategoryID"].ToString();
knowledgepet.PriorityScore = int.Parse(reader["PriorityScore"].ToString());
knowledgepet.WeiBoID = reader["WeiBoID"].ToString();
DateTime tempLastEditTime = DateTime.Now;
// knowledgepet.LastEditTime = reader["LastEditTime"].ToString();
DateTime tempKnowledgeTime = DateTime.Now;
knowledgepet.KnowledgeTime = reader["KnowledgeTime"].ToString();
knowledgepet.IsVisible = bool.Parse(reader["IsVisible"].ToString());
knowledgepet.IP = reader["IP"].ToString();
int tempFocusNum = 0;
knowledgepet.FocusNum = int.TryParse(reader["FocusNum"].ToString(), out tempFocusNum) ? tempFocusNum : 0;
KnowledgePet = knowledgepet;
}
}
return(KnowledgePet);
}
protected void Btn_Save_Click(object sender, EventArgs e)
{
if (TextBox_KnowledgeID.Text == "")
{
Response.Write("<script>alert('请选择一个编辑!')</script>");
}
else
{
CTKnowledgePet knowledgetable = new CTKnowledgePet();
knowledgetable.KnowledgeID = TextBox_KnowledgeID.Text;
knowledgetable.KnowledgeInfo = TextBox_MissIDInfo.Text;
knowledgetable.AddressID = TextBox_AddressID.Text;
knowledgetable.KnowledgeTime = TextBox_KnowledgeTime.Text.ToString();
knowledgetable.KnowledgeTitle = TextBox_KnowledgeTitle.Text.ToString();
knowledgetable.FocusNum = int.Parse(TextBox_FocusNum.Text.ToString());
knowledgetable.IP = TextBox_IP.Text.ToString();
knowledgetable.PetCategoryID = TextBox_PetCategoryID.Text.ToString();
knowledgetable.PriorityScore = int.Parse(TextBox_PriorityScore.Text.ToString());
knowledgetable.UserID = TextBox_UserID.Text.ToString();
knowledgetable.WeiBoID = TextBox_WeiBoID.Text.ToString();
knowledgetable.LastEditTime = DateTime.Now.ToShortDateString();
KnowledgePet knowledgepet = new KnowledgePet();
int editStatus = 0;
editStatus = knowledgepet.EditKnowledgePet(knowledgetable);
if (editStatus == 1)
{
Response.Write("<script>alert('Edit成功!')</script>");
}
else
{
Response.Write("<script>alert('Edit失败!')</script>");
}
}
}
//实现接口的函数
public int InsertKnowledgePet(CTKnowledgePet KnowledgePetInfo)
{
int insertStatus = 0;
//得到所有的参数数组
SqlParameter[] knowledgeParams = null;
knowledgeParams = new SqlParameter[]
{
new SqlParameter("@AddressID", SqlDbType.NVarChar, 20),
new SqlParameter("@KnowledgeID", SqlDbType.NVarChar, 20),
new SqlParameter("@KnowledgeInfo", SqlDbType.NVarChar),
new SqlParameter("@KnowledgeTime", SqlDbType.DateTime),
new SqlParameter("@KnowledgeTitle", SqlDbType.NVarChar, 50),
new SqlParameter("@PetCategoryID", SqlDbType.NVarChar, 20),
new SqlParameter("@PriorityScore", SqlDbType.Int),
new SqlParameter("@UserID", SqlDbType.NVarChar, 20),
new SqlParameter("@WeiBoID", SqlDbType.NVarChar, 20),
new SqlParameter("@FocusNum", SqlDbType.Int),
new SqlParameter("@ComplaintNum", SqlDbType.Int),
new SqlParameter("@IP", SqlDbType.NVarChar, 20),
new SqlParameter("@LastEditTime", SqlDbType.DateTime),
new SqlParameter("@IsVisible", SqlDbType.Bit),
};
knowledgeParams[0].Value = KnowledgePetInfo.AddressID;
knowledgeParams[1].Value = KnowledgePetInfo.KnowledgeID;
knowledgeParams[2].Value = KnowledgePetInfo.KnowledgeInfo;
knowledgeParams[3].Value = Convert.ToDateTime(KnowledgePetInfo.KnowledgeTime);
knowledgeParams[4].Value = KnowledgePetInfo.KnowledgeTitle;
knowledgeParams[5].Value = KnowledgePetInfo.PetCategoryID;
knowledgeParams[6].Value = KnowledgePetInfo.PriorityScore;
knowledgeParams[7].Value = KnowledgePetInfo.UserID;
knowledgeParams[8].Value = KnowledgePetInfo.WeiBoID;
knowledgeParams[9].Value = KnowledgePetInfo.FocusNum;
knowledgeParams[10].Value = KnowledgePetInfo.ComplaintNum;
knowledgeParams[11].Value = KnowledgePetInfo.IP;
knowledgeParams[12].Value = Convert.ToDateTime(KnowledgePetInfo.LastEditTime);
knowledgeParams[13].Value = KnowledgePetInfo.IsVisible;
using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringOrderDistributedTransaction))
{
insertStatus = SqlHelper.ExecuteNonQuery(conn, CommandType.Text, SQL_INSERT_KNOWLEDGEPET, knowledgeParams);
}
return(insertStatus);
}
//编辑信息函数
public int EditKnowledgePet(CTKnowledgePet KnowledgePetInfo)
{
int editStatus = 0;
//得到所有的参数数组
SqlParameter[] knowledgeParams = null;
knowledgeParams = new SqlParameter[]
{
new SqlParameter("@AddressID",SqlDbType.NVarChar,20),
new SqlParameter("@KnowledgeID",SqlDbType.NVarChar,20),
new SqlParameter("@KnowledgeInfo",SqlDbType.NVarChar),
new SqlParameter("@KnowledgeTime",SqlDbType.DateTime ),
new SqlParameter("@KnowledgeTitle",SqlDbType.NVarChar,50),
new SqlParameter("@PetCategoryID",SqlDbType.NVarChar,20),
new SqlParameter("@PriorityScore",SqlDbType.Int),
new SqlParameter("@UserID",SqlDbType.NVarChar,20),
new SqlParameter("@WeiBoID",SqlDbType.NVarChar,20),
new SqlParameter("@FocusNum",SqlDbType.Int),
new SqlParameter("@ComplaintNum",SqlDbType.Int),
new SqlParameter("@IP",SqlDbType.NVarChar,20),
new SqlParameter("@LastEditTime",SqlDbType.DateTime ),
new SqlParameter("@IsVisible",SqlDbType.Bit),
};
knowledgeParams[0].Value = KnowledgePetInfo.AddressID;
knowledgeParams[1].Value = KnowledgePetInfo.KnowledgeID;
knowledgeParams[2].Value = KnowledgePetInfo.KnowledgeInfo;
knowledgeParams[3].Value = Convert.ToDateTime(KnowledgePetInfo.KnowledgeTime);
knowledgeParams[4].Value = KnowledgePetInfo.KnowledgeTitle;
knowledgeParams[5].Value = KnowledgePetInfo.PetCategoryID;
knowledgeParams[6].Value = KnowledgePetInfo.PriorityScore;
knowledgeParams[7].Value = KnowledgePetInfo.UserID;
knowledgeParams[8].Value = KnowledgePetInfo.WeiBoID;
knowledgeParams[9].Value = KnowledgePetInfo.FocusNum;
knowledgeParams[10].Value = KnowledgePetInfo.ComplaintNum;
knowledgeParams[11].Value = KnowledgePetInfo.IP;
knowledgeParams[12].Value = Convert.ToDateTime(KnowledgePetInfo.LastEditTime);
knowledgeParams[13].Value = KnowledgePetInfo.IsVisible;
using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringOrderDistributedTransaction))
{
editStatus = SqlHelper.ExecuteNonQuery(conn, CommandType.Text, SQL_EDIT_KNOWLEDGEPET, knowledgeParams);
}
return editStatus;
}
protected void BtnAdd_Click(object sender, EventArgs e)
{
//获取本机IP
IPHostEntry ipe = Dns.GetHostEntry(Dns.GetHostName());
IPAddress ipa = ipe.AddressList[0];
string userID = dpUsers.SelectedValue.ToString();
string knowledgeID = Guid.NewGuid().ToString();
string addressID = dpAddress.SelectedValue.ToString();
string petcategoryID = dpCategory.SelectedValue.ToString();
string weiboID = "";
string knowledgeTitle = tbKnowLedgeTitle.Text.Trim().ToString();
string knowledgeTime = DateTime.Now.ToString("yyyy/MM/dd hh:mm:ss");
string ip = ipa.ToString();
string content = tbContent.Text.Trim().ToString();
CTKnowledgePet knowledge = new CTKnowledgePet();
knowledge.UserID = userID;
knowledge.KnowledgeID = knowledgeID;
knowledge.AddressID = addressID;
knowledge.PetCategoryID = petcategoryID;
knowledge.WeiBoID = weiboID;
knowledge.KnowledgeTitle = knowledgeTitle;
knowledge.KnowledgeTime = DateTime.Now.ToString("yyyy/MM/dd hh:mm:ss");
knowledge.PriorityScore = 0;
knowledge.IP = ip;
knowledge.IsVisible = true;
knowledge.LastEditTime = DateTime.Now.ToString("yyyy/MM/dd hh:mm:ss");
knowledge.KnowledgeInfo = content;
knowledge.FocusNum = 0;
KnowledgePet knowledgePet = new KnowledgePet();
int insertStatus = knowledgePet.InsertKnowledgePet(knowledge);
if (insertStatus == 1)
{
Response.Write("<script>alert('添加成功!')</script>");
}
else
{
Response.Write("<script>alert('添加失败!')</script>");
}
}
protected void BtnAdd_Click(object sender, EventArgs e)
{
//获取本机IP
IPHostEntry ipe = Dns.GetHostEntry(Dns.GetHostName());
IPAddress ipa = ipe.AddressList[0];
string userID = dpUsers.SelectedValue.ToString();
string knowledgeID =Guid.NewGuid().ToString();
string addressID = dpAddress.SelectedValue.ToString();
string petcategoryID = dpCategory.SelectedValue.ToString();
string weiboID = "";
string knowledgeTitle = tbKnowLedgeTitle.Text.Trim().ToString();
string knowledgeTime = DateTime.Now.ToString("yyyy/MM/dd hh:mm:ss");
string ip = ipa.ToString();
string content = tbContent.Text.Trim().ToString();
CTKnowledgePet knowledge = new CTKnowledgePet();
knowledge.UserID = userID;
knowledge.KnowledgeID = knowledgeID;
knowledge.AddressID = addressID;
knowledge.PetCategoryID = petcategoryID;
knowledge.WeiBoID = weiboID;
knowledge.KnowledgeTitle = knowledgeTitle;
knowledge.KnowledgeTime = DateTime.Now.ToString("yyyy/MM/dd hh:mm:ss");
knowledge.PriorityScore = 0;
knowledge.IP = ip;
knowledge.IsVisible = true;
knowledge.LastEditTime = DateTime.Now.ToString("yyyy/MM/dd hh:mm:ss");
knowledge.KnowledgeInfo = content;
knowledge.FocusNum = 0;
KnowledgePet knowledgePet = new KnowledgePet();
int insertStatus=knowledgePet.InsertKnowledgePet(knowledge);
if (insertStatus == 1)
{
Response.Write("<script>alert('添加成功!')</script>");
}
else
{
Response.Write("<script>alert('添加失败!')</script>");
}
}
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
{
KnowledgePet knowledgePet = new KnowledgePet();
CTKnowledgePet knowledgetable = new CTKnowledgePet();
knowledgetable = knowledgePet.GetKnowledgePetByKnowledgeID(sqlstr);
TextBox_KnowledgeID.Text = knowledgetable.KnowledgeID;
TextBox_MissIDInfo.Text = knowledgetable.KnowledgeInfo;
TextBox_AddressID.Text = knowledgetable.AddressID;
TextBox_KnowledgeTime.Text = knowledgetable.KnowledgeTime.ToString();
TextBox_KnowledgeTitle.Text = knowledgetable.KnowledgeTitle.ToString();
TextBox_FocusNum.Text = knowledgetable.FocusNum.ToString();
TextBox_IP.Text = knowledgetable.IP.ToString();
TextBox_PetCategoryID.Text = knowledgetable.PetCategoryID.ToString();
TextBox_PriorityScore.Text = knowledgetable.PriorityScore.ToString();
TextBox_UserID.Text = knowledgetable.UserID.ToString();
TextBox_WeiBoID.Text = knowledgetable.WeiBoID.ToString();
}
}
//更新一篇knowledge的信息
public int EditKnowledgePet(CTKnowledgePet knowledgePet)
{
return(dal.EditKnowledgePet(knowledgePet));
}
//增加宠物知识信息
public int InsertKnowledgePet(CTKnowledgePet knowledgePet)
{
return(dal.InsertKnowledgePet(knowledgePet));
}
//得到所有的宠物知识信息
public List<CTKnowledgePet> GetAllKnowledgePetList()
{
List<CTKnowledgePet> KnowledgePetList = new List<CTKnowledgePet>();
using(SqlDataReader reader=SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_KNOWLEDGEPET, null))
{
while(reader.Read())
{
CTKnowledgePet knowledgepet=new CTKnowledgePet();
knowledgepet.KnowledgeID = reader["KnowledgeID"].ToString();
knowledgepet.UserID = reader["UserID"].ToString();
knowledgepet.AddressID = reader["AddressID"].ToString();
knowledgepet.KnowledgeInfo = reader["KnowledgeInfo"].ToString();
knowledgepet.KnowledgeTitle = reader["KnowledgeTitle"].ToString();
knowledgepet.PetCategoryID = reader["PetCategoryID"].ToString();
knowledgepet.PriorityScore = int.Parse(reader["PriorityScore"].ToString());
knowledgepet.WeiBoID = reader["WeiBoID"].ToString();
DateTime tempLastEditTime = DateTime.Now;
// knowledgepet.LastEditTime = string .TryParse(reader["LastEditTime"].ToString(),out tempLastEditTime)?tempLastEditTime: string .Now;
DateTime tempKnowledgeTime = DateTime.Now;
// knowledgepet.KnowledgeTime = string .TryParse(reader["KnowledgeTime"].ToString(),out tempKnowledgeTime)?tempKnowledgeTime: string .Now;
knowledgepet.IsVisible = bool.Parse(reader["IsVisible"].ToString());
knowledgepet.IP = reader["IP"].ToString();
int tempFocusNum = 0;
knowledgepet.FocusNum = int.TryParse(reader["FocusNum"].ToString(),out tempFocusNum)?tempFocusNum:0;
KnowledgePetList.Add(knowledgepet);
}
}
return KnowledgePetList;
}
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
{
KnowledgePet knowledgePet = new KnowledgePet();
CTKnowledgePet knowledgetable = new CTKnowledgePet();
knowledgetable = knowledgePet.GetKnowledgePetByKnowledgeID(sqlstr);
TextBox_KnowledgeID.Text = knowledgetable.KnowledgeID;
TextBox_MissIDInfo.Text = knowledgetable.KnowledgeInfo;
TextBox_AddressID.Text = knowledgetable.AddressID;
TextBox_KnowledgeTime.Text = knowledgetable.KnowledgeTime.ToString();
TextBox_KnowledgeTitle.Text = knowledgetable.KnowledgeTitle.ToString();
TextBox_FocusNum.Text = knowledgetable.FocusNum.ToString();
TextBox_IP.Text = knowledgetable.IP.ToString();
TextBox_PetCategoryID.Text = knowledgetable.PetCategoryID.ToString();
TextBox_PriorityScore.Text = knowledgetable.PriorityScore.ToString();
TextBox_UserID.Text = knowledgetable.UserID.ToString();
TextBox_WeiBoID.Text = knowledgetable.WeiBoID.ToString();
}
}
protected void Btn_Save_Click(object sender, EventArgs e)
{
if (TextBox_KnowledgeID.Text == "")
{
Response.Write("<script>alert('请选择一个编辑!')</script>");
}
else
{
CTKnowledgePet knowledgetable = new CTKnowledgePet();
knowledgetable.KnowledgeID = TextBox_KnowledgeID.Text;
knowledgetable.KnowledgeInfo = TextBox_MissIDInfo.Text;
knowledgetable.AddressID = TextBox_AddressID.Text;
knowledgetable.KnowledgeTime = TextBox_KnowledgeTime.Text.ToString();
knowledgetable.KnowledgeTitle = TextBox_KnowledgeTitle.Text.ToString();
knowledgetable.FocusNum = int.Parse(TextBox_FocusNum.Text.ToString());
knowledgetable.IP = TextBox_IP.Text.ToString();
knowledgetable.PetCategoryID = TextBox_PetCategoryID.Text.ToString();
knowledgetable.PriorityScore = int.Parse(TextBox_PriorityScore.Text.ToString());
knowledgetable.UserID = TextBox_UserID.Text.ToString();
knowledgetable.WeiBoID = TextBox_WeiBoID.Text.ToString();
knowledgetable.LastEditTime = DateTime.Now.ToShortDateString();
KnowledgePet knowledgepet = new KnowledgePet();
int editStatus = 0;
editStatus = knowledgepet.EditKnowledgePet(knowledgetable);
if (editStatus == 1)
{
Response.Write("<script>alert('Edit成功!')</script>");
}
else
{
Response.Write("<script>alert('Edit失败!')</script>");
}
}
}
//增加宠物知识信息
public int InsertKnowledgePet(CTKnowledgePet knowledgePet)
{
return dal.InsertKnowledgePet(knowledgePet);
}
//更新一篇knowledge的信息
public int EditKnowledgePet(CTKnowledgePet knowledgePet)
{
return dal.EditKnowledgePet(knowledgePet);
}
