private void LoginWord()
{
LoginDto loginDto = new LoginDto(txtname.Text, txtpassword.Text);
SQLUtilEvent sQLUtilEvent = new SQLUtilEvent(new LoginDto(txtname.Text, txtpassword.Text));
sQLUtilEvent.OnRunWorkerCompleted += new EventHandler <RunWorkerCompletedEventArgs>((object sender, RunWorkerCompletedEventArgs e) =>
{
DataSet ds = (DataSet)e.Result;
if (ds.Tables[0].Rows.Count == 1)
{
LocalConfig.SetConfigValue("name", txtname.Text);
LocalConfig.SetConfigValue("pwd", EncryptUtil.Md532(txtpassword.Text));
LocalConfig.SetConfigValue("username", ds.Tables[0].Rows[0]["username"].ToString());
loginDto.Username = ds.Tables[0].Rows[0]["username"].ToString();
Plan plan = new Plan(loginDto);
Hide();
plan.ShowDialog();
ProcessBarThread.Abort();
Application.ExitThread();
}
else
{
btnlogin.Enabled = true;
ProcessBarStop();
ShowMessageDialog("用户名密码错误");
}
});
sQLUtilEvent.Run("login");
}
/// <summary>
/// 查询事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Button1_Click(object sender, EventArgs e)
{
SQLUtilEvent sQLUtilEvent = new SQLUtilEvent(GetPlanListData());
sQLUtilEvent.OnRunWorkerCompleted += new EventHandler <RunWorkerCompletedEventArgs>((object senders, RunWorkerCompletedEventArgs es) =>
{
DataSet ds = (DataSet)es.Result;
CreateListView(ds.Tables[0]);
listStatus.Text = "总记录数：" + ds.Tables[0].Rows.Count;
Button1_Click_1(null, EventArgs.Empty);
loadpc.Visible = false;
btnsearch.Enabled = true;
lbtip.Text = "refresh success";
});
sQLUtilEvent.Run();
}
private void BtndelClickWork()
{
loadpc.Visible = true;
btndel.Enabled = false;
string filename = txtfilename.Text;
if (File.Exists(FilePath + "\\" + filename + ".rtf"))
{
File.Delete(FilePath + "\\" + filename + ".rtf");
}
string id = txtid.Text;
string sql = "";
if (!string.IsNullOrEmpty(id))
{
sql = @"delete from pasn where id=" + id + ";select " + id + "; ";
}
SQLUtilEvent sQLUtilEvent = new SQLUtilEvent(sql + GetPlanListData());
sQLUtilEvent.OnRunWorkerCompleted += new EventHandler <RunWorkerCompletedEventArgs>((object senders, RunWorkerCompletedEventArgs es) =>
{
DataSet result = (DataSet)es.Result;
ClearDetail();
CreateListView(result.Tables[1]);
listStatus.Text = "总记录数：" + result.Tables[1].Rows.Count;
Button1_Click_1(null, EventArgs.Empty);
loadpc.Visible = false;
btnsearch.Enabled = true;
loadpc.Visible = false;
btndel.Enabled = true;
lbtip.Text = "delete success";
MessageBoxEx.Show(this, "delete success");
});
sQLUtilEvent.Run();
//}));
}
public void FormInit()
{
SQLUtilEvent sQLUtilEvent = new SQLUtilEvent("select * from users");
sQLUtilEvent.OnRunWorkerCompleted += new EventHandler <RunWorkerCompletedEventArgs>((object senders, RunWorkerCompletedEventArgs es) =>
{
DataSet ds = (DataSet)es.Result;
ArrayList processor = new ArrayList();
foreach (DataRow dr in ds.Tables[0].Rows)
{
User u = new User();
u.Id = int.Parse(dr["id"].ToString());
u.UserId = dr["UserId"].ToString();
u.UserName = dr["UserName"].ToString();
u.Ty = int.Parse(dr["ty"].ToString());
if (u.Ty == 0)
{
processor.Add(u.UserName);
}
Users.Add(u);
}
SetComBoxDataSource(cbprocessor, (string[])processor.ToArray(typeof(string)), Login.Username);
processor.Add("全部");
SetComBoxDataSource(cbsearchprocessor, (string[])processor.ToArray(typeof(string)), "全部");
});
sQLUtilEvent.Run("sql");
Console.WriteLine("Init");
//loadpc.Visible = false;
ProcessBarStop();
if (!Directory.Exists(FilePath))
{
Directory.CreateDirectory(FilePath);
}
//dtsearchbegin.Format = DateTimePickerFormat.Custom;
//dtsearchbegin.CustomFormat = "yyyy-MM-dd";
DateTime dt = DateTime.Now;
dtsearchbegin.Text = dt.AddMonths(-1).ToString("yyy-MM-dd");
dtsearchend.Text = dt.ToString("yyy-MM-dd");
estimateDate.Text = dt.ToString("yyy-MM-dd");
//dtsearchend.Format = DateTimePickerFormat.Custom;
//dtsearchend.CustomFormat = "yyyy-MM-dd";
//estimateDate.Format = DateTimePickerFormat.Custom;
//estimateDate.CustomFormat = "yyyy-MM-dd";
StatusDataList = new Dictionary <string, string>()
{
{ "0", "进行中" }, { "1", "完成" }, { "4", "取消" }
};
SetComBoxDataSource(cbstatus, StatusDataList, "0");
//SetCB(cbprocessor, new string[] { "张茂洪", "高嘉富", "林自强", "钟少杰" }, loginDto.Username);
//SetCB(cbsearchprocessor, new string[] { "张茂洪", "高嘉富", "林自强", "钟少杰", "全部" }, "全部");
SetComBoxDataSource(cbsearchstatus, new Dictionary <string, string>()
{
{ "0", "进行中" }, { "1", "完成" }, { "4", "取消" }, { "-1", "全部" }
}, "-1");
//planlist.View = View.Details;
//planlist.CheckBoxes = false;
//planlist.FullRowSelect = true;
//PlanListColumn.Add(new ListColumn("日期", 135, "BizDate"));
//PlanListColumn.Add(new ListColumn("标题", 120, "title"));
//PlanListColumn.Add(new ListColumn("业务", 100, "relor"));
//PlanListColumn.Add(new ListColumn("预计完成", 100, "estimate"));
//PlanListColumn.Add(new ListColumn("状态", 100, "Status"));
//PlanListColumn.Add(new ListColumn("内容", 200, "Content"));
//PlanListColumn.Add(new ListColumn("完结人", 120, "compor"));
//PlanListColumn.Add(new ListColumn("完结日期", 120, "compDate"));
//PlanListColumn.Add(new ListColumn("修改人", 120, "modior"));
//PlanListColumn.Add(new ListColumn("修改日期", 120, "modidate"));
//PlanListColumn.Add(new ListColumn("文件名", 120, "filename"));
//PlanListColumn.Add(new ListColumn("制单人", 100, "creator"));
//PlanListColumn.Add(new ListColumn("备注", 200, "remark"));
//PlanListColumn.Add(new ListColumn("id", 0, "id"));
//foreach (ListColumn l in PlanListColumn)
//{
// ColumnHeader ch = new ColumnHeader();
// ch.Text = l.Text;
// ch.Width = l.Width;
// ch.TextAlign = l.M;
// planlist.Columns.Add(ch); //将列头添加到ListView控件。
//}
uiDataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
uiDataGridView1.AutoGenerateColumns = false;
//uiDataGridView1.AddColumn("日期", "BizDate", 135);
//uiDataGridView1.AddColumn("标题", "title", 120);
//uiDataGridView1.AddColumn("业务", "relor", 100);
//uiDataGridView1.AddColumn("预计完成", "estimate", 100);
//uiDataGridView1.AddColumn("状态", "Status", 100);
//uiDataGridView1.AddColumn("内容", "Content", 200);
//uiDataGridView1.AddColumn("完结人", "Compor", 120);
//uiDataGridView1.AddColumn("完结日期", "compDate", 120);
//uiDataGridView1.AddColumn("修改人", "modior", 120);
//uiDataGridView1.AddColumn("修改日期", "modidate", 120);
//uiDataGridView1.AddColumn("文件名", "filename", 120);
//uiDataGridView1.AddColumn("制单人", "creator", 100);
//uiDataGridView1.AddColumn("备注", "remark", 200);
uiDataGridView1.ReadOnly = true;
uiDataGridView1.CellFormatting +=
(object sen, DataGridViewCellFormattingEventArgs ev) =>
{
DataGridView dgv = (DataGridView)sen;
//得到当前要进行格式化设置的列
DataGridViewColumn column = uiDataGridView1.Columns[ev.ColumnIndex];
if (ev.Value == null)
{
return;
}
if (column.Name.EqualsIgnoreCase("Status"))
{
ev.Value = (ev.Value.ToString() == "0" ? "" : "√");
}
else if (column.Name.EqualsIgnoreCase("modior") || column.Name.EqualsIgnoreCase("creator"))
{
for (int i = 0; i < Users.Count; i++)
{
if (Users[i].UserId.EqualsIgnoreCase(ev.Value.ToString()))
{
ev.Value = Users[i].UserName;
}
}
}
};
for (int j = 0; j < uiDataGridView1.Columns.Count; j++)
{
string colName = uiDataGridView1.Columns[j].DataPropertyName;
if (colName.EqualsIgnoreCase("Status"))
{
uiDataGridView1.Columns[j].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
uiDataGridView1.Columns[j].Width = 50;
}
else if (colName.EqualsIgnoreCase("BizDate") || colName.EqualsIgnoreCase("estimate") || colName.EqualsIgnoreCase("compDate") || colName.EqualsIgnoreCase("modidate"))
{
uiDataGridView1.Columns[j].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
uiDataGridView1.Columns[j].Width = 100;
}
else if (colName.EqualsIgnoreCase("relor") || colName.EqualsIgnoreCase("Compor") || colName.EqualsIgnoreCase("modior") || colName.EqualsIgnoreCase("creator"))
{
uiDataGridView1.Columns[j].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
uiDataGridView1.Columns[j].Width = 70;
}
}
}
/// </summary>
private void SaveWork()
{
string content = null;
string status = "";
string processor = "";
string compor = "";
string estimate = "";
ProcessBarStart();
//loadpc.Visible = true;
content = ContentRTB.Text.Replace("\'", "\\\'");
estimate = estimateDate.Text;
btnsave.Enabled = false;
status = cbstatus.SelectedValue.ToString();
processor = cbprocessor.SelectedValue.ToString();
compor = txtcompor.Text.ToString();
string filename = txtfilename.Text;
string title = txttitle.Text;
string hour = txthour.Text.ToString();
if (hour.Length == 0)
{
hour = "0";
}
string remark = txtremark.Text;
string id = txtid.Text;
string relor = txtrelor.Text;
if (string.IsNullOrEmpty(id))
{
filename = NewFileName(filename, relor, title, remark);
}
ContentRTB.SaveFile(FilePath + "\\" + filename + ".rtf", RichTextBoxStreamType.RichText);
txtfilename.Text = filename;
//上传文件到服务器
try
{
FileUploadItem receive = new FileUploadItem();
receive.Address = UpFileAdrees;
receive.FileNamePath = FilePath + "\\" + filename + ".rtf";
receive.SaveName = filename;
FileUploadUtilEvent fileUploadUtilEvent = new FileUploadUtilEvent(receive);
fileUploadUtilEvent.OnProgressChanged += new EventHandler <ProgressChangedEventArgs>((object sender, ProgressChangedEventArgs e) => {
FileUploadUtilChange message = (FileUploadUtilChange)e.UserState;
lbtip.Text = "已用时：" + message.Second.ToString("F2") + "秒";
if (message.Second > 0.001)
{
lbtip.Text += " 平均速度：" + (message.Offset / 1024 / message.Second).ToString("0.00") + "KB/秒";
}
else
{
lbtip.Text += " 正在连接…";
}
lbtip.Text += "已上传：" + (message.Offset * 100.0 / message.Length).ToString("F2") + "%";
lbtip.Text += (message.Offset / 1048576.0).ToString("F2") + "M/" + (message.FileLength / 1048576.0).ToString("F2") + "M";
});
fileUploadUtilEvent.OnRunWorkerCompleted += new EventHandler <RunWorkerCompletedEventArgs>((object sender, RunWorkerCompletedEventArgs e) =>
{
int count = (int)e.Result;
if (count == 0)
{
ShowMessageDialog("上传文件服务器失败！，文件只保存在本地");
}
FileInfo fi = new FileInfo(FilePath + "\\" + filename + ".rtf");
DateTime dt = fi.LastWriteTime;
string sql = " ";
if (string.IsNullOrEmpty(id))
{
sql += @"insert pasn(title,BizDate,CreateDate,Creator,relor,Remark,Status,Content,filename,lastwritetime,processor,compor,hour,estimate)
values('" + title + "',now(),now(),'" + Login.Name + "','" + relor + "','" + remark + "','" + status + "','" + content + "','" + filename + "','" + dt.ToString("yyyy-MM-dd HH:mm:ss") + "','" + processor + "','" + compor + "','" + hour + "','" + estimate + "'); set @id=@@IDENTITY; ";
}
else
{
sql += @"update pasn set relor='" + relor + "',estimate='" + estimate + "',modiDate=now(),modior='" + Login.Name + "', title='" + title + "',Remark='" + remark + "',Status='" + status + "'," + (status == "1" ? "compDate=now()," : "") + "Content='" + content + "',lastwritetime='" + dt.ToString("yyyy-MM-dd HH:mm:ss") + "' ,processor='" + processor + "',compor='" + compor + "',hour='" + hour + "' where id=" + id + "; ";
sql += "set @id=" + id + ";";
}
sql += "select * from pasn where id=@id;";
try
{
//新增单据的时候，列表刷新一下。但少了一个选中怎么办
SQLUtilEvent sQLUtilSaveEvent = new SQLUtilEvent(sql);
sQLUtilSaveEvent.OnRunWorkerCompleted += new EventHandler <RunWorkerCompletedEventArgs>((object sendObj, RunWorkerCompletedEventArgs arg) =>
{
DataSet dataSave = (DataSet)arg.Result;
txtid.Text = dataSave.Tables[0].Rows[0]["id"].ToString();
lbtip.Text = "save success";
//前端新增一行
if (string.IsNullOrEmpty(id))
{
//新增单据的时候，列表刷新一下。但少了一个选中怎么办
SQLUtilEvent sQLUtilEvent = new SQLUtilEvent(GetPlanListData());
sQLUtilEvent.OnRunWorkerCompleted += new EventHandler <RunWorkerCompletedEventArgs>((object senders, RunWorkerCompletedEventArgs es) =>
{
DataSet dataSet = (DataSet)es.Result;
CreateListView(dataSet.Tables[0]);
listStatus.Text = "总记录数：" + dataSet.Tables[0].Rows.Count;
foreach (Record dr in Records)
{
if (dr.Id == int.Parse(txtid.Text))
{
uiDataGridView1.ClearSelection();
uiDataGridView1.CurrentCell = uiDataGridView1.Rows[Records.IndexOf(dr)].Cells[0];
uiDataGridView1.SelectedIndex = Records.IndexOf(dr);
}
}
//for (int i = 0; i < planlist.Items.Count; i++)
//{
// DataRow dr = (DataRow)planlist.Items[i].Tag;
// if (dr["id"].ToString() == txtid.Text)
// {
// planlist.Items[i].Selected = true;//选中
// planlist.Items[i].Focused = true; //焦点
// planlist.Items[i].EnsureVisible();//滚动显示
// }
//}
//loadpc.Visible = false;
ProcessBarStop();
btnsearch.Enabled = true;
//前端新增一行end
btnsave.Enabled = true;
//ShowMessageDialog("save success");
});
sQLUtilEvent.Run("sql");
}
else
{
//DataRow item = (DataRow)(planlist.SelectedItems[0]).Tag;
//planlist.SelectedItems[0].Tag = dataSave.Tables[0].Rows[0];
//foreach (ListColumn l in PlanListColumn)
//{
// planlist.SelectedItems[0].SubItems[PlanListColumn.IndexOf(l)].Text = dataSave.Tables[0].Rows[0][l.Key].ToString();
//}
Record data = new Record();
DataRow dr = dataSave.Tables[0].Rows[0];
data.BizDate = strToDateTime(dr["BizDate"].ToString());
data.Title = dr["title"].ToString();
data.Relor = dr["relor"].ToString();
data.Estimate = strToDateTime(dr["estimate"].ToString());
data.Status = dr["Status"].ToString();
data.Content = dr["Content"].ToString();
data.Compor = dr["compor"].ToString();
data.CompDate = strToDateTime(dr["compDate"].ToString());
data.Modior = dr["modior"].ToString();
data.Modidate = strToDateTime(dr["modidate"].ToString());
data.Filename = dr["filename"].ToString();
data.Creator = dr["creator"].ToString();
data.Remark = dr["remark"].ToString();
data.Id = int.Parse(dr["id"].ToString());
data.Hour = decimal.Parse(dr["hour"].ToString());
data.Processor = dr["processor"].ToString();
Records.Add(data);
for (int j = 0; j < uiDataGridView1.Columns.Count; j++)
{
string colName = uiDataGridView1.Columns[j].DataPropertyName;
uiDataGridView1.SelectedRows[0].Cells[colName].Value = data.GetType().GetProperty(colName, BindingFlags.Public | BindingFlags.IgnoreCase | BindingFlags.Instance).GetValue(data, null);
}
//前端新增一行end
//this.loadpc.Visible = false;
ProcessBarStop();
btnsave.Enabled = true;
//ShowMessageDialog("save success");
}
});
sQLUtilSaveEvent.Run("sql");
}
catch (Exception ex)
{
//loadpc.Visible = false;
ProcessBarStop();
btnsave.Enabled = true;
lbtip.Text = "erroe";
ShowMessageDialog(ex.GetBaseException().ToString());
}
});
fileUploadUtilEvent.Run();
}
catch (Exception ex)
{
ShowMessageDialog(ex.GetBaseException().ToString());
}
//上传文件到服务器end
}
/// <summary>
/// 保存
/// </summary>
private void SaveWork()
{
string content = null;
string status = "";
string processor = "";
string compor = "";
string estimate = "";
loadpc.Visible = true;
content = ContentRTB.Text.Replace("\'", "\\\'");
estimate = estimateDate.Text;
btnsave.Enabled = false;
status = cbstatus.SelectedValue.ToString();
processor = cbprocessor.SelectedValue.ToString();
compor = txtcompor.Text.ToString();
string filename = txtfilename.Text;
string title = txttitle.Text;
string hour = txthour.Text.ToString();
if (hour.Length == 0)
{
hour = "0";
}
string remark = txtremark.Text;
string id = txtid.Text;
string relor = txtrelor.Text;
if (string.IsNullOrEmpty(id))
{
filename = NewFileName(filename, relor, title, remark);
}
ContentRTB.SaveFile(FilePath + "\\" + filename + ".rtf", RichTextBoxStreamType.RichText);
txtfilename.Text = filename;
//上传文件到服务器
try
{
FileUploadItem receive = new FileUploadItem();
receive.Address = UpFileAdrees;
receive.FileNamePath = FilePath + "\\" + filename + ".rtf";
receive.SaveName = filename;
FileUploadUtilEvent fileUploadUtilEvent = new FileUploadUtilEvent(receive);
fileUploadUtilEvent.OnProgressChanged += new EventHandler <ProgressChangedEventArgs>((object sender, ProgressChangedEventArgs e) => {
FileUploadUtilChange message = (FileUploadUtilChange)e.UserState;
lbtip.Text = "已用时：" + message.Second.ToString("F2") + "秒";
if (message.Second > 0.001)
{
lbtip.Text += " 平均速度：" + (message.Offset / 1024 / message.Second).ToString("0.00") + "KB/秒";
}
else
{
lbtip.Text += " 正在连接…";
}
lbtip.Text += "已上传：" + (message.Offset * 100.0 / message.Length).ToString("F2") + "%";
lbtip.Text += (message.Offset / 1048576.0).ToString("F2") + "M/" + (message.FileLength / 1048576.0).ToString("F2") + "M";
});
fileUploadUtilEvent.OnRunWorkerCompleted += new EventHandler <RunWorkerCompletedEventArgs>((object sender, RunWorkerCompletedEventArgs e) =>
{
int count = (int)e.Result;
if (count == 0)
{
MessageBoxEx.Show(this, "上传文件服务器失败！，文件只保存在本地");
}
FileInfo fi = new FileInfo(FilePath + "\\" + filename + ".rtf");
DateTime dt = fi.LastWriteTime;
string sql = " ";
if (string.IsNullOrEmpty(id))
{
sql += @"insert pasn(title,BizDate,CreateDate,Creator,relor,Remark,Status,Content,filename,lastwritetime,processor,compor,hour,estimate)
values('" + title + "',now(),now(),'" + name + "','" + relor + "','" + remark + "','" + status + "','" + content + "','" + filename + "','" + dt.ToString("yyyy-MM-dd HH:mm:ss") + "','" + processor + "','" + compor + "','" + hour + "','" + estimate + "'); set @id=@@IDENTITY; ";
}
else
{
sql += @"update pasn set relor='" + relor + "',estimate='" + estimate + "',modiDate=now(),modior='" + name + "', title='" + title + "',Remark='" + remark + "',Status='" + status + "'," + (status == "1" ? "compDate=now()," : "") + "Content='" + content + "',lastwritetime='" + dt.ToString("yyyy-MM-dd HH:mm:ss") + "' ,processor='" + processor + "',compor='" + compor + "',hour='" + hour + "' where id=" + id + "; ";
sql += "set @id=" + id + ";";
}
sql += "select * from pasn where id=@id;";
try
{
//新增单据的时候，列表刷新一下。但少了一个选中怎么办
SQLUtilEvent sQLUtilSaveEvent = new SQLUtilEvent(sql);
sQLUtilSaveEvent.OnRunWorkerCompleted += new EventHandler <RunWorkerCompletedEventArgs>((object sendObj, RunWorkerCompletedEventArgs arg) =>
{
DataSet dataSave = (DataSet)arg.Result;
txtid.Text = dataSave.Tables[0].Rows[0]["id"].ToString();
//前端新增一行
if (string.IsNullOrEmpty(id))
{
//新增单据的时候，列表刷新一下。但少了一个选中怎么办
SQLUtilEvent sQLUtilEvent = new SQLUtilEvent(GetPlanListData());
sQLUtilEvent.OnRunWorkerCompleted += new EventHandler <RunWorkerCompletedEventArgs>((object senders, RunWorkerCompletedEventArgs es) =>
{
DataSet dataSet = (DataSet)es.Result;
CreateListView(dataSet.Tables[0]);
listStatus.Text = "总记录数：" + dataSet.Tables[0].Rows.Count;
for (int i = 0; i < planlist.Items.Count; i++)
{
DataRow dr = (DataRow)planlist.Items[i].Tag;
if (dr["id"].ToString() == txtid.Text)
{
planlist.Items[i].Selected = true; //选中
planlist.Items[i].Focused = true; //焦点
planlist.Items[i].EnsureVisible(); //滚动显示
}
}
loadpc.Visible = false;
btnsearch.Enabled = true;
lbtip.Text = "refresh success";
//前端新增一行end
btnsave.Enabled = true;
MessageBoxEx.Show(this, "save success");
});
sQLUtilEvent.Run();
}
else
{
DataRow item = (DataRow)(planlist.SelectedItems[0]).Tag;
planlist.SelectedItems[0].Tag = dataSave.Tables[0].Rows[0];
foreach (ListColumn l in PlanListColumn)
{
planlist.SelectedItems[0].SubItems[PlanListColumn.IndexOf(l)].Text = dataSave.Tables[0].Rows[0][l.Key].ToString();
}
//前端新增一行end
this.loadpc.Visible = false;
btnsave.Enabled = true;
lbtip.Text = "save success";
MessageBoxEx.Show(this, "save success");
}
});
sQLUtilSaveEvent.Run();
}
catch (Exception ex)
{
loadpc.Visible = false;
btnsave.Enabled = true;
lbtip.Text = "erroe";
MessageBoxEx.Show(this, "" + ex.GetBaseException());
}
});
fileUploadUtilEvent.Run();
}
catch (Exception ex)
{
MessageBoxEx.Show(this, "" + ex.GetBaseException());
}
//上传文件到服务器end
}
