public void dateshow(string title, string value)
{
OleDbDataAdapter da = new OleDbDataAdapter();
DataSet ds = new DataSet();
DataView dv = new DataView();
try
{
da = Dbconnect.datareader(title, value);
}
catch (Exception e)
{
MessageBox.Show(e.Message);
return;
}
da.Fill(ds);
dv = ds.Tables[0].DefaultView;
dv.AllowNew = false;
this.DATAGRID.DataSource = dv;//表从起始行显示在dataGridView里
this.DATAGRID.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.Fill;
DATAGRID.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
DATAGRID.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
this.DATAGRID.ReadOnly = true;
for (int i = 0; i < DATAGRID.RowCount; i++)
{
this.DATAGRID.Rows[i].Cells[0].Value = "False";
}
this.DATAGRID.ReadOnly = false;
this.DATAGRID.Columns["ID"].Visible = false;
for (int a = 0; a < ds.Tables[0].Columns.Count; a++)
{
this.DATAGRID.Columns[a + 2].ReadOnly = true;
}
backgroundchange();
}
private void dataFill()
{
OleDbDataReader data;
data = Dbconnect.changereader(ID);
nameBox.Text = data["客户姓名"].ToString();
carComboBox.Text = data["车行"].ToString();
bankComboBox.Text = data["经办支行"].ToString();
cardIdBox.Text = data["卡号"].ToString();
managerBox.Text = data["客户经理姓名"].ToString();
examineMoneyBox.Text = data["审批金额"].ToString();
carPriceBox.Text = data["车辆价格"].ToString();
carTypeBox.Text = data["购买车型"].ToString();
if (data["抵押情况"].ToString() == "1")
{
mortgate.Checked = true;
}
else
{
nomortgate.Checked = true;
}
if (data["系统申请"].ToString() == "1")
{
newsystem.Checked = true;
}
else
{
oldsystem.Checked = true;
}
MoneyOut.text = data["放款日期"].ToString().Replace("0:00:00", "");
ControlDate.text = data["车辆抵押日期"].ToString().Replace("0:00:00", "");
examineDate.text = data["二级分行审核日期"].ToString().Replace("0:00:00", "");
}
private void toolStripButton2_Click(object sender, EventArgs e)
{
ArrayList name = new ArrayList();
this.DATAGRID.ReadOnly = true;
for (int i = 0; i < DATAGRID.RowCount; i++)
{
string b;
DataGridViewCell checkbox = (DataGridViewCell)this.DATAGRID.Rows[i].Cells[0];
if ((string)checkbox.Value == "True")
{
b = DATAGRID.Rows[i].Cells[2].Value.ToString();
name.Add(b);
}
}
if (MessageBox.Show("确定删除" + name.Count + "条数据吗？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Asterisk) == DialogResult.OK)
{
Dbconnect dbconnect = new Dbconnect();
foreach (string a in name)
{
try
{
dbconnect.deletedata(a, path);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
this.DATAGRID.ReadOnly = false;
dateshow();
}
}
private void droplist()
{
OleDbDataReader bank, car;
bank = Dbconnect.bankcombobox();
while (bank.Read())
{
bankComboBox.Items.Add(bank[0].ToString()); //循环读区数据
}
car = Dbconnect.carcombobox();
while (car.Read())
{
carComboBox.Items.Add(car[0].ToString()); //循环读区数据
}
}
private void added()
{
string name, bank, car, manager, cardid, exampric, carpric, cartype, date, datecontrol, examdate;
int Mortgate = 0, system = 0;
name = nameBox.Text; car = carComboBox.Text; bank = bankComboBox.Text; cardid = cardIdBox.Text;
manager = managerBox.Text; exampric = examineMoneyBox.Text; carpric = carPriceBox.Text; cartype = carTypeBox.Text;
if (newsystem.Checked == true)
{
system = 1;
}
if (oldsystem.Checked == true)
{
system = 0;
}
if (nomortgate.Checked == true)
{
Mortgate = 0;
}
if (mortgate.Checked == true)
{
Mortgate = 1;
}
date = MoneyOut.Text; datecontrol = ControlDate.Text; examdate = examineDate.text;
Dbconnect db = new Dbconnect();
if (name != "" && bank != "" && car != "" && manager != "" && cartype != "" && date != "" && datecontrol != "" && cardid != "" && exampric != "")
{
try
{
db.addcarcombobox(car);
db.addnewdata(name, bank, car, manager, cardid, exampric, carpric, cartype, Mortgate, date, datecontrol, system, examdate);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
}
}
