private void BingDataControl(mMeeting model, int index)
{
//画控件
PanelEx pxMain = new PanelEx();
pxMain.Width = 1238;
pxMain.Height = 55;
pxMain.BorderColor = Color.FromArgb(((int)(((byte)(141)))), ((int)(((byte)(141)))), ((int)(((byte)(141)))));
pxMain.BackColor = Color.White;
pxMain.Location = new Point(0, index * 58);
plMain.Controls.Add(pxMain);
Label label = new Label();
label.Font = new System.Drawing.Font("宋体", 12F);
label.ForeColor = System.Drawing.Color.Black;
label.Location = new System.Drawing.Point(14, 18);
label.AutoSize = true;
label.Text = (index + 1) + ". " + model.MeetingName + " 计划开始时间: " + model.StartDate + " 计划结束时间: " + model.EendDate;
pxMain.Controls.Add(label);
PanelEx pxBtn = new PanelEx();
pxBtn.BackgroundImage = Resources.join;
pxBtn.Cursor = System.Windows.Forms.Cursors.Hand;
pxBtn.Click += new System.EventHandler(this.pbBtn_Click);
pxBtn.Location = new System.Drawing.Point(1130, 12);
pxBtn.Size = new System.Drawing.Size(78, 30);
pxBtn.Tag = model.MeetingId;
pxBtn.AutoSize = false;
pxMain.Controls.Add(pxBtn);
}
/// <summary>
/// 实体转换
/// </summary>
/// <param name="meeting"></param>
/// <param name="model"></param>
private void GetMeetingRecordModel(mMeeting meeting, MeetingRecord model)
{
string[] array = GetstringSpilit(meeting.MeetingName);
if (array.Length > 0)
{
model.Year = GetStringToNum(array[0]);
model.Num = GetStringToNum(array[2]);
model.TotalNum = GetStringToNum(array[4]);
}
model.MeetingId = meeting.MeetingId;
model.StartDate = Convert.ToDateTime(meeting.StartDate).ToString("yyyy-MM-dd HH:mm");
model.EendDate = Convert.ToDateTime(meeting.EendDate).ToString("yyyy-MM-dd HH:mm");
model.MeetingAddress = meeting.AddressName;
model.MeetingHost = Convert.ToInt32(meeting.MeetingHost);
model.MeetingSecretary = meeting.MeetingSecretary;
model.MeetingDocument = Convert.ToInt32(meeting.MeetingDocument);
model.DepartId = meeting.DepartId;
model.IssueName = meeting.IssueName;
model.RepostUser = meeting.RepostUser;
model.MeetingName = meeting.MeetingName;
model.MeetingHostName = meeting.MeetingHostName;
model.MeetingDocumentName = meeting.MeetingDocumentName;
model.MeetingSecretaryName = meeting.MeetingSecretaryName;
model.RepostUserName = meeting.RepostUserName;
//model.DepartName = meeting.DepartName;
model.DepartName = meeting.newDepartName;
}
/// <summary>
/// 重载方法
/// </summary>
/// <param name="meetingId"></param>
/// <returns></returns>
public static mMeeting GetMeetingModel(string meetingId)
{
mMeeting model = new mMeeting();
model.IssueList = new mMeetingIssue();
//mMeetingIssue issue = null;
string sql = @"select m.MeetingId,MeetingName,StartDate,EendDate,AddressName,IssueName,
HostName=(select UserName from m_User u where u.UserId=m.MeetingHost),
SecretaryName=(select UserName from m_User u where u.UserId=m.MeetingSecretary),
MeetingDocument=(select UserName from m_User u where u.UserId=m.MeetingDocument),
peopleName=(select [dbo].[GetMeetingPeople](@meetingId)),m.IssueName,
LeavePeople=(select [dbo].[GetMeetingPeopleOther](@meetingId,1)),
AttendPeople=(select [dbo].[GetMeetingPeopleOther](@meetingId,2)),
RepostUser=(select UserName from m_User u where u.UserId=m.RepostUser),
Directory=(select top 1 Directory from m_MeetingResources mr where mr.MeetingIssueId=m.MeetingId),
d.DepartName,m.type,m.MeetingType,newDepartName from m_Meeting m
left join m_Depart d on m.DepartId=d.Id
where m.MeetingId=@meetingId and Type=0";
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@meetingId", meetingId),
};
SqlDataReader reader = SQLHelper.GetReader(sql, paras);
while (reader.Read())
{
model.IssueList.IssueName = reader["IssueName"].ToString();
model.IssueList.RepostUser = reader["RepostUser"].ToString();
//model.IssueList.DepartName = reader["DepartName"].ToString();
model.IssueList.DepartName = reader["newDepartName"].ToString();
//model.IssueList.Id = Tool.ToInt(reader["Id"].ToString());
model.MeetingId = Tool.ToInt(reader["MeetingId"].ToString());
model.MeetingName = reader["MeetingName"].ToString();
model.StartDate = Convert.ToDateTime(reader["StartDate"]).ToString("yyyy-MM-dd HH:mm");
model.EendDate = Convert.ToDateTime(reader["EendDate"]).ToString("yyyy-MM-dd HH:mm");
model.AddressName = reader["AddressName"].ToString();
model.MeetingHost = reader["HostName"].ToString();
model.SecretaryName = reader["SecretaryName"].ToString();
model.MeetingDocument = reader["MeetingDocument"].ToString();
model.PeopleName = reader["PeopleName"].ToString();
model.LeavePeople = reader["LeavePeople"].ToString();
model.AttendPeople = reader["AttendPeople"].ToString();
model.Directory = reader["Directory"].ToString();
model.Type = Tool.ToInt(reader["Type"].ToString());
model.MeetingType = Tool.ToInt(reader["MeetingType"].ToString());
}
return(model);
}
private void pxSave_Click(object sender, EventArgs e)
{
List <mMeetingPeople> modeList = new List <mMeetingPeople>();
//会议保存
mMeeting model = new mMeeting();
model.MeetingName = "检委会" + text1.Text.Trim() + "年 第" + text2.Text.Trim() + "次 总第" + text3.Text.Trim() + "次会议";
model.StartDate = dateStart.Value.ToString("yyyy-MM-dd HH:mm");
model.EendDate = dateEnd.Value.ToString("yyyy-MM-dd HH:mm");
model.MeetingAddress = watermarkTextBox1.Text.Trim();
model.MeetingHost = comboBox2.SelectedValue.ToString();
foreach (var item in panelEx12.Controls)
{
if (item is CheckBox)
{
CheckBox chk = (CheckBox)item;
if (chk.Checked == true)
{
mMeetingPeople people = new mMeetingPeople();
people.UserId = Convert.ToInt32(chk.Tag);
people.RoleId = 4;
modeList.Add(people);
}
}
}
model.IssueList = new mMeetingIssue();
model.IssueList.IssueName = text4.Text.Trim();
model.IssueList.DepartId = Convert.ToInt32(comboBox6.SelectedValue);
model.IssueList.RepostUserId = Convert.ToInt32(comboBox5.SelectedValue);
//先上传资料到服务器 然后将数据存入到数据库
string date = DateTime.Now.ToString("yyyyMMddHHmmsss");
foreach (var item in resources)
{
string url = ConfigurationManager.AppSettings["saveUrl"].ToString();
item.ResourcesName = date + "/" + item.ResourcesName;
//WebClient webclient = new WebClient();
//webclient.UploadFile(url, "POST", item.ResourcesUrl);
Helper.UploadFileHttpRequest(item.ResourcesUrl, url, date);
}
if (imeeting.SaveMeeting(resources, modeList, model) > 0)
{
MessageBox.Show("保存成功");
FrmMain main = new FrmMain(_nickname);
main.Show();
Hide();
}
resources.Clear();
}
private string _directory = ""; //这次会议 上传材料的根目录
private void Initial(string meetingId)
{
mMeeting model = imeeting.GetMeetingModel(Convert.ToInt32(meetingId));
label4.Text = model.MeetingName;
label5.Text = model.StartDate;
label6.Text = model.EendDate;
label11.Text = model.MeetingAddress;
label14.Text = model.MeetingHost;
label22.Text = model.SecretaryName;
label12.Text = model.PeopleName;
_directory = model.Directory;
}
private string _directory = ""; //这次会议 上传材料的根目录
private void Initial(string meetingId)
{
mMeeting model = imeeting.GetMeetingModel(Convert.ToInt32(meetingId));
label4.Text = model.MeetingName;
label5.Text = model.StartDate;
label6.Text = model.EendDate;
label11.Text = model.MeetingAddress;
label14.Text = model.MeetingHost;
label22.Text = model.SecretaryName;
label12.Text = model.PeopleName;
label24.Text = model.IssueList.IssueName;
label25.Text = model.IssueList.RepostUser;
label26.Text = model.IssueList.DepartName;
_directory = model.Directory;
_issueid = model.IssueList.Id;
}
/// <summary>
/// 获取会议记录
/// </summary>
/// <returns></returns>
public ActionResult MeetingRecord(MeetingSearch search)
{
TitleViewModel model = new TitleViewModel();
//mMeeting meetingModel = imeeting.GetMeetingModel(search.MeetingId);
string message = "";
mMeeting meetingModel = new mMeeting();
meetingModel.MeetingId = search.MeetingId;
model.Title = "材料: 会议记录";
model.TopTitle = "材料: 会议记录";
model.RerurnButton = "/MeetingInfo/Index?MeetingId=" + search.MeetingId;
ViewBag.TitleViewModel = model;
//model.RerurnHomeButton = Consts.UrlPath+"/Upload/SaveWord?directory="+search.MeetingId;
meetingModel.Directory = string.Format("{0}{1}/{2}", Consts.DwonUrlPath, search.MeetingId, search.MeetingId + ".docx");
WordHelper.Word2HtmlFromFileSaveFileHtml(meetingModel.Directory, Consts.SaveUrlPath + "1.html", out message);
meetingModel.Directory = string.Format("{0}{1}", Consts.DwonUrlPath, "1.html");
return(View(meetingModel));
}
public List <mMeeting> GetDataSetList(DataTable dataTable)
{
List <mMeeting> modeList = new List <mMeeting>();
mMeeting model = null;
if (dataTable != null && dataTable.Rows.Count > 0)
{
foreach (DataRow item in dataTable.Rows)
{
model = new mMeeting();
model.RowId = Tool.ToInt(item["RowId"].ToString());
model.MeetingId = Tool.ToInt(item["MeetingId"].ToString());
model.MeetingName = item["MeetingName"].ToString();
model.StartDate = Convert.ToDateTime(item["StartDate"]).ToString("yyyy-MM-dd HH:mm");
model.EendDate = Convert.ToDateTime(item["EendDate"]).ToString("yyyy-MM-dd HH:mm");
modeList.Add(model);
}
}
return(modeList);
}
private void GetDataSetList(DataTable dataTable)
{
//获取数据集
mMeeting model = null;
if (dataTable != null && dataTable.Rows.Count > 0)
{
int index = 0;
foreach (DataRow item in dataTable.Rows)
{
model = new mMeeting();
model.RowId = Tool.ToInt(item["RowId"].ToString());
model.MeetingId = Tool.ToInt(item["MeetingId"].ToString());
model.MeetingName = item["MeetingName"].ToString();
model.StartDate = Convert.ToDateTime(item["StartDate"]).ToString("yyyy-MM-dd HH:mm");
model.EendDate = Convert.ToDateTime(item["EendDate"]).ToString("yyyy-MM-dd HH:mm");
BingDataControl(model, index);
index++;
}
}
}
public ActionResult Index(MeetingSearch search)
{
TitleViewModel model = new TitleViewModel();
mMeeting meetingModel = null;
try
{
model.TopTitle = "会议详情";
model.Title = "会议详情";
model.RerurnButton = "/Home/Index?pageindex=" + 1;
model.RerurnHomeButton = "/Home/Index?pageindex=" + 1;
ViewBag.TitleViewModel = model;
meetingModel = imeeting.GetMeetingModel(search.MeetingId);
}
catch (Exception ex)
{
log.Error("Index-" + DateTime.Now.ToString(), ex);
}
return(View(meetingModel));
}
public static int SaveMeeting(List <mMeetingResources> resources, List <mMeetingPeople> people, mMeeting meeting)
{
int result = 0;
string meetingsql = string.Format(@"insert into [m_Meeting](MeetingName,StartDate,EendDate,AddressId,
MeetingHost,MeetingDocument,MeetingCreateDate,MeetingType,
MeetingSecretary) values('{0}','{1}',
'{2}','{3}','{4}','{5}','{6}','{7}','{8}');select @@identity", meeting.MeetingName, meeting.StartDate,
meeting.EendDate, meeting.MeetingAddress, meeting.MeetingHost, meeting.MeetingDocument,
DateTime.Now.ToString(),
0, meeting.MeetingSecretary);
int meetingid = SQLHelper.ExcuteScalarSQL(meetingsql);
if (meetingid > 0)
{
string issuesql = string.Format(@"insert into [m_MeetingIssue](IssueName,RepostUser,DepartId,
MeetingId) values('{0}','{1}','{2}','{3}');select @@identity", meeting.IssueList.IssueName,
meeting.IssueList.RepostUserId, meeting.IssueList.DepartId, meetingid);
StringBuilder builder = new StringBuilder();
foreach (var item in people)
{
builder.AppendFormat("insert into [m_MeetingPeople] (MeetingId,UserId,RoleId) values('{0}','{1}','{2}');", meetingid, item.UserId, item.RoleId);
}
int issueId = SQLHelper.ExcuteScalarSQL(builder.ToString() + issuesql);
if (issueId > 0)
{
builder.Clear();
foreach (var item in resources)
{
builder.AppendFormat(@"insert into [m_MeetingResources] (ResourcesName,
ResourcesType,MeetingIssueId) values ('{0}','{1}','{2}');", item.ResourcesName, item.ResourcesType, issueId);
}
result = SQLHelper.ExcuteSQL(builder.ToString());
}
}
return(result);
}
public int SaveMeeting(List <mMeetingResources> resources, List <mMeetingPeople> people, mMeeting meeting)
{
return(MeetingDao.SaveMeeting(resources, people, meeting));
}
