private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
if (RowRemark >= dataGridView1.RowCount)
{
return;
}
List <clsFAinfo> SaveResult = new List <clsFAinfo>();
clsFAinfo item = new clsFAinfo();
item.fapiaohao = this.dataGridView1.Rows[RowRemark].Cells["发票号"].EditedFormattedValue.ToString();
item.danganhao = this.dataGridView1.Rows[RowRemark].Cells["档案号"].EditedFormattedValue.ToString();
item.bianhao = this.dataGridView1.Rows[RowRemark].Cells["编号"].EditedFormattedValue.ToString();
item.jigoudaima = this.dataGridView1.Rows[RowRemark].Cells["机构代码"].EditedFormattedValue.ToString();
item.fapiaoleixing = this.dataGridView1.Rows[RowRemark].Cells["发票类型"].EditedFormattedValue.ToString();
item.Input_Date = DateTime.Now.ToString("yyyyMMdd-HHmmss");
item.R_id = IDclick;
item.guidangrenzhanghao = guidangren;
SaveResult.Add(item);
clsAllnew BusinessHelp = new clsAllnew();
BusinessHelp.updateFA_Server(SaveResult);
InitialSystemInfo();
}
private void dataGridView2_CellClick(object sender, DataGridViewCellEventArgs e)
{
RowRemark = e.RowIndex;
cloumn = e.ColumnIndex;
if (RowRemark != -1)
{
clsFAinfo item = new clsFAinfo();
item.danganhao = this.dataGridView2.Rows[RowRemark].Cells["档号列表"].EditedFormattedValue.ToString();
item.jigoudaima = this.dataGridView2.Rows[RowRemark].Cells["归档人"].EditedFormattedValue.ToString();
ApplyFilter3(item.danganhao, item.jigoudaima);
}
}
private void notifyToolStripMenuItem_Click(object sender, EventArgs e)
{
if (RowRemark >= dataGridView1.Rows.Count)
{
RowRemark = RowRemark - 1;
}
clsFAinfo item = new clsFAinfo();
item.fapiaohao = this.dataGridView1.Rows[RowRemark].Cells["发票号"].EditedFormattedValue.ToString();
item.danganhao = this.dataGridView1.Rows[RowRemark].Cells["档案号"].EditedFormattedValue.ToString();
item.jigoudaima = this.dataGridView1.Rows[RowRemark].Cells["机构代码"].EditedFormattedValue.ToString();
clsAllnew BusinessHelp = new clsAllnew();
BusinessHelp.deletefapiao(item);
InitialSystemInfo();
}
public void deletefapiao(clsFAinfo item)
{
string connectionString = "mongodb://127.0.0.1";
connectionString = ipadress;
MongoServer server = MongoServer.Create(connectionString);
MongoDatabase db1 = server.GetDatabase("FA_datawork_HRB");
MongoCollection collection1 = db1.GetCollection("FA_datawork_HRB_FA");
MongoCollection <BsonDocument> employees = db1.GetCollection <BsonDocument>("FA_datawork_HRB_FA");
if (item == null)
{
MessageBox.Show("No Data input Sever", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//QueryDocument query = new QueryDocument("name", name);
var dd = Query.And(Query.EQ("fapiaohao", item.fapiaohao), Query.EQ("danganhao", item.danganhao), Query.EQ("jigoudaima", item.jigoudaima));//同时满足多个条件
collection1.Remove(dd);
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
RowRemark = e.RowIndex;
cloumn = e.ColumnIndex;
if (RowRemark < 0)
{
return;
}
clsFAinfo item = new clsFAinfo();
item.fapiaohao = this.dataGridView1.Rows[RowRemark].Cells["发票号"].EditedFormattedValue.ToString();
item.danganhao = this.dataGridView1.Rows[RowRemark].Cells["档案号"].EditedFormattedValue.ToString();
item.bianhao = this.dataGridView1.Rows[RowRemark].Cells["编号"].EditedFormattedValue.ToString();
item.jigoudaima = this.dataGridView1.Rows[RowRemark].Cells["机构代码"].EditedFormattedValue.ToString();
//var pendingorder = Result.Find(o => o.QiHao == id.ToString());
clsFAinfo stock = this.Result.Find(o => (o.fapiaohao == item.fapiaohao && o.danganhao == item.danganhao && o.jigoudaima == item.jigoudaima));
if (stock != null)
{
IDclick = stock.R_id;
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text != "" && this.textBox2.Text != "")
{
int len = Convert.ToInt32(textBox2.Text) - Convert.ToInt32(textBox1.Text);
clslen_listinfo item = new clslen_listinfo();
item.len = len;
item.Start_No = textBox1.Text;
item.End_No = textBox2.Text;
#region 判断逻辑
//clslen_listinfo stock = this.len_list.Find(o => (o.Start_No == textBox1.Text || o.End_No == textBox2.Text));
//if (stock != null)
//{
// MessageBox.Show("不能本次重复添加相同起始发票和结束发票！", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
// return;
//}
#endregion
len_list.Add(item);
//
int len12 = 0;
foreach (clslen_listinfo itemin in len_list)
{
len12 = len12 + Convert.ToInt32(itemin.End_No) - Convert.ToInt32(itemin.Start_No) + 1;
}
if (textBox3.Text != "")
{
string[] feilianxifapiao = System.Text.RegularExpressions.Regex.Split(textBox3.Text, " ");
len12 = len12 + feilianxifapiao.Length;
}
if (len12 > 0)
{
toolStripLabel1.Text = "共计发票条目：" + len12;
toolStripLabel1.BackColor = System.Drawing.Color.Red;
}
}
#region add show
{
if (stockNOTextBox.Text == "")
{
MessageBox.Show("档号不能为空，请选择机构代码&发票类型", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
List <clsFAinfo> Result = new List <clsFAinfo>();
int sss = 0;
if (textBox1.Text != "" && this.textBox2.Text != "")
{
//多次段位添加
if (len_list != null && len_list.Count > 0)
{
int rowindex = 0;
foreach (clslen_listinfo itemin in len_list)
{
int len = Convert.ToInt32(itemin.End_No) - Convert.ToInt32(itemin.Start_No);
if (len < 0)
{
return;
}
for (int i = 0; i <= len; i++)
{
clsFAinfo item = new clsFAinfo();
int ssl = Convert.ToInt32(itemin.Start_No) + i;
//不全填入发票和以0开头的位数
int weishu0 = itemin.Start_No.Length - Convert.ToInt32(itemin.Start_No).ToString().Length;
string ssl_string = ssl.ToString();
if (weishu0 > 0)
{
for (int j = 0; j < weishu0; j++)
{
ssl_string = "0" + ssl_string;
}
}
item.fapiaohao = ssl_string;
item.jigoudaima = comboBox1.Text;
item.fapiaoleixing = comboBox2.Text.Substring(0, 2);
item.danganhao = stockNOTextBox.Text;
item.Input_Date = DateTime.Now.ToString("yyyyMMdd-HHmmss");
item.guidangrenzhanghao = guidangren;
sss = rowindex + 1;
item.bianhao = sss.ToString().PadLeft(4, '0');
Result.Add(item);
rowindex++;
}
}
}
else
{
int len = Convert.ToInt32(textBox2.Text) - Convert.ToInt32(textBox1.Text);
if (len < 0)
{
return;
}
for (int i = 0; i <= len; i++)
{
clsFAinfo item = new clsFAinfo();
int ssl = Convert.ToInt32(textBox1.Text) + i;
item.fapiaohao = ssl.ToString();
item.jigoudaima = comboBox1.Text;
item.fapiaoleixing = comboBox2.Text.Substring(0, 2);
item.danganhao = stockNOTextBox.Text;
item.Input_Date = DateTime.Now.ToString("yyyyMMdd-HHmmss");
item.guidangrenzhanghao = guidangren;
sss = i + 1;
item.bianhao = sss.ToString().PadLeft(4, '0');
Result.Add(item);
}
}
}
if (this.textBox3.Text != "")
{
if (textBox3.Text != "")
{
string[] feilianxifapiao = System.Text.RegularExpressions.Regex.Split(textBox3.Text, " ");
for (int i = 0; i < feilianxifapiao.Length; i++)
{
clsFAinfo item = new clsFAinfo();
item.fapiaohao = feilianxifapiao[i];
item.jigoudaima = comboBox1.Text;
item.fapiaoleixing = comboBox2.Text.Substring(0, 2);
item.danganhao = stockNOTextBox.Text;
item.Input_Date = DateTime.Now.ToString("yyyyMMdd-HHmmss");
item.guidangrenzhanghao = guidangren;
sss = sss + 1;
item.bianhao = sss.ToString().PadLeft(4, '0');
Result.Add(item);
}
}
}
//清空段位的 集合
//len_list = new List<clslen_listinfo>();
if (Result.Count != 0)
{
toolStripLabel1.Text = "发票条目：" + Result.Count;
//InitialSystemInfo();
this.dataGridView1.AutoGenerateColumns = false;
sortablePendingOrderList = new SortableBindingList <clsFAinfo>(Result);
this.bindingSource1.DataSource = sortablePendingOrderList;
this.dataGridView1.DataSource = this.bindingSource1;
}
}
#endregion
}
private void toolStripButton3_Click(object sender, EventArgs e)
{
if (stockNOTextBox.Text == "")
{
MessageBox.Show("档号不能为空，请选择机构代码&发票类型", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
List <clsFAinfo> Result = new List <clsFAinfo>();
int sss = 0;
if (textBox1.Text != "" && this.textBox2.Text != "")
{
//多次段位添加
if (len_list != null && len_list.Count > 0)
{
int rowindex = 0;
foreach (clslen_listinfo itemin in len_list)
{
int len = Convert.ToInt32(itemin.End_No) - Convert.ToInt32(itemin.Start_No);
if (len < 0)
{
return;
}
for (int i = 0; i <= len; i++)
{
clsFAinfo item = new clsFAinfo();
int ssl = Convert.ToInt32(itemin.Start_No) + i;
//不全填入发票和以0开头的位数
int weishu0 = itemin.Start_No.Length - Convert.ToInt32(itemin.Start_No).ToString().Length;
string ssl_string = ssl.ToString();
if (weishu0 > 0)
{
for (int j = 0; j < weishu0; j++)
{
ssl_string = "0" + ssl_string;
}
}
item.fapiaohao = ssl_string;
item.jigoudaima = comboBox1.Text;
item.fapiaoleixing = comboBox2.Text.Substring(0, 2);
item.danganhao = stockNOTextBox.Text;
item.Input_Date = DateTime.Now.ToString("yyyyMMdd-HHmmss");
item.guidangrenzhanghao = guidangren;
sss = rowindex + 1;
item.bianhao = sss.ToString().PadLeft(4, '0');
Result.Add(item);
rowindex++;
}
}
}
else
{
int len = Convert.ToInt32(textBox2.Text) - Convert.ToInt32(textBox1.Text);
if (len < 0)
{
return;
}
for (int i = 0; i <= len; i++)
{
clsFAinfo item = new clsFAinfo();
int ssl = Convert.ToInt32(textBox1.Text) + i;
item.fapiaohao = ssl.ToString();
item.jigoudaima = comboBox1.Text;
item.fapiaoleixing = comboBox2.Text.Substring(0, 2);
item.danganhao = stockNOTextBox.Text;
item.Input_Date = DateTime.Now.ToString("yyyyMMdd-HHmmss");
item.guidangrenzhanghao = guidangren;
sss = i + 1;
item.bianhao = sss.ToString().PadLeft(4, '0');
Result.Add(item);
}
}
}
if (this.textBox3.Text != "")
{
if (textBox3.Text != "")
{
string[] feilianxifapiao = System.Text.RegularExpressions.Regex.Split(textBox3.Text, " ");
for (int i = 0; i < feilianxifapiao.Length; i++)
{
clsFAinfo item = new clsFAinfo();
item.fapiaohao = feilianxifapiao[i];
item.jigoudaima = comboBox1.Text;
item.fapiaoleixing = comboBox2.Text.Substring(0, 2);
item.danganhao = stockNOTextBox.Text;
item.Input_Date = DateTime.Now.ToString("yyyyMMdd-HHmmss");
item.guidangrenzhanghao = guidangren;
sss = sss + 1;
item.bianhao = sss.ToString().PadLeft(4, '0');
Result.Add(item);
}
}
}
//清空段位的 集合
len_list = new List <clslen_listinfo>();
if (Result.Count != 0)
{
clsAllnew BusinessHelp = new clsAllnew();
BusinessHelp.createFapiao_Server(Result);
toolStripLabel1.Text = "已保存发票条目：" + Result.Count;
//InitialSystemInfo();
this.dataGridView1.AutoGenerateColumns = false;
sortablePendingOrderList = new SortableBindingList <clsFAinfo>(Result);
this.bindingSource1.DataSource = sortablePendingOrderList;
this.dataGridView1.DataSource = this.bindingSource1;
}
}
public List <clsFAinfo> findFapiao_user(string jigoudaima, string fapiaoleixing, string guidangren)
{
#region Read database info server
try
{
List <clsFAinfo> ClaimReport_Server = new List <clsFAinfo>();
string connectionString = "mongodb://127.0.0.1";
connectionString = ipadress;
MongoServer server = MongoServer.Create(connectionString);
MongoDatabase db1 = server.GetDatabase("FA_datawork_HRB");
MongoCollection collection1 = db1.GetCollection("FA_datawork_HRB_FA");
MongoCollection <BsonDocument> employees = db1.GetCollection <BsonDocument>("FA_datawork_HRB_FA");
var query = new QueryDocument("danganhao", jigoudaima);
// var dd = Query.And(Query.EQ("jigoudaima", jigoudaima), Query.EQ("fapiaoleixing", fapiaoleixing));//同时满足多个条件
foreach (BsonDocument emp in employees.Find(query))
{
clsFAinfo item = new clsFAinfo();
#region 数据
if (emp.Contains("_id"))
{
item.R_id = (emp["_id"].ToString());
}
if (emp.Contains("fapiaohao"))
{
item.fapiaohao = (emp["fapiaohao"].ToString());
}
if (emp.Contains("danganhao"))
{
item.danganhao = (emp["danganhao"].ToString());
}
if (emp.Contains("bianhao"))
{
item.bianhao = (emp["bianhao"].ToString());
}
if (emp.Contains("guidangrenzhanghao"))
{
item.guidangrenzhanghao = (emp["guidangrenzhanghao"].AsString);
}
if (emp.Contains("Input_Date"))
{
item.Input_Date = (emp["Input_Date"].AsString);
}
if (emp.Contains("jigoudaima"))
{
item.jigoudaima = (emp["jigoudaima"].AsString);
}
if (emp.Contains("fapiaoleixing"))
{
item.fapiaoleixing = (emp["fapiaoleixing"].AsString);
}
#endregion
ClaimReport_Server.Add(item);
}
// collection1.RemoveAll();
query = new QueryDocument("fapiaohao", fapiaoleixing);
// IMongoQuery query1 = Query.EQ("fapiaohao", new ObjectId(fapiaoleixing));
// var dd = Query.And(Query.EQ("fapiaohao", fapiaoleixing));
foreach (BsonDocument emp in employees.Find(query))
{
clsFAinfo item = new clsFAinfo();
#region 数据
if (emp.Contains("_id"))
{
item.R_id = (emp["_id"].ToString());
}
if (emp.Contains("fapiaohao"))
{
item.fapiaohao = (emp["fapiaohao"].ToString());
}
if (emp.Contains("danganhao"))
{
item.danganhao = (emp["danganhao"].ToString());
}
if (emp.Contains("bianhao"))
{
item.bianhao = (emp["bianhao"].ToString());
}
if (emp.Contains("guidangrenzhanghao"))
{
item.guidangrenzhanghao = (emp["guidangrenzhanghao"].AsString);
}
if (emp.Contains("Input_Date"))
{
item.Input_Date = (emp["Input_Date"].AsString);
}
if (emp.Contains("jigoudaima"))
{
item.jigoudaima = (emp["jigoudaima"].AsString);
}
if (emp.Contains("fapiaoleixing"))
{
item.fapiaoleixing = (emp["fapiaoleixing"].AsString);
}
#endregion
ClaimReport_Server.Add(item);
}
query = new QueryDocument("guidangrenzhanghao", guidangren);
foreach (BsonDocument emp in employees.Find(query))
{
clsFAinfo item = new clsFAinfo();
#region 数据
if (emp.Contains("_id"))
{
item.R_id = (emp["_id"].ToString());
}
if (emp.Contains("fapiaohao"))
{
item.fapiaohao = (emp["fapiaohao"].ToString());
}
if (emp.Contains("danganhao"))
{
item.danganhao = (emp["danganhao"].ToString());
}
if (emp.Contains("bianhao"))
{
item.bianhao = (emp["bianhao"].ToString());
}
if (emp.Contains("guidangrenzhanghao"))
{
item.guidangrenzhanghao = (emp["guidangrenzhanghao"].AsString);
}
if (emp.Contains("Input_Date"))
{
item.Input_Date = (emp["Input_Date"].AsString);
}
if (emp.Contains("jigoudaima"))
{
item.jigoudaima = (emp["jigoudaima"].AsString);
}
if (emp.Contains("fapiaoleixing"))
{
item.fapiaoleixing = (emp["fapiaoleixing"].AsString);
}
#endregion
ClaimReport_Server.Add(item);
}
// query = new QueryDocument("guidangrenzhanghao", guidangren);
var query1 = Query.And(Query.GTE("Lurushijian", jigoudaima.Replace("/", "")), Query.LTE("Lurushijian", fapiaoleixing.Replace("/", "")));
foreach (BsonDocument emp in employees.Find(query1))
{
clsFAinfo item = new clsFAinfo();
#region 数据
if (emp.Contains("_id"))
{
item.R_id = (emp["_id"].ToString());
}
if (emp.Contains("fapiaohao"))
{
item.fapiaohao = (emp["fapiaohao"].ToString());
}
if (emp.Contains("danganhao"))
{
item.danganhao = (emp["danganhao"].ToString());
}
if (emp.Contains("bianhao"))
{
item.bianhao = (emp["bianhao"].ToString());
}
if (emp.Contains("guidangrenzhanghao"))
{
item.guidangrenzhanghao = (emp["guidangrenzhanghao"].AsString);
}
if (emp.Contains("Input_Date"))
{
item.Input_Date = (emp["Input_Date"].AsString);
}
if (emp.Contains("jigoudaima"))
{
item.jigoudaima = (emp["jigoudaima"].AsString);
}
if (emp.Contains("fapiaoleixing"))
{
item.fapiaoleixing = (emp["fapiaoleixing"].AsString);
}
#endregion
ClaimReport_Server.Add(item);
}
return(ClaimReport_Server);
}
catch (Exception ex)
{
MessageBox.Show("" + ex);
return(null);
throw ex;
}
#endregion
}
public List <clsFAinfo> findAll_Fapiao()
{
#region Read database info server
try
{
List <clsFAinfo> ClaimReport_Server = new List <clsFAinfo>();
string connectionString = "mongodb://127.0.0.1";
connectionString = ipadress;
MongoServer server = MongoServer.Create(connectionString);
MongoDatabase db1 = server.GetDatabase("FA_datawork_HRB");
MongoCollection collection1 = db1.GetCollection("FA_datawork_HRB_FA");
MongoCollection <BsonDocument> employees = db1.GetCollection <BsonDocument>("FA_datawork_HRB_FA");
foreach (BsonDocument emp in employees.FindAll())
{
clsFAinfo item = new clsFAinfo();
#region 数据
if (emp.Contains("_id"))
{
item.R_id = (emp["_id"].ToString());
}
if (emp.Contains("fapiaohao"))
{
item.fapiaohao = (emp["fapiaohao"].ToString());
}
if (emp.Contains("danganhao"))
{
item.danganhao = (emp["danganhao"].ToString());
}
if (emp.Contains("bianhao"))
{
item.bianhao = (emp["bianhao"].ToString());
}
if (emp.Contains("guidangrenzhanghao"))
{
item.guidangrenzhanghao = (emp["guidangrenzhanghao"].AsString);
}
if (emp.Contains("Input_Date"))
{
item.Input_Date = (emp["Input_Date"].AsString);
}
if (emp.Contains("jigoudaima"))
{
item.jigoudaima = (emp["jigoudaima"].AsString);
}
if (emp.Contains("fapiaoleixing"))
{
item.fapiaoleixing = (emp["fapiaoleixing"].AsString);
}
#endregion
ClaimReport_Server.Add(item);
}
return(ClaimReport_Server);
}
catch (Exception ex)
{
MessageBox.Show("" + ex);
return(null);
throw ex;
}
#endregion
}
