public bool Insert(String InputContent,String InputDeadline,String Class1,string atfriends,string allowpeople)
{
//插入项
String publisher = Parameters.username;
String content = InputContent;
String time = DateTime.Now.ToString("yyyy-MM-dd " + "HH:mm:ss");
String deadline = InputDeadline;
String classi = Class1;
int authority = Parameters.messlevel;
String state = "未拼";
int pageview = 0;
//连接事件数据库&空间数据库
String conEventStr = Parameters.event_info;
String conSpatialStr = Parameters.spatial_info;
//插入发布人事件表
String cmdEventInsert = "insert into AllEvents(Event_Publisher,Event_Content,Event_PublishTime,Event_Deadline,Event_Class,Event_Authority,Event_State,Event_Pageview,Event_At,Event_Allowpeople) values('" + publisher + "','" + content + "','" + time + "','" + deadline + "','" + classi + "','" + authority + "','" + state + "','" + pageview + "','" + atfriends + "','" + allowpeople+ "')";
DTConnection con = new DTConnection();
int result = con.UpdateCon(cmdEventInsert, conEventStr);
//插入AT人事件表
if (atfriends != null)
{
String state2 = "好友@";
string[] atlist = atfriends.Split(',');
for (int i = 0; i < atlist.Count(); i++)
{
String cmdEventInsert2 = "insert into AllEvents(Event_Publisher,Event_Content,Event_PublishTime,Event_Deadline,Event_Class,Event_Authority,Event_State,Event_Pageview,Event_Allowpeople) values('" + atlist[i] + "','" + InputContent + "','" + time + "','" + deadline + "','" + classi + "','" + authority + "','" + state2 + "','" + pageview + "','" + allowpeople + "')";
DTConnection con2 = new DTConnection();
con2.UpdateCon(cmdEventInsert2, conEventStr);
}
}
//空间数据库
//查询对应的Eventid插入空间数据库aaaa
String cmdEventSelect = "select Event_Id from AllEvents where Event_Id=(select max(Event_Id) from Allevents)";
List<String[]> reader = con.ReadCon(cmdEventSelect, conEventStr);
int id = int.Parse(reader[0][0]);
//将该id和事件内容更新到对应的空间数据库中
String cmdSpatialInsert = "update EventLocation set EL_EventId='" + id + "',EL_Content='" + content + "' where EL_LocateId=(select max(EL_LocateId) from EventLocation )";
con.UpdateCon(cmdSpatialInsert, conSpatialStr);
if (result == -1)
{
return false;//发布失败
}
else
{
return true;//发布成功
}
}
//修改密码
public int ModifyPassword(String NewPassword)
{
string commandTextUpdate = @"update Student set Password = '******' Where Name = '" + Parameters.username + "';";
DTConnection con = new DTConnection();
int num = con.UpdateCon(connectionString, commandTextUpdate);
return num;
}
//将数据插入数据库的方法
public void GetInsert()
{
string connectionString = Parameters.user_info;
string commandTextUpdate = "update MerchantInfo set Merchant_ShopName='" + ShopName + "',Merchant_BusinessHour = '" + BusinessHour + "',Merchant_Name = '" + Name + "',Merchant_Address ='" + Address + "',Merchant_Telephone ='" + Telephone
+ "',Merchant_ShopAge = '" + ShopAge + "',Merchant_Email ='" + Email + "',Merchant_CellphoneNumber ='" + CellphoneNumber + "' ,Merchant_Sign = '" + Sign
+ "' Where Name = '" + Parameters.username + "';";
DTConnection con = new DTConnection();
con.UpdateCon(commandTextUpdate, connectionString);
}
//将数据插入数据库的方法
public void GetInsert()
{
string connectionString = Parameters.user_info;
string commandTextUpdate = "update AdminInfo set AdminInfo_Sex = '" + Sex + "',AdminInfo_Age = '" + Age + "',AdminInfo_Email ='" + Email + "',AdminInfo_PhoneNumber ='" + PhoneNumber + "' ,AdminInfo_WorkPlace = '" + WorkPlace
+ "',AdminInfo_NickName='" + NickName + "' ,StudentInfo_Icon = '" + Iconpath
+ "' Where Name = '" + Parameters.username + "';";//用户名的问题
DTConnection con = new DTConnection();
con.UpdateCon(commandTextUpdate, connectionString);
}
//将数据插入数据库
public void GetInsert()
{
string connectionString = Parameters.user_info;
string commandTextUpdate = "update StudentInfo set StudentInfo_Gender = '" + Gender + "',StudentInfo_NickName = '" + NickName + "',StudentInfo_Address ='" + Address + "',StudentInfo_Degree ='" + Degree
+ "',StudentInfo_StudentId = '" + StudentId + "',StudentInfo_Email ='" + Email + "',StudentInfo_Academy = '" + Academy
+ "',StudentInfo_PhoneNumber ='" + PhoneNumber + "' ,StudentInfo_Sign = '" + Sign + "' ,StudentInfo_Icon = '" +Iconpath
+ "' Where StudentInfo_NickName = '" + Parameters.username + "';";
/************************/
DTConnection con = new DTConnection();
con.UpdateCon(commandTextUpdate, connectionString);
}
public void Insert(String name, String password, int sort)
{
//匹配
corr1.Add("@username");
corr1.Add("@password");
corr2.Add(name);
corr2.Add(password);
String insertText = null;
switch (sort)
{
case 0:
{
insertText = "Insert Into StudentInfo(StudentInfo_NickName,StudentInfo_Password) values('" + name + "','" + password + "')";
break;
}
case 1:
{
insertText = "Insert Into MerchantInfo(Merchant_Name,Merchant_Password) values('" + name + "','" + password + "')";
break;
}
case 2:
{
insertText = "Insert Into AdminInfo(AdminInfo_NickName,AdminInfo_Password) values('" + name + "','" + password + "')";
break;
}
}
String connectionString = Parameters.user_info;
DTConnection con = new DTConnection();
string a = "insert into StudentInfo(StudentInfo_NickName,StudentInfo_Password) values('" + name + "','" + password + "')";
//插入信息
int result = con.UpdateCon(insertText, connectionString);
if (result == 1)
{
MessageBox.Show("注册成功！");
}
else
{
MessageBox.Show("注册失败！");
}
UILogin r = new UILogin();
r.Show();
}
// 下拉框选择拼友
private void chooseFollower(object sender, EventArgs e)
{
ComboBox cbox = sender as ComboBox;
int idc = int.Parse(cbox.Name);
int select = cbox.SelectedIndex;
String connectionString = Parameters.event_info;
String followername = cbox.SelectedItem.ToString();
String commandUpdate = "update AllEvents set Event_Follower = '" + followername + "' where Event_Id=" + idc + ";";
DTConnection con = new DTConnection();
try
{
con.UpdateCon(commandUpdate, connectionString);
cbox.Visible = false;
MessageBox.Show("此事件接洽成功！\n系统将立即通知[" + followername + "],也请您尽快与之联系.");
//修改数据库
int IDc = int.Parse(cbox.Name);
String constr = Parameters.event_info;
String Update = "update AllEvents set Event_State = " + "'已拼'" + " where Event_Id = " + IDc + ";";
con.UpdateCon(Update, constr);
InitializeForm();
}
catch
{
MessageBox.Show("对不起，请稍后重试！");
}
}
//点击未拼更改拼状态
void statei_Click(object sender, EventArgs e)
{
Button btn = sender as Button;
if (btn.Text == "未拼")
{
btn.BackColor = Color.Green;
btn.Text = "已拼";
int IDc = int.Parse(btn.Name);
String connectionString = Parameters.event_info;
DTConnection con = new DTConnection();
String commandUpdate = "update AllEvents set Event_State = " + "'已拼'" + " where Event_Id = " + IDc + ";";
con.UpdateCon(commandUpdate, connectionString);
}
else
{
MessageBox.Show("事件已拼成功");
}
}
//我想拼
void llblAccept_Click(object sender, EventArgs e)
{
LinkLabel llbl = sender as LinkLabel;
String id = llbl.Name;
String connectionString = Parameters.event_info;
DTConnection con = new DTConnection();
String SeleStr = "select * from AllEvents where Event_Id ='" + id + "'";
List<String[]> reader=con.ReadCon(SeleStr, connectionString);
string followers = Parameters.username;
string tempfollow = reader[0][9];
if (tempfollow.Length == 0)
{
tempfollow += followers;
}
else
{
tempfollow += "," + followers;
}
String Updatestr = "update AllEvents set Event_Follower = '" + tempfollow + " 'where Event_Id = " + id + ";";
con.UpdateCon(Updatestr, connectionString);
MessageBox.Show("请求已发送");
}
private void Details_Load(object sender, EventArgs e)
{
//根据ID，查询事件
String constr = Parameters.event_info;
String commandTextQuery1 = "select * from AllEvents where Event_Id = '" + thiseventid + "'";
DTConnection con = new DTConnection();
readEvent = con.ReadCon(commandTextQuery1, constr);
//加载发布人姓名
lblPublisherNme.Text = readEvent[0][2].ToString();
//加载事件状态
lblState.Text = "事件："+readEvent[0][1].ToString();
//加载发布时间，截止时间
lblSendTime.Text = "发送时间："+readEvent[0][3].ToString();
lblDeadline.Text = "截至时间："+readEvent[0][4].ToString();
//发布人头像
string connectionString= Parameters.user_info;
String SlctIcon = "select * from StudentInfo where StudentInfo_NickName = '" + PublisherName + "'";
List<String[]> readIcon=con.ReadCon(SlctIcon, connectionString);
string iconpath = new DirectoryInfo("../../../").FullName+readIcon[0][11];
this.pboxPublisherIcon.SizeMode = PictureBoxSizeMode.Zoom;
this.pboxPublisherIcon.Image = Image.FromFile(iconpath);
//关注按钮文本
string selectstr = "select * from FollowUser where FollowUser_FollowerName ='" + Parameters.username + "' and FollowUser_UserName='******'";
List<String[]> haveFollow = con.ReadCon(selectstr, connectionString);
if (haveFollow.Count == 0)
{
this.btnFollowPublisher.Text = "关注TA";
}
else
{
this.btnFollowPublisher.Text = "取消关注";
}
//事件内容
String EventContent = readEvent[0][7].ToString();
content.Text = EventContent.Substring(0, EventContent.IndexOf("】") + 1);
content.Text += "\n " + EventContent.Substring(EventContent.IndexOf("】") + 1, EventContent.Length - EventContent.IndexOf("】") - 1);
pboxPublisherIcon.BackColor = Color.MistyRose;
//浏览量
int ViewNum = int.Parse(readEvent[0][8].ToString());
//加载意向接洽者
if (readEvent[0][9].ToString().Length > 0)
{
lblCurrentFollowers.Text = "目前有" + readEvent[0][9].ToString() + "愿意接洽该事件";
}
else
{
lblCurrentFollowers.Text = "暂时无人接洽该事件";
}
ViewNum++;
lblPageview.Text = "浏览量:" + ViewNum + "次";
//更新浏览量
String commandUpdate = "update AllEvents set Event_Pageview ='" + ViewNum + "' where Event_Id = '" + thiseventid + "';";
con.UpdateCon(commandUpdate, constr);
//显示评论
String selectStr = "select* from Event_Comments where Comment_EventId = '" + thiseventid + "'";
List<String[]> readComments = con.ReadCon(selectStr, constr);
//通过循环列表显示查询结果集
for (int ii = 0; ii < readComments.Count; ii++)
{
if (readComments[ii][3] != null)
{
//用户 内容 发布时间
String comment = readComments[ii][4].ToString().Trim() + "说: " + " " + readComments[ii][3].ToString().Trim() + "\n";
this.rboxComments.AppendText(comment);
this.rboxComments.Refresh();
}
}
}
private void transmit_Click(object sender, EventArgs e)
{
string follower = Parameters.username;
string tempfollow = readEvent[0][9].ToString();
string connectionString = Parameters.event_info;
if (tempfollow.Length == 0)
{
tempfollow += follower;
}
else
{
tempfollow += "," + follower;
}
String Updatestr = "update AllEvents set Event_Follower = '" + tempfollow + " 'where Event_Id = " + thiseventid + ";";
DTConnection con = new DTConnection();
con.UpdateCon(Updatestr, connectionString);
MessageBox.Show("请求已发送");
}