private void Search() { string classical = this.cbClassical.Text.Trim(); string type = this.cbType.Text.Trim(); if (classical == string.Empty && type == string.Empty) { // MessageBoxHelper.Show("请至少选择一个条件再查询!"); return; } string condition = "where 1=1 "; if (classical != string.Empty) { condition += " and cn_classical like '%" + classical + "%'"; } if (type != string.Empty && type != "请选择") { condition += " and cn_type like '%" + type + "%'"; } VehiclePhotoAccess access = new VehiclePhotoAccess(); this.photos = access.SearchList(condition); this.ReloadCollection(); }
public ArrayList SearchList(string condition) { ArrayList list = new ArrayList(); string sql = "select id,cn_classical,cn_type,picture,suffix,xuhao from table_vehicle_photo " + condition + " order by cn_classical,cn_type"; DataTable dt = this.access.SelectDataTable(sql, "table_vehicle_photo"); if (dt != null) { foreach (DataRow dr in dt.Rows) { list.Add(VehiclePhotoAccess.GetFromDataRow(dr)); } } return(list); }
private void btnDelete_Click(object sender, EventArgs e) { if (this.listView1.SelectedIndices != null && this.listView1.SelectedIndices.Count == 1) { VehiclePhoto temp = this.photos[this.listView1.SelectedIndices[0]] as VehiclePhoto; if (MessageBoxHelper.Confirm("确定删除" + temp.Cn_Classical + "-" + temp.Cn_Type + "吗?")) { VehiclePhotoAccess access = new VehiclePhotoAccess(); if (access.Delete(temp)) { this.photos.RemoveAt(this.listView1.SelectedIndices[0]); this.listView1.Items.Remove(this.listView1.SelectedItems[0]); } } } else { MessageBoxHelper.Show("请先选中需要删除的照片!"); } }
private void btnDelete_Click(object sender, EventArgs e) { if (this.listView1.SelectedIndices != null && this.listView1.SelectedIndices.Count == 1) { VehiclePhoto temp = this.photos[this.listView1.SelectedIndices[0]] as VehiclePhoto; if (MessageBoxHelper.Confirm("ȷ��ɾ��" + temp.Cn_Classical + "-" + temp.Cn_Type + "��")) { VehiclePhotoAccess access = new VehiclePhotoAccess(); if (access.Delete(temp)) { this.photos.RemoveAt(this.listView1.SelectedIndices[0]); this.listView1.Items.Remove(this.listView1.SelectedItems[0]); } } } else { MessageBoxHelper.Show("����ѡ����Ҫɾ������Ƭ��"); } }
private void Search() { string classical = this.cbClassical.Text.Trim(); string type = this.cbType.Text.Trim(); if (classical == string.Empty && type == string.Empty) { // MessageBoxHelper.Show("������ѡ��һ�������ٲ�ѯ��"); return; } string condition = "where 1=1 "; if (classical != string.Empty) { condition += " and cn_classical like '%" + classical + "%'"; } if (type != string.Empty && type != "��ѡ��") { condition += " and cn_type like '%" + type + "%'"; } VehiclePhotoAccess access = new VehiclePhotoAccess(); this.photos = access.SearchList(condition); this.ReloadCollection(); }
private void btnSave_Click(object sender, EventArgs e) { if (this.picPhoto.Image == null) { MessageBoxHelper.Show("请先选择一个照片!"); return; } string classical = this.cbClassical.Text.Trim(); string type = this.cbType.Text.Trim(); if (classical == string.Empty || classical == "请选择") { MessageBoxHelper.Show("请选择或者输入中文品牌!"); return; } if (type == string.Empty || type == "请选择") { MessageBoxHelper.Show("请选择或者输入车辆型号!"); return; } VehiclePhotoAccess access = new VehiclePhotoAccess(); VehiclePhoto photo = new VehiclePhoto(); photo.Cn_Classical = classical; photo.Cn_Type = type; photo.Picture = this.picPhoto.Image; photo.Suffix = this.suffix; bool result = access.Add(photo); if (result) { if (access.UpdateImage(access.GetLasted().Id, photo.Picture)) { object obj = access.ExecuteScalar("select count(*) from table_dict where c_grouptype='中文品牌' and c_text='" + this.cbClassical.Text + "'"); if (Convert.ToInt32(obj) == 0) { Dict temp = new Dict(); temp.Text = this.cbClassical.Text; temp.Value = this.cbClassical.Text; temp.Valid = "有效"; temp.GroupType = "中文品牌"; temp.Description = temp.Text; FT.DAL.Orm.SimpleOrmOperator.Create(temp); ArrayList lists = this.cbClassical.DataSource as ArrayList; lists.Add(temp); this.cbClassical.DataSource = lists; //this.cbClassical.Items.Add(temp.Text); } object obj2 = access.ExecuteScalar("select count(*) from table_dict where c_grouptype='车辆型号' and c_text='" + this.cbType.Text + "'"); if (Convert.ToInt32(obj2) == 0) { Dict temp = new Dict(); temp.Text = this.cbType.Text; temp.Value = this.cbType.Text; temp.Valid = "有效"; temp.GroupType = "车辆型号"; temp.Description = this.cbClassical.Text; FT.DAL.Orm.SimpleOrmOperator.Create(temp); ArrayList lists = this.cbType.DataSource as ArrayList; lists.Add(temp); this.cbType.DataSource = lists; //this.cbType.Items.Add(temp.Text); } MessageBoxHelper.Show("添加成功!"); //Constant.InitCbCnClassical(this.cbClassical); } else { MessageBoxHelper.Show("更新图片过程失败!"); } } else { MessageBoxHelper.Show("添加数据失败!"); } }
private void btnSave_Click(object sender, EventArgs e) { if (this.picPhoto.Image == null) { MessageBoxHelper.Show("����ѡ��һ����Ƭ��"); return; } string classical = this.cbClassical.Text.Trim(); string type = this.cbType.Text.Trim(); if (classical == string.Empty || classical == "��ѡ��") { MessageBoxHelper.Show("��ѡ�������������Ʒ�ƣ�"); return; } if (type == string.Empty || type == "��ѡ��") { MessageBoxHelper.Show("��ѡ��������복���ͺţ�"); return; } VehiclePhotoAccess access = new VehiclePhotoAccess(); VehiclePhoto photo = new VehiclePhoto(); photo.Cn_Classical = classical; photo.Cn_Type = type; photo.Picture = this.picPhoto.Image; photo.Suffix = this.suffix; bool result = access.Add(photo); if (result) { if (access.UpdateImage(access.GetLasted().Id, photo.Picture)) { object obj=access.ExecuteScalar("select count(*) from table_dict where c_grouptype='����Ʒ��' and c_text='" + this.cbClassical.Text + "'"); if (Convert.ToInt32(obj) == 0) { Dict temp = new Dict(); temp.Text = this.cbClassical.Text; temp.Value = this.cbClassical.Text; temp.Valid = "��Ч"; temp.GroupType = "����Ʒ��"; temp.Description = temp.Text; FT.DAL.Orm.SimpleOrmOperator.Create(temp); ArrayList lists = this.cbClassical.DataSource as ArrayList; lists.Add(temp); this.cbClassical.DataSource = lists; //this.cbClassical.Items.Add(temp.Text); } object obj2 = access.ExecuteScalar("select count(*) from table_dict where c_grouptype='�����ͺ�' and c_text='" + this.cbType.Text + "'"); if (Convert.ToInt32(obj2) == 0) { Dict temp = new Dict(); temp.Text = this.cbType.Text; temp.Value = this.cbType.Text; temp.Valid = "��Ч"; temp.GroupType = "�����ͺ�"; temp.Description = this.cbClassical.Text; FT.DAL.Orm.SimpleOrmOperator.Create(temp); ArrayList lists = this.cbType.DataSource as ArrayList; lists.Add(temp); this.cbType.DataSource = lists; //this.cbType.Items.Add(temp.Text); } MessageBoxHelper.Show("��ӳɹ���"); //Constant.InitCbCnClassical(this.cbClassical); } else { MessageBoxHelper.Show("����ͼƬ����ʧ�ܣ�"); } } else { MessageBoxHelper.Show("�������ʧ�ܣ�"); } }