private void Window_Loaded(object sender, RoutedEventArgs e)
{
AccessCUID acuid = new AccessCUID();
lvwContact.ItemsSource = acuid.Query("select * from 客户联系人", "C:\\WORK\\MyData\\数据集.accdb").DefaultView;
lvwCompany.ItemsSource = acuid.Query("select * from 客户公司", "C:\\WORK\\MyData\\数据集.accdb").DefaultView;
}
private void checkpassword()
{
string sql = "select * from 用户 where 用户名='" + tbUser.Text + "' and 密码='" + tbPassword.Password + "'";
string currentDir = "C:\\WORK\\";
if (tbUser.Text != "舒丁")
{
currentDir = "D:\\";
}
AccessCUID acuid = new AccessCUID();
try
{
if (acuid.Query(sql, currentDir + "MyData\\dataset.accdb").Rows.Count > 0)
{
MainWindow workspace = new MainWindow();
workspace.UserName = tbUser.Text;
workspace.CurrentDir = currentDir;
workspace.Show();
this.Close();
}
else
{
MessageBox.Show("用户名或密码错误！");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void btnLink_Click(object sender, RoutedEventArgs e)
{
string sql = "insert into 名称对应表 values ('" + clientFullName + "','" + cmbClientList.Text + "')";
AccessCUID acuid = new AccessCUID();
acuid.Update(sql, "C:\\WORK\\MyData\\数据集.accdb");
MessageBox.Show("已关联");
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
string sql = "select * from 客户公司 order by 简称 asc";
AccessCUID acuid = new AccessCUID();
cmbClientList.ItemsSource = acuid.Query(sql, "C:\\WORK\\MyData\\数据集.accdb").AsDataView();
cmbClientList.DisplayMemberPath = "简称";
lbClientName.Content = clientFullName;
}
//把数据显示在自定义的listview中
private int ShowList(string sql, string path)
{
AccessCUID acuid = new AccessCUID();
System.Data.DataTable dt = new System.Data.DataTable();
dt = acuid.Query(sql, path);
//lvw3.ItemsSource = DTtoAbstracts(dt);
lvw3.ItemsSource = DTtoAbstracts1(dt);
lvw3.View = lvw3.FindResource("tileView") as ViewBase;
return(dt.Rows.Count);
}
private void btnTest_Click(object sender, RoutedEventArgs e)
{
AccessCUID acuid = new AccessCUID();
string sql = "Select * from 案件任务,案件信息 where 案件任务.我方案号=案件信息.我方案号 and 案件任务.我方案号='" + CaseID + "' order by 初稿时限 asc";
DataTable dt = new DataTable();
dt = acuid.Query(sql, "C:\\WORK\\MyData\\数据集.accdb");
lvwCaseFlow.ItemsSource = DTtoTaskDetail(dt);
lvwCaseFlow.View = lvwCaseFlow.FindResource("tileView") as ViewBase;
}
private void btnAddAffair_Click(object sender, RoutedEventArgs e)
{
AccessCUID acuid = new AccessCUID();
string sql = "insert into 事务表(发起人,事项描述,发起时间,标签) values ('" + tbStarter.Text + "','" + tbDescription.Text + "','" + DateTime.Now + "','" + tbTag.Text + "')";
acuid.Update(sql, "C:\\WORK\\MyData\\dataset.accdb");
DateTime now = DateTime.Now;
string tagPlusDate = tbTag.Text + now.Year.ToString() + now.Month.ToString() + now.Day.ToString();
CreateFolder(tagPlusDate);
}
//刷新案件历史
private void Button_Click(object sender, RoutedEventArgs e)
{
string sql = "Select * from 案件任务 where";
sql = sql + " (我方案号 like '%" + AttorneyNum + "%') order by 初稿时限 asc";
AccessCUID acuid = new AccessCUID();
System.Data.DataTable dt = new System.Data.DataTable();
dt = acuid.Query(sql, "C:\\WORK\\MyData\\dataset.accdb");
//MessageBox.Show(dt.Rows.Count.ToString());
lvwHistory.ItemsSource = dt.DefaultView;
}
//确认添加
private void btnConfirm_Click(object sender, RoutedEventArgs e)
{
try
{
if (tbName.Text != "")
{
string sql = "insert into 客户联系人(姓名,座机,邮箱,公司,手机,部门) values ('" + tbName.Text + "','" + tbTel.Text + "','" + tbEmail.Text + "','" + tbCompany.Text + "','" + tbPhone.Text + "','" + tbDept.Text + "')";
AccessCUID acuid = new AccessCUID();
acuid.Update(sql, "C:\\WORK\\MyData\\数据集.accdb");
MessageBox.Show("已添加");
}
else
{
MessageBox.Show("姓名不能为空！");
}
}
catch
{
}
}
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
if (lvwTransaction.SelectedIndex < 0)
{
MessageBox.Show("未选中任何项");
}
else
{
DataRowView obj = (DataRowView)lvwTransaction.SelectedItem;
DataRow dr = obj.Row;
//DateTime sdate = (DateTime)dr["发起时间"];
string starter = dr["发起人"].ToString();
string tag = dr["标签"].ToString();
AccessCUID acuid = new AccessCUID();
string sql = "delete from 事务表 where (发起人= '" + starter + "'and 标签 ='" + tag + "')";
if (MessageBox.Show("是否删除选择的事务", "确认删除", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
acuid.Update(sql, "C:\\WORK\\MyData\\dataset.accdb");
lvwTransaction.ItemsSource = acuid.Query("select * from 事务表 order by 发起时间 desc", "C:\\WORK\\MyData\\dataset.accdb").DefaultView;
}
}
}
private void btnRefresh_Click(object sender, RoutedEventArgs e)
{
string pathCases = CurrentDir + "MyData\\案件列表.xls";
string pathTasks = CurrentDir + "MyData\\任务列表.xls";
System.Data.DataTable dtCases = new System.Data.DataTable();
System.Data.DataTable dtTasks = new System.Data.DataTable();
AccessCUID acuid = new AccessCUID();
ExcelCUID exlcuid = new ExcelCUID();
acuid.Update("delete * from Tasks", CurrentDir + "MyData\\dataset.accdb");
acuid.Update("delete * from Cases", CurrentDir + "MyData\\dataset.accdb");
string sqlCases = "select * from [Sheet1$] order by 委案日期 desc";
string sqlTasks = "select * from [Sheet1$] order by 配案日 desc";
//string sqlTasks = "select * from [Sheet1$] where 承办人='" + UserName + "' order by 配案日 desc";
dtCases = exlcuid.Query(sqlCases, pathCases);
dtTasks = exlcuid.Query(sqlTasks, pathTasks);
UpdateAccess(dtCases, CurrentDir + "MyData\\dataset.accdb", "select * from Cases");
UpdateAccess(dtTasks, CurrentDir + "MyData\\dataset.accdb", "select * from Tasks");
showWeight();
MessageBox.Show("已刷新！");
}
private WeightData CalculateWeight2(DateTime startDate, DateTime endDate, string sql)
{
WeightData wtdt = new WeightData();
wtdt.Totalweight = 0;
sql = sql + "between #" + startDate + "# and #" + endDate + "#)";
AccessCUID acuid = new AccessCUID();
System.Data.DataTable dt = acuid.Query(sql, CurrentDir + "MyData\\dataset.accdb");
dt.Columns.Add("权值", typeof(double));
foreach (DataRow dr in dt.Rows)
{
string taskType = dr["申请类型"].ToString() + dr["任务名称"].ToString() + dr["任务属性"].ToString() + dr["任务标识"].ToString();
double taskWeight = 0;
switch (taskType)
{
case "PCT国际申请新申请":
taskWeight = 1.2;
break;
case "PCT国际申请撰写":
taskWeight = 1.2;
break;
case "PCT国际申请改写":
taskWeight = 0.5;
break;
case "发明新申请":
case "发明新申请撰写":
taskWeight = 1;
break;
case "实用新型新申请":
case "实用新型新申请撰写":
taskWeight = 0.7;
break;
case "发明OA答复一通实质(S)":
taskWeight = 0.4;
break;
case "发明OA答复二通实质(S)":
case "实用新型OA答复一通实质(S)":
taskWeight = 0.2;
break;
case "发明OA答复三通实质(S)":
case "发明OA答复四通实质(S)":
taskWeight = 0.1;
break;
case "发明OA答复一通形式-非本人失误(XN)":
case "发明OA答复二通形式-非本人失误(XN)":
case "发明OA答复三通形式-非本人失误(XN)":
case "实用新型OA答复一通形式-非本人失误(XN)":
case "实用新型OA答复二通形式-非本人失误(XN)":
taskWeight = 0.1;
break;
default:
taskWeight = 0;
break;
}
dr["权值"] = taskWeight;
wtdt.Totalweight = wtdt.Totalweight + taskWeight;
}
wtdt.ResultTable = dt;
return(wtdt);
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
AccessCUID acuid = new AccessCUID();
lvwTransaction.ItemsSource = acuid.Query("select * from 事务表 order by 发起时间 desc", "C:\\WORK\\MyData\\dataset.accdb").DefaultView;
}
private void tbSearchContact_TextChanged(object sender, TextChangedEventArgs e)
{
AccessCUID acuid = new AccessCUID();
lvwContact.ItemsSource = acuid.Query("select * from 客户联系人 where 姓名 like '%" + tbSearchContact.Text + "%'", "C:\\WORK\\MyData\\数据集.accdb").DefaultView;
}
//更新信息
private void UpdateInfo(string sql, string path)
{
AccessCUID acuid = new AccessCUID();
acuid.Update(sql, path);
}
