/// <summary>
/// 列头画多选框
/// </summary>
/// <param name="e"></param>
/// <param name="chk"></param>
private static void DrawCheckBox(DevExpress.XtraGrid.Views.Grid.ColumnHeaderCustomDrawEventArgs e, bool chk)
{
try
{
DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit repositoryCheck = e.Column.ColumnEdit as DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit;
if (repositoryCheck != null)
{
System.Drawing.Graphics g = e.Graphics;
System.Drawing.Rectangle r = e.Bounds;
DevExpress.XtraEditors.ViewInfo.CheckEditViewInfo info;
DevExpress.XtraEditors.Drawing.CheckEditPainter painter;
DevExpress.XtraEditors.Drawing.ControlGraphicsInfoArgs args;
info = repositoryCheck.CreateViewInfo() as DevExpress.XtraEditors.ViewInfo.CheckEditViewInfo;
painter = repositoryCheck.CreatePainter() as DevExpress.XtraEditors.Drawing.CheckEditPainter;
info.EditValue = chk;
info.Bounds = r;
info.CalcViewInfo(g);
args = new DevExpress.XtraEditors.Drawing.ControlGraphicsInfoArgs(info, new DevExpress.Utils.Drawing.GraphicsCache(g), r);
painter.Draw(args);
args.Cache.Dispose();
}
}
catch
{
}
}
private void RESAI04K_Load(object sender, EventArgs e)
{
pOSXRTableAdapter.Fill(dS_RESAI04.POSXR, KeyValue[0]);
DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit edit = (DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit)GV_Main.Columns["Selected"].ColumnEdit;
edit.QueryCheckStateByValue += new DevExpress.XtraEditors.Controls.QueryCheckStateByValueEventHandler(QueryCheckStateByValue);
ButtonFieldListBody.Add(new ButtonFieldFormat(GCNum.GCN_Body, "", "XR006", this.XR006ButtonEdit_ButtonClick));
SetButtonEditField();
}
public DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit GetRepositoryItemCheckEdit()
{
DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit item = new DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit();
item.AutoHeight = false;
item.ValueChecked = "1";
item.ValueUnchecked = "0";
item.EditValueChanged += new EventHandler(ScenarioCheckBoxItem_EditValueChanged);
return(item);
}
/// <summary>
/// 在指定的网格中追加选择列。
/// </summary>
/// <param name="grdCtl">需要加选择列的网格</param>
/// <param name="columnCaption">列的标题</param>
/// <param name="columnFieldName">列的绑定字段名</param>
public DevExpress.XtraGrid.Columns.GridColumn AppendEditSelectedColumn(DevExpress.XtraGrid.GridControl grdCtl, string columnCaption, string columnFieldName)
{
DevExpress.XtraGrid.Views.Grid.GridView gridView = grdCtl.DefaultView as DevExpress.XtraGrid.Views.Grid.GridView;
DevExpress.XtraGrid.Columns.GridColumn col = new DevExpress.XtraGrid.Columns.GridColumn();
DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit boolItem = new DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit();
col.ColumnEdit = boolItem;
grdCtl.RepositoryItems.Add(boolItem);
gridView.Columns.Insert(0, col);
if (string.IsNullOrEmpty(columnCaption))
{
col.Caption = "选择";
}
else
{
col.Caption = columnCaption;
}
if (string.IsNullOrEmpty(columnFieldName))
{
col.FieldName = "Selected";
}
else
{
col.FieldName = columnFieldName;
}
col.OptionsColumn.AllowEdit = true;
col.OptionsFilter.AllowFilter = false;
col.OptionsColumn.AllowGroup = DevExpress.Utils.DefaultBoolean.False;
col.OptionsColumn.AllowMove = false;
col.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;
col.AppearanceHeader.Font = new Font(col.AppearanceHeader.Font, System.Drawing.FontStyle.Bold);
col.AppearanceHeader.ForeColor = Color.Blue;
col.VisibleIndex = 0;
col.Width = 60;
return(col);
}
static public void Column_SetCheck(ref GridView view, int column_index, object checkvalue, object uncheckvalue)
{
if (column_index >= 0 && column_index < view.Columns.Count)
{
#region Creating and Setting Repository Editor
DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit re = new DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit();
re.ValueChecked = checkvalue;
re.ValueUnchecked = uncheckvalue;
re.AllowGrayed = false;
#endregion
#region Setting Values to Column
if (view.Columns[column_index].ColumnEdit != null)
{
view.GridControl.RepositoryItems.Remove(view.Columns[column_index].ColumnEdit);
view.Columns[column_index].ColumnEdit.Dispose();
view.Columns[column_index].ColumnEdit = null;
}
view.Columns[column_index].ColumnEdit = re;
view.GridControl.RepositoryItems.Add(re);
#endregion
}
}
private void RESAI04G_Load(object sender, EventArgs e)
{
rESAI04_FavoriteTableAdapter.Fill(dS_RESAI04.RESAI04_Favorite, KeyValue[0], KeyValue[1]);
DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit edit = (DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit)GV_Main.Columns["Selected"].ColumnEdit;
edit.QueryCheckStateByValue += new DevExpress.XtraEditors.Controls.QueryCheckStateByValueEventHandler(QueryCheckStateByValue);
}
private void RefreshExch(bool search)
{
MySqlDataAdapter daRealty;
string[] tempArray;
string someval;
string sql = "SELECT realestate.Rid, agents.Ag_id, agency.Aid, realestate.Rphoto, region15.RR_town, rstreets.RS_street, ";
for (int i = 0; i < RexchCheckedFields.Count; i++)
{
sql += RexchCheckedFields[i].FieldName + ", ";
}
sql += " CONCAT_WS(' ',agents.Ag_FIO, ' т.', agents.Ag_phone) " +
" FROM realestate LEFT JOIN agents ON realestate.Ragent_code=agents.Ag_id " +
" LEFT JOIN agency ON agency.Aid= agents.Ag_agency" +
" LEFT JOIN region15 ON region15.RR_code= realestate.Rcity" +
" LEFT JOIN rstreets ON rstreets.RS_code= realestate.Rstreet" +
" WHERE (realestate.Restate_type <> '" + func.estate_typeValues[0] +
"' AND realestate.Roperation ='" + func.operationValues[2] + "')";
if (realtEstate_type != "") sql += " AND realestate.Restate_type='" + realtEstate_type + "'";
//новостройка //вторичка
if (ChbNewHouse.Checked == false || ChbOldHouse.Checked == false)
{ //новостройка
if (ChbNewHouse.Checked == true) sql += " AND realestate.Rnewbuilding=1";
//вторичка
if (ChbOldHouse.Checked == true) sql += " AND realestate.Rnewbuilding=0";
}
if (cbxExchStatus.SelectedIndex >= 0) sql += " AND realestate.Rstatus='" + cbxExchStatus.Text + "'";
if (search == true)
{
if (realtId == "")
{
///для вывода результатов поиска
if (cbxRoom.EditValue != null && cbxRoom.EditValue.ToString() != "") sql += " AND realestate.Rroom_quantity=" + cbxRoom.EditValue; //количество комнат
if (cbxFloor.EditValue != null && cbxFloor.EditValue.ToString() != "") // этаж
{
someval = cbxFloor.EditValue.ToString();
if (someval == func.floors[0]) sql += " AND realestate.Rfloor > 1";
if (someval == func.floors[1]) sql += " AND realestate.Rfloor <> realestate.Rnumber_of_storeys";
if (someval == func.floors[2]) sql += " AND (realestate.Rfloor <> realestate.Rnumber_of_storeys AND realestate.Rfloor > 1)";
}
if (cbxFloorsNumber.EditValue != null && cbxFloorsNumber.EditValue.ToString() != "") //этажность
{
someval = cbxFloorsNumber.EditValue.ToString();
if (someval.IndexOf('-') > 0)
{
tempArray = someval.Split('-');
sql += " AND (realestate.Rnumber_of_storeys >= " + tempArray[0] + " AND realestate.Rnumber_of_storeys <=" + tempArray[1] + ")";
}
else sql += " AND realestate.Rnumber_of_storeys " + someval;
}
//цена
if (cbxMinPrice.EditValue != null && cbxMinPrice.EditValue.ToString() != "") sql += " AND (realestate.Rprice >= " + cbxMinPrice.EditValue.ToString();
if (cbxMaxPrice.EditValue != null && cbxMaxPrice.EditValue.ToString() != "")
{
someval = cbxMaxPrice.EditValue.ToString();
if (someval != repositoryItemCbxMaxPrice.Items[repositoryItemCbxMaxPrice.Items.Count - 1].ToString())
sql += " AND realestate.Rprice <= " + someval;
else sql += " AND realestate.Rprice " + someval;
}
if (cbxMinPrice.EditValue != null && cbxMinPrice.EditValue.ToString() != "") sql += ") ";
//площадь
if (cbxMinArea.EditValue != null && cbxMinArea.EditValue.ToString() != "") sql += " AND (realestate.Rtotal_floor_space >= " + cbxMinArea.EditValue.ToString();
if (cbxMaxArea.EditValue != null && cbxMaxArea.EditValue.ToString() != "")
{
someval = cbxMaxArea.EditValue.ToString();
if (someval != repositoryItemCbxMaxArea.Items[repositoryItemCbxMaxArea.Items.Count - 1].ToString())
sql += " AND realestate.Rtotal_floor_space <= " + someval;
else sql += " AND realestate.Rtotal_floor_space " + someval;
}
if (cbxMinArea.EditValue != null && cbxMinArea.EditValue.ToString() != "") sql += ") ";
//материал стен
if (cbxWalls.EditValue != null && cbxWalls.EditValue.ToString() != "") sql += " AND realestate.Rwalling_type Like '%" + cbxWalls.EditValue.ToString() + "%'";
//город
if (cbxCity.EditValue != null && cbxCity.EditValue.ToString() != "")
{
someval = TownList.Find(n => n.rr_town == cbxCity.EditValue.ToString()).rr_code;
if (someval != null) sql += " AND realestate.Rcity ='" + someval + "'";
}
else
{
//район
if (cbxDistrict.EditValue != null && cbxDistrict.EditValue.ToString() != "")
{
someval = districts.Find(n => n.rr_town == cbxDistrict.EditValue.ToString()).rr_code;
if (someval != null) sql += " AND realestate.Rdistrict_region ='" + someval + "'";
}
}
}
else
{
sql += " AND realestate.Rid=" + realtId.Trim();
}
}
sql += " ORDER BY realestate.Rdate_add DESC";
try
{
daRealty = new MySqlDataAdapter(sql, func.connStr);
MySqlCommandBuilder cb = new MySqlCommandBuilder(daRealty);
DataSet dsRealty = new DataSet();
daRealty.Fill(dsRealty);
dsRealty.Tables[0].Columns[4].Caption = "Населенный пункт";
dsRealty.Tables[0].Columns[4].ReadOnly = true;
dsRealty.Tables[0].Columns[5].Caption = "Улица";
dsRealty.Tables[0].Columns[5].ReadOnly = true;
for (int i = 0; i < RexchCheckedFields.Count; i++)
{
dsRealty.Tables[0].Columns[i + 6].ReadOnly = true;
dsRealty.Tables[0].Columns[i + 6].Caption = RexchCheckedFields[i].caption;
}
int count = dsRealty.Tables[0].Columns.Count;
dsRealty.Tables[0].Columns[count - 1].Caption = "Агент ,тел";
dsRealty.Tables[0].Columns[count - 1].ReadOnly = true;
dsRealty.Tables[0].Columns.Add("Выбрать", typeof(bool));
//MySqlConnection conn = new MySqlConnection(func.connStr);
//if (conn.State == ConnectionState.Open) conn.Close();
try
{
gridViewExch.Columns.Clear();
RealtyExchGridC.DataSource = null;
RealtyExchGridC.DataSource = dsRealty.Tables[0];
gridViewExch.Columns[0].Visible = false;
gridViewExch.Columns[1].Visible = false;
gridViewExch.Columns[2].Visible = false;
gridViewExch.Columns[3].Visible = false;
DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit repositoryItemCheckEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit();
gridViewExch.Columns[count].ColumnEdit = repositoryItemCheckEdit1;
gridViewExch.Columns[count].UnboundType = DevExpress.Data.UnboundColumnType.Boolean;
gridViewExch.Columns[count].OptionsColumn.AllowEdit = true;
repositoryItemCheckEdit1.NullText = "";
repositoryItemCheckEdit1.ValueChecked = 0;
repositoryItemCheckEdit1.ValueUnchecked = 1;
repositoryItemCheckEdit1.ValueGrayed = "";
repositoryItemCheckEdit1.NullStyle = DevExpress.XtraEditors.Controls.StyleIndeterminate.Unchecked;
gridViewExch.Columns[count].VisibleIndex = 0;
}
finally
{
RealtyExchGridC.EndUpdate();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void RefreshTerra(bool search)
{
MySqlDataAdapter daRealty;
string someval;
string sql = "SELECT terra.TId, agents.Ag_id, agency.Aid, terra.Tphoto, region15.RR_town, rstreets.RS_street, ";
for (int i = 0; i < TerraCheckedFields.Count; i++)
{
sql += TerraCheckedFields[i].FieldName + ", ";
}
sql += " CONCAT_WS(' ',agents.Ag_FIO, 'т.', agents.Ag_phone) " +
" FROM terra LEFT JOIN agents ON terra.Tagent_code=agents.Ag_id " +
" LEFT JOIN agency ON agency.Aid= agents.Ag_agency" +
" LEFT JOIN region15 ON region15.RR_code= terra.Tcity" +
" LEFT JOIN rstreets ON rstreets.RS_code= terra.Tstreet";
if (cbxTerraStatus.SelectedIndex >= 0) sql += " WHERE terra.Tstatus='" + cbxTerraStatus.Text + "'";
if (search == true)
{
if (terraId == "")
{
//цена
if (cbxTerraMinPrice.EditValue != null && cbxTerraMinPrice.EditValue.ToString() != "") sql += " AND (terra.Tprice >= " + cbxTerraMinPrice.EditValue.ToString();
if (cbxTerraMaxPrice.EditValue != null && cbxTerraMaxPrice.EditValue.ToString() != "")
{
someval = cbxTerraMaxPrice.EditValue.ToString();
if (someval != repositoryItemCbxTerraMaxPrice.Items[repositoryItemCbxTerraMaxPrice.Items.Count - 1].ToString())
sql += " AND terra.Tprice <= " + someval;
else sql += " AND terra.Tprice " + someval;
}
if (cbxTerraMinPrice.EditValue != null && cbxTerraMinPrice.EditValue.ToString() != "") sql += ") ";
//площадь
if (cbxTerraMinArea.EditValue != null && cbxTerraMinArea.EditValue.ToString() != "") sql += " AND (terra.Tground_area >= " + cbxTerraMinArea.EditValue.ToString();
if (cbxTerraMaxArea.EditValue != null && cbxTerraMaxArea.EditValue.ToString() != "")
{
someval = cbxTerraMaxArea.EditValue.ToString();
if (someval != repositoryItemCbxTerraMaxArea.Items[repositoryItemCbxTerraMaxArea.Items.Count - 1].ToString())
sql += " AND terra.Tground_area <= " + someval;
else sql += " AND terra.Tground_area " + someval;
}
if (cbxTerraMinArea.EditValue != null && cbxTerraMinArea.EditValue.ToString() != "") sql += ") ";
//город
if (cbxTerraCity.EditValue != null && cbxTerraCity.EditValue.ToString() != "")
{
someval = TownList.Find(n => n.rr_town == cbxTerraCity.EditValue.ToString()).rr_code;
if (someval != null) sql += " AND terra.Tcity ='" + someval + "'";
}
else
{
//район
if (cbxTerraDistrict.EditValue != null && cbxTerraDistrict.EditValue.ToString() != "")
{
someval = districts.Find(n => n.rr_town == cbxTerraDistrict.EditValue.ToString()).rr_code;
if (someval != null) sql += " AND terra.Tdistrict_region ='" + someval + "'";
}
}
}
else
{
sql += " AND terra.TId=" + terraId.Trim();
}
}
sql += " ORDER BY terra.Tdate_add DESC";
try
{
daRealty = new MySqlDataAdapter(sql, func.connStr);
MySqlCommandBuilder cb = new MySqlCommandBuilder(daRealty);
DataSet dsRealty = new DataSet();
daRealty.Fill(dsRealty);
dsRealty.Tables[0].Columns[4].Caption = "Населенный пункт";
dsRealty.Tables[0].Columns[4].ReadOnly = true;
dsRealty.Tables[0].Columns[5].Caption = "Улица";
dsRealty.Tables[0].Columns[5].ReadOnly = true;
for (int i = 0; i < TerraCheckedFields.Count; i++)
{
dsRealty.Tables[0].Columns[i + 6].ReadOnly = true;
dsRealty.Tables[0].Columns[i+6].Caption =TerraCheckedFields[i].caption;
}
int count = dsRealty.Tables[0].Columns.Count;
dsRealty.Tables[0].Columns[count-1].Caption = "Агент ,тел";
dsRealty.Tables[0].Columns[count-1].ReadOnly = true;
dsRealty.Tables[0].Columns.Add("Выбрать", typeof(bool));
//MySqlConnection conn = new MySqlConnection(func.connStr);
//if (conn.State == ConnectionState.Open) conn.Close();
try
{
gridViewTerra.Columns.Clear();
terraGridC.DataSource = null;
terraGridC.DataSource = dsRealty.Tables[0];
gridViewTerra.Columns[0].Visible = false;
gridViewTerra.Columns[1].Visible = false;
gridViewTerra.Columns[2].Visible = false;
gridViewTerra.Columns[3].Visible = false;
DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit repositoryItemCheckEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit();
gridViewTerra.Columns[count].ColumnEdit = repositoryItemCheckEdit1;
gridViewTerra.Columns[count].UnboundType = DevExpress.Data.UnboundColumnType.Boolean;
gridViewTerra.Columns[count].OptionsColumn.AllowEdit = true;
repositoryItemCheckEdit1.NullText = "";
repositoryItemCheckEdit1.ValueChecked = 0;
repositoryItemCheckEdit1.ValueUnchecked = 1;
repositoryItemCheckEdit1.ValueGrayed = "";
repositoryItemCheckEdit1.NullStyle = DevExpress.XtraEditors.Controls.StyleIndeterminate.Unchecked;
gridViewTerra.Columns[count].VisibleIndex = 0;
}
finally
{
terraGridC.EndUpdate();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit repositoryItemCheckEdit2;
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(FormNewMemberCreditPackageUsage));
DevExpress.XtraEditors.Repository.RepositoryItemTextEdit repositoryItemTextEdit1;
this.lkpEdtPackageCode = new DevExpress.XtraEditors.LookUpEdit();
this.label1 = new System.Windows.Forms.Label();
this.simpleButtonCancel = new DevExpress.XtraEditors.SimpleButton();
this.simpleButtonOK = new DevExpress.XtraEditors.SimpleButton();
this.label3 = new System.Windows.Forms.Label();
this.gridControl1 = new DevExpress.XtraGrid.GridControl();
this.gridView1 = new DevExpress.XtraGrid.Views.Grid.GridView();
this.gridColumn4 = new DevExpress.XtraGrid.Columns.GridColumn();
this.gridColumn1 = new DevExpress.XtraGrid.Columns.GridColumn();
this.Quantity = new DevExpress.XtraGrid.Columns.GridColumn();
this.repositoryItemSpinEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemSpinEdit();
this.gridColumn2 = new DevExpress.XtraGrid.Columns.GridColumn();
this.gridColumn3 = new DevExpress.XtraGrid.Columns.GridColumn();
this.gridView2 = new DevExpress.XtraGrid.Views.Grid.GridView();
this.checkedComboBoxEdit1 = new DevExpress.XtraEditors.CheckedComboBoxEdit();
repositoryItemCheckEdit2 = new DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit();
repositoryItemTextEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit();
((System.ComponentModel.ISupportInitialize)(repositoryItemCheckEdit2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(repositoryItemTextEdit1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.lkpEdtPackageCode.Properties)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.gridControl1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.gridView1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemSpinEdit1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.gridView2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.checkedComboBoxEdit1.Properties)).BeginInit();
this.SuspendLayout();
//
// repositoryItemCheckEdit2
//
resources.ApplyResources(repositoryItemCheckEdit2, "repositoryItemCheckEdit2");
repositoryItemCheckEdit2.Name = "repositoryItemCheckEdit2";
//
// repositoryItemTextEdit1
//
resources.ApplyResources(repositoryItemTextEdit1, "repositoryItemTextEdit1");
repositoryItemTextEdit1.Name = "repositoryItemTextEdit1";
//
// lkpEdtPackageCode
//
resources.ApplyResources(this.lkpEdtPackageCode, "lkpEdtPackageCode");
this.lkpEdtPackageCode.Name = "lkpEdtPackageCode";
this.lkpEdtPackageCode.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(((DevExpress.XtraEditors.Controls.ButtonPredefines)(resources.GetObject("lkpEdtPackageCode.Properties.Buttons"))))
});
this.lkpEdtPackageCode.EditValueChanged += new System.EventHandler(this.lkpEdtPackageCode_EditValueChanged);
//
// label1
//
resources.ApplyResources(this.label1, "label1");
this.label1.Name = "label1";
//
// simpleButtonCancel
//
this.simpleButtonCancel.DialogResult = System.Windows.Forms.DialogResult.Cancel;
resources.ApplyResources(this.simpleButtonCancel, "simpleButtonCancel");
this.simpleButtonCancel.Name = "simpleButtonCancel";
//
// simpleButtonOK
//
this.simpleButtonOK.DialogResult = System.Windows.Forms.DialogResult.OK;
resources.ApplyResources(this.simpleButtonOK, "simpleButtonOK");
this.simpleButtonOK.Name = "simpleButtonOK";
this.simpleButtonOK.Click += new System.EventHandler(this.simpleButtonOK_Click);
//
// label3
//
resources.ApplyResources(this.label3, "label3");
this.label3.Name = "label3";
//
// gridControl1
//
resources.ApplyResources(this.gridControl1, "gridControl1");
this.gridControl1.MainView = this.gridView1;
this.gridControl1.Name = "gridControl1";
this.gridControl1.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] {
repositoryItemCheckEdit2,
repositoryItemTextEdit1,
this.repositoryItemSpinEdit1
});
this.gridControl1.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] {
this.gridView1,
this.gridView2
});
//
// gridView1
//
this.gridView1.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] {
this.gridColumn4,
this.gridColumn1,
this.Quantity,
this.gridColumn2,
this.gridColumn3
});
this.gridView1.GridControl = this.gridControl1;
this.gridView1.Name = "gridView1";
this.gridView1.FocusedRowChanged += new DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventHandler(this.gridView1_FocusedRowChanged);
//
// gridColumn4
//
resources.ApplyResources(this.gridColumn4, "gridColumn4");
this.gridColumn4.ColumnEdit = repositoryItemCheckEdit2;
this.gridColumn4.FieldName = "Tick";
this.gridColumn4.Name = "gridColumn4";
//
// gridColumn1
//
resources.ApplyResources(this.gridColumn1, "gridColumn1");
this.gridColumn1.FieldName = "strPackageCode";
this.gridColumn1.Name = "gridColumn1";
this.gridColumn1.OptionsColumn.AllowEdit = false;
//
// Quantity
//
resources.ApplyResources(this.Quantity, "Quantity");
this.Quantity.ColumnEdit = this.repositoryItemSpinEdit1;
this.Quantity.FieldName = "nQuantity";
this.Quantity.Name = "Quantity";
//
// repositoryItemSpinEdit1
//
this.repositoryItemSpinEdit1.AllowNullInput = DevExpress.Utils.DefaultBoolean.False;
resources.ApplyResources(this.repositoryItemSpinEdit1, "repositoryItemSpinEdit1");
this.repositoryItemSpinEdit1.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton()
});
this.repositoryItemSpinEdit1.IsFloatValue = false;
this.repositoryItemSpinEdit1.Mask.EditMask = resources.GetString("repositoryItemSpinEdit1.Mask.EditMask");
this.repositoryItemSpinEdit1.MaxValue = new decimal(new int[] {
100,
0,
0,
0
});
this.repositoryItemSpinEdit1.MinValue = new decimal(new int[] {
1,
0,
0,
0
});
this.repositoryItemSpinEdit1.Name = "repositoryItemSpinEdit1";
//
// gridColumn2
//
resources.ApplyResources(this.gridColumn2, "gridColumn2");
this.gridColumn2.FieldName = "strDescription";
this.gridColumn2.Name = "gridColumn2";
this.gridColumn2.OptionsColumn.AllowEdit = false;
//
// gridColumn3
//
resources.ApplyResources(this.gridColumn3, "gridColumn3");
this.gridColumn3.FieldName = "dtValidEnd";
this.gridColumn3.Name = "gridColumn3";
this.gridColumn3.OptionsColumn.AllowEdit = false;
//
// gridView2
//
this.gridView2.GridControl = this.gridControl1;
this.gridView2.Name = "gridView2";
//
// checkedComboBoxEdit1
//
resources.ApplyResources(this.checkedComboBoxEdit1, "checkedComboBoxEdit1");
this.checkedComboBoxEdit1.Name = "checkedComboBoxEdit1";
this.checkedComboBoxEdit1.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(((DevExpress.XtraEditors.Controls.ButtonPredefines)(resources.GetObject("checkedComboBoxEdit1.Properties.Buttons"))))
});
//
// FormNewMemberCreditPackageUsage
//
this.AcceptButton = this.simpleButtonOK;
resources.ApplyResources(this, "$this");
this.CancelButton = this.simpleButtonCancel;
this.Controls.Add(this.checkedComboBoxEdit1);
this.Controls.Add(this.gridControl1);
this.Controls.Add(this.label3);
this.Controls.Add(this.simpleButtonCancel);
this.Controls.Add(this.simpleButtonOK);
this.Controls.Add(this.label1);
this.Controls.Add(this.lkpEdtPackageCode);
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedDialog;
this.MaximizeBox = false;
this.MinimizeBox = false;
this.Name = "FormNewMemberCreditPackageUsage";
this.ShowInTaskbar = false;
((System.ComponentModel.ISupportInitialize)(repositoryItemCheckEdit2)).EndInit();
((System.ComponentModel.ISupportInitialize)(repositoryItemTextEdit1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.lkpEdtPackageCode.Properties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.gridControl1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.gridView1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemSpinEdit1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.gridView2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.checkedComboBoxEdit1.Properties)).EndInit();
this.ResumeLayout(false);
}
/// <summary>
/// Sets the column.
/// </summary>
/// <param name="strheader">The strheader.</param>
/// <param name="strFieldsName">Name of the STR fields.</param>
/// <param name="ct">The ct.</param>
/// <param name="nWidth">Width of the n.</param>
/// <param name="mAlign">The m align.</param>
/// <param name="bVisible">if set to <c>true</c> [b visible].</param>
/// <param name="IsAllowEdit">if set to <c>true</c> [is allow edit].</param>
/// <param name="IsAllowSort">The is allow sort.</param>
/// <returns></returns>
private DevExpress.XtraGrid.Columns.GridColumn SetColumn(string strheader,
string strFieldsName,
_ColumnType ct,
int nWidth,
_ColumnAlign mAlign,
bool bVisible,
bool IsAllowEdit,
DefaultBoolean IsAllowSort,
AutoFilterCondition autoFilterCondition,
bool IsAllowMove)
{
DevExpress.XtraGrid.Columns.GridColumn gc = new GridColumn();
gc.Caption = strheader;
gc.FieldName = strFieldsName;
gc.Name = strFieldsName;
gc.Width = nWidth;
//// 헤더 텍스트 옵션을 사용한다.
gc.AppearanceHeader.Options.UseTextOptions = true;
gc.OptionsColumn.AllowMerge = DefaultBoolean.False;
// 셀 텍스트 옵션을 사용한다.
gc.AppearanceCell.Options.UseTextOptions = true;
gc.AppearanceCell.TextOptions.VAlignment = DevExpress.Utils.VertAlignment.Default;
gc.AppearanceCell.TextOptions.HAlignment = (DevExpress.Utils.HorzAlignment)mAlign;
gc.AppearanceHeader.TextOptions.VAlignment = DevExpress.Utils.VertAlignment.Default;
gc.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
gc.Visible = bVisible;
gc.OptionsColumn.AllowEdit = IsAllowEdit;
gc.OptionsColumn.AllowMove = IsAllowMove;
gc.OptionsColumn.ReadOnly = !IsAllowEdit;
gc.OptionsColumn.AllowSort = IsAllowSort;
gc.VisibleIndex = bVisible ? iVisibleIndex++ : -1;
gc.OptionsFilter.AllowAutoFilter = true;
//gc.OptionsFilter.AllowFilter = false;
gc.OptionsFilter.AutoFilterCondition = autoFilterCondition;
gc.OptionsFilter.ImmediateUpdateAutoFilter = true;
gc.AppearanceHeader.Font = new System.Drawing.Font("굴림체", 9F);
gc.AppearanceHeader.Options.UseFont = true;
if (ct > 0)
{
switch (ct)
{
case _ColumnType.CheckBox:
if (this._GridControl != null)
{
mCheckBox = new RepositoryItemCheckEdit();
this._GridControl.RepositoryItems.Add(SetCheckBoxStyle(mCheckBox, CheckBoxStyle.StyleYN));
gc.ColumnEdit = mCheckBox;
//gc.OptionsColumn.AllowEdit= true;
//gc.OptionsColumn.ReadOnly = false;
}
break;
case _ColumnType.CheckBoxBit:
if (this._GridControl != null)
{
mCheckBox = new RepositoryItemCheckEdit();
this._GridControl.RepositoryItems.Add(SetCheckBoxStyle(mCheckBox, CheckBoxStyle.StyleBit));
gc.ColumnEdit = mCheckBox;
//gc.OptionsColumn.AllowEdit= true;
//gc.OptionsColumn.ReadOnly = false;
}
break;
case _ColumnType.Picture:
if (this._GridControl != null)
{
mPicture = new RepositoryItemPictureEdit();
mPicture.SizeMode = DevExpress.XtraEditors.Controls.PictureSizeMode.Stretch;
this._GridControl.RepositoryItems.Add(mPicture);
gc.ColumnEdit = mPicture;
//gc.OptionsColumn.AllowEdit= true;
//gc.OptionsColumn.ReadOnly = false;
}
break;
case _ColumnType.Numbers:
gc.DisplayFormat.FormatType = FormatType.Numeric;
gc.DisplayFormat.FormatString = "n0";
break;
case _ColumnType.Dates:
gc.DisplayFormat.FormatType = FormatType.DateTime;
gc.DisplayFormat.FormatString = "yyyy-MM-dd";
break;
case _ColumnType.DateTime:
gc.DisplayFormat.FormatType = FormatType.DateTime;
gc.DisplayFormat.FormatString = "yyyy-MM-dd HH:mm:ss";
break;
case _ColumnType.ComboBox:
mComboBox = new RepositoryItemComboBox();
mComboBox.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor;
this._GridControl.RepositoryItems.Add(mComboBox);
gc.ColumnEdit = mComboBox;
//gc.OptionsColumn.ReadOnly = false;
//gc.OptionsColumn.AllowEdit= true;
break;
case _ColumnType.doubles1:
gc.DisplayFormat.FormatType = FormatType.Numeric;
gc.DisplayFormat.FormatString = "n1";
break;
case _ColumnType.doubles2:
gc.DisplayFormat.FormatType = FormatType.Numeric;
gc.DisplayFormat.FormatString = "n2";
break;
case _ColumnType.TextEdit:
mTextEdit = new RepositoryItemTextEdit();
this._GridControl.RepositoryItems.Add(mTextEdit);
gc.ColumnEdit = mTextEdit;
//gc.OptionsColumn.ReadOnly = false;
//gc.OptionsColumn.AllowEdit= true;
break;
case _ColumnType.Amount:
gc.DisplayFormat.FormatType = FormatType.Numeric;
gc.DisplayFormat.FormatString = "###,###";
break;
case _ColumnType.LookUp:
mLookUp = new RepositoryItemLookUpEdit();
mLookUp.Name = "LOOKUP_" + gc.FieldName;
//mLookUp.Properties.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.AutoComplete;
//mLookUp.Properties.AutoSearchColumnIndex = 0;
mLookUp.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.AutoComplete;
mLookUp.AutoSearchColumnIndex = 0;
this._GridControl.RepositoryItems.Add(mLookUp);
gc.ColumnEdit = mLookUp;
//gc.OptionsColumn.ReadOnly = false;
//gc.OptionsColumn.AllowEdit= true;
break;
case _ColumnType.Radio:
if (this._GridControl != null)
{
mRadio = new RepositoryItemRadioGroup();
this._GridControl.RepositoryItems.Add(mRadio);
gc.ColumnEdit = mRadio;
//gc.OptionsColumn.ReadOnly = false;
//gc.OptionsColumn.AllowEdit= true;
}
break;
case _ColumnType.RichEdit:
if (this._GridControl != null)
{
mRichEdit = new RepositoryItemRichTextEdit();
this._GridControl.RepositoryItems.Add(mRichEdit);
gc.ColumnEdit = mRichEdit;
//gc.OptionsColumn.ReadOnly = false;
//gc.OptionsColumn.AllowEdit= true;
}
break;
case _ColumnType.Button:
if (this._GridControl != null)
{
mBtn = new RepositoryItemButtonEdit();
mBtn.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.HideTextEditor;
mBtn.Buttons[0].Kind = DevExpress.XtraEditors.Controls.ButtonPredefines.Glyph;
//mBtn.Properties.Buttons[0].Caption = "확인";
mBtn.Properties.Buttons[0].Appearance.ForeColor = Color.Black;
this._GridControl.RepositoryItems.Add(mBtn);
gc.ColumnEdit = mBtn;
//gc.OptionsColumn.ReadOnly = false;
//gc.OptionsColumn.AllowEdit= true;
}
break;
case _ColumnType.DataTimepicker:
if (this._GridControl != null)
{
mDateEdit = new RepositoryItemDateEdit();
mDateEdit.EditFormat.FormatType = FormatType.DateTime;
mDateEdit.DisplayFormat.FormatString = "yyyy-MM-dd";
mDateEdit.Appearance.ForeColor = Color.Black;
this._GridControl.RepositoryItems.Add(mDateEdit);
gc.ColumnEdit = mDateEdit;
//gc.OptionsColumn.ReadOnly = false;
//gc.OptionsColumn.AllowEdit= true;
}
break;
case _ColumnType.Progressbar:
if (this._GridControl != null)
{
mProgressBar = new RepositoryItemProgressBar();
mProgressBar.ShowTitle = true;
mProgressBar.ProgressViewStyle = DevExpress.XtraEditors.Controls.ProgressViewStyle.Solid;
mProgressBar.PercentView = true;
mProgressBar.ProgressKind = DevExpress.XtraEditors.Controls.ProgressKind.Horizontal;
mProgressBar.NullText = "0";
mProgressBar.Step = 1;
mProgressBar.EditFormat.FormatType = FormatType.Numeric;
mProgressBar.EditFormat.FormatString = "n2";
this._GridControl.RepositoryItems.Add(mProgressBar);
gc.ColumnEdit = mProgressBar;
//gc.OptionsColumn.ReadOnly = false;
//gc.OptionsColumn.AllowEdit= true;
}
break;
default: break;
}
}
return(gc);
}
/// <summary>
/// 根据字段的类型名称获取一个XtrGrid 的编辑控件。
/// </summary>
/// <param name="fullTypeName"></param>
/// <param name="isCard"> 如果是卡片编辑的话图片的显示使用PictureEdit的方式。</param>
/// <returns></returns>
public DevExpress.XtraEditors.Repository.RepositoryItem createEditItemByCol(string fullTypeName, bool isCard, MB.WinBase.Common.ColumnPropertyInfo propertyInfo)
{
DevExpress.XtraEditors.Repository.RepositoryItem item = null;
switch (fullTypeName)
{
case "System.Int16":
DevExpress.XtraEditors.Repository.RepositoryItemSpinEdit int16Item = new DevExpress.XtraEditors.Repository.RepositoryItemSpinEdit();
int16Item.IsFloatValue = false;
int16Item.EditMask = "N00";
int16Item.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
item = int16Item;
if (propertyInfo != null)
{
if (propertyInfo.MinValue > Int32.MinValue)
{
int16Item.MinValue = System.Convert.ToInt16(propertyInfo.MinValue);
}
if (propertyInfo.MaxValue < Int32.MaxValue)
{
int16Item.MaxValue = System.Convert.ToInt16(propertyInfo.MaxValue);
}
}
break;
case "System.Int32":
item = CreateEditItemInt32(propertyInfo);
break;
case "System.Decimal":
DevExpress.XtraEditors.Repository.RepositoryItemCalcEdit deciItem = new XtraRepositoryItemCalcEditEx();
deciItem.MaxLength = 12; //初不设置的一个数，需要修改；
item = deciItem;
break;
case "System.DateTime":
DevExpress.XtraEditors.Repository.RepositoryItemDateEdit dateItem = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit();
dateItem.NullDate = DateTime.MinValue;
dateItem.NullText = string.Empty;
dateItem.AutoHeight = false;
item = dateItem;
break;
case "System.Boolean": //目前Boolean 先用CheckedBox 来表达，如果需要再修改为Group Radio
DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit boolItem = new DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit();
item = boolItem;
break;
case "System.Byte[]":
if (!isCard)
{
DevExpress.XtraEditors.Repository.RepositoryItemImageEdit imageItem = new DevExpress.XtraEditors.Repository.RepositoryItemImageEdit();
//imageItem.NullText = "";
item = imageItem;
}
else
{
DevExpress.XtraEditors.Repository.RepositoryItemPictureEdit picItem = new DevExpress.XtraEditors.Repository.RepositoryItemPictureEdit();
item = picItem;
}
break;
default:
DevExpress.XtraEditors.Repository.RepositoryItemTextEdit txtItem = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit();
item = txtItem;
break;
}
return(item);//new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit();
}
private static void InitializeColumnA(DevExpress.XtraGrid.Views.BandedGrid.AdvBandedGridView view,
string ColumnName,
_ColumnType type,
_ColumnAlign mAlign,
bool IsVisible,
bool IsAllowEdit,
bool IsAllowMove)
{
try
{
view.Columns[ColumnName].AppearanceHeader.Options.UseTextOptions = true;
// 셀 텍스트 옵션을 사용한다.
view.Columns[ColumnName].AppearanceCell.Options.UseTextOptions = true;
view.Columns[ColumnName].AppearanceCell.TextOptions.VAlignment = DevExpress.Utils.VertAlignment.Default;
view.Columns[ColumnName].AppearanceCell.TextOptions.HAlignment = (DevExpress.Utils.HorzAlignment)mAlign;
view.Columns[ColumnName].AppearanceHeader.TextOptions.VAlignment = DevExpress.Utils.VertAlignment.Default;
view.Columns[ColumnName].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
view.Columns[ColumnName].Visible = IsVisible;
if (IsVisible)
{
view.Columns[ColumnName].VisibleIndex = view.Columns.Count;
}
else
{
view.Columns[ColumnName].VisibleIndex = -1;
}
view.Columns[ColumnName].OptionsColumn.AllowMove = IsAllowMove;
view.Columns[ColumnName].OptionsColumn.AllowSize = true;
view.Columns[ColumnName].OptionsColumn.AllowEdit = IsAllowEdit;
view.Columns[ColumnName].OptionsColumn.ReadOnly = !IsAllowEdit;
switch (type)
{
case _ColumnType.CheckBox:
mCheckBox = new DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit();
mCheckBox.CheckStyle = DevExpress.XtraEditors.Controls.CheckStyles.Style4;
mCheckBox.NullStyle = DevExpress.XtraEditors.Controls.StyleIndeterminate.Unchecked;
mCheckBox.ValueChecked = "Y";
mCheckBox.ValueUnchecked = "N";
view.GridControl.RepositoryItems.Add(mCheckBox);
view.Columns[ColumnName].ColumnEdit = mCheckBox;
break;
case _ColumnType.CheckBoxBit:
mCheckBox = new DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit();
mCheckBox.CheckStyle = DevExpress.XtraEditors.Controls.CheckStyles.Style4;
mCheckBox.NullStyle = DevExpress.XtraEditors.Controls.StyleIndeterminate.Unchecked;
mCheckBox.ValueChecked = "1";
mCheckBox.ValueUnchecked = "0";
view.GridControl.RepositoryItems.Add(mCheckBox);
view.Columns[ColumnName].ColumnEdit = mCheckBox;
break;
case _ColumnType.Picture:
mPicture = new RepositoryItemPictureEdit();
mPicture.SizeMode = DevExpress.XtraEditors.Controls.PictureSizeMode.Stretch;
view.GridControl.RepositoryItems.Add(mPicture);
view.Columns[ColumnName].ColumnEdit = mPicture;
break;
case _ColumnType.Numbers:
view.Columns[ColumnName].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
view.Columns[ColumnName].DisplayFormat.FormatString = "n0";
break;
case _ColumnType.Dates:
view.Columns[ColumnName].DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
view.Columns[ColumnName].DisplayFormat.FormatString = "yyyy-MM-dd";
break;
case _ColumnType.DateTime:
view.Columns[ColumnName].DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
view.Columns[ColumnName].DisplayFormat.FormatString = "yyyy-MM-dd HH:mm:ss";
break;
case _ColumnType.ComboBox:
mComboBox = new RepositoryItemComboBox();
mComboBox.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor;
view.GridControl.RepositoryItems.Add(mComboBox);
view.Columns[ColumnName].ColumnEdit = mComboBox;
break;
case _ColumnType.doubles1:
view.Columns[ColumnName].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
view.Columns[ColumnName].DisplayFormat.FormatString = "n1";
break;
case _ColumnType.doubles2:
view.Columns[ColumnName].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
view.Columns[ColumnName].DisplayFormat.FormatString = "n2";
break;
case _ColumnType.TextEdit:
mTextEdit = new RepositoryItemTextEdit();
view.GridControl.RepositoryItems.Add(mTextEdit);
view.Columns[ColumnName].ColumnEdit = mTextEdit;
break;
case _ColumnType.Amount:
view.Columns[ColumnName].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
view.Columns[ColumnName].DisplayFormat.FormatString = "###,###";
break;
case _ColumnType.Radio:
mRadio = new RepositoryItemRadioGroup();
view.GridControl.RepositoryItems.Add(mRadio);
view.Columns[ColumnName].ColumnEdit = mRadio;
break;
case _ColumnType.LookUp:
mLookUp = new DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit();
mLookUp.Name = "LOOKUP_" + view.Columns[ColumnName].Name;
//mLookUp.Properties.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.AutoComplete;
//mLookUp.Properties.AutoSearchColumnIndex = 0;
view.GridControl.RepositoryItems.Add(mLookUp);
view.Columns[ColumnName].ColumnEdit = mLookUp;
break;
case _ColumnType.RichEdit:
mRichEdit = new RepositoryItemRichTextEdit();
view.GridControl.RepositoryItems.Add(mRichEdit);
view.Columns[ColumnName].ColumnEdit = mRichEdit;
break;
case _ColumnType.Button:
mBtn = new RepositoryItemButtonEdit();
mBtn.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.HideTextEditor;
mBtn.Buttons[0].Kind = DevExpress.XtraEditors.Controls.ButtonPredefines.Glyph;
//mBtn.Properties.Buttons[0].Caption = "확인";
mBtn.Properties.Buttons[0].Appearance.ForeColor = System.Drawing.Color.Black;
view.GridControl.RepositoryItems.Add(mBtn);
view.Columns[ColumnName].ColumnEdit = mBtn;
break;
case _ColumnType.DataTimepicker:
if (view.GridControl != null)
{
mDateEdit = new RepositoryItemDateEdit();
mDateEdit.EditFormat.FormatType = FormatType.DateTime;
mDateEdit.DisplayFormat.FormatString = "yyyy-MM-dd";
mDateEdit.Appearance.ForeColor = Color.Black;
view.GridControl.RepositoryItems.Add(mDateEdit);
view.Columns[ColumnName].ColumnEdit = mDateEdit;
//gc.OptionsColumn.ReadOnly = false;
//gc.OptionsColumn.AllowEdit= true;
}
break;
default: break;
}
}
catch (Exception ex)
{
throw ex;
}
}
public bool QueryMIMuity(string[] xMIInfo)
{
GV_Main.Columns.Clear();
String JsonStr = "";
try
{ // Create an instance of StreamReader to read from a file.
// The using statement also closes the StreamReader.
using (SqlConnection conn = new SqlConnection(fc.makeConnectString(fc.FDBInfo)))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("SELECT MI003 FROM ADMMI WHERE MI001=@MI001 AND MI002=@MI002", conn))
{
cmd.Parameters.AddWithValue("@MI001", xMIInfo[0]);
cmd.Parameters.AddWithValue("@MI002", xMIInfo[1]);
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
JsonStr = dr["MI003"].ToString();
}
}
}
}
/*using (StreamReader sr = new StreamReader(xPath.Trim())) //小寫TXT
* {
* JsonStr = sr.ReadToEnd();
* }*/
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
fc.ErrorLog(ex.Message);
return(false);
}
if (JsonStr == "")
{
return(false);
}
F2 = JsonConvert.DeserializeObject <F2Object.Rootobject>(JsonStr.Trim());
ResutnValus = new String[F2.RETURN.Length];
if (F2.PARAM[0] != "0")
{
for (int i = 0; i < F2.PARAM.Count(); i++)
{
F2.MAINSELECT = F2.MAINSELECT.Replace(F2.PARAM[i], "'" + MIParam[i] + "'");
}
}
using (SqlConnection conn = new SqlConnection(fc.makeConnectString(fc.FDBInfo)))
{
try
{
conn.Open();
string OrderStr = "";
foreach (string s in F2.ORDER)
{
OrderStr += s + ",";
}
OrderStr = OrderStr.Substring(0, OrderStr.Length - 1);
using (SqlCommand cmd = new SqlCommand(F2.MAINSELECT + " ORDER BY " + OrderStr, conn))
{
//myCommand = new SqlCommand(F2.MAINSELECT + " ORDER BY " + OrderStr, conn);
using (SqlDataAdapter sqldataadpt = new SqlDataAdapter(cmd))
{
//SqlDataAdapter sqldataadpt = new SqlDataAdapter(myCommand);
DataTable dt1 = new DataTable();
sqldataadpt.Fill(dt1);
if (dt1.Rows.Count == 0)
{
return(false);
}
else
{
dt1.Columns.Add("Select", typeof(string));
GC_Main.DataSource = dt1;
GV_Main.PopulateColumns();
GV_Main.Columns["Select"].VisibleIndex = 0;
GV_Main.Columns["Select"].Caption = "選擇";
DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit selectnew = new DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit();
GV_Main.Columns["Select"].ColumnEdit = selectnew;
selectnew.NullText = "";
selectnew.ValueChecked = "Y";
selectnew.ValueUnchecked = "N";
selectnew.ValueGrayed = "-";
selectnew.QueryCheckStateByValue += new DevExpress.XtraEditors.Controls.QueryCheckStateByValueEventHandler(QueryCheckStateByValue);
GV_Main.Columns["Select"].OptionsColumn.ReadOnly = false;
GV_Main.OptionsBehavior.Editable = true;
GV_Main.OptionsBehavior.ReadOnly = false;
GV_Main.OptionsSelection.MultiSelect = true;
for (int i = 0; i < GV_Main.Columns.Count - 1; i++)
{
GV_Main.Columns[i].Caption = F2.DISPLAY[i];
}
tbName.Properties.Items.Clear();
for (int i = 0; i < F2.DISPLAY.Count(); i++)
{
tbName.Properties.Items.Add(GV_Main.Columns[i].FieldName + " " + F2.DISPLAY[i]);
}
if (tbName.Properties.Items.Count > 0)
{
tbName.SelectedIndex = 0;
}
GV_Main.BestFitColumns();
return(true);
}
}
}
//conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
fc.ErrorLog(ex.Message);
return(false);
}
}
}
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
this.BarManager1 = new DevExpress.XtraBars.BarManager(this.components);
this.Bar1 = new DevExpress.XtraBars.Bar();
this.BarEditItem1 = new DevExpress.XtraBars.BarEditItem();
this.RepositoryItemCheckEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit();
this.BarEditItem2 = new DevExpress.XtraBars.BarEditItem();
this.RepositoryItemTextEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit();
this.BarButtonItem1 = new DevExpress.XtraBars.BarButtonItem();
this.barCheckItem1 = new DevExpress.XtraBars.BarCheckItem();
this.barDockControlTop = new DevExpress.XtraBars.BarDockControl();
this.barDockControlBottom = new DevExpress.XtraBars.BarDockControl();
this.barDockControlLeft = new DevExpress.XtraBars.BarDockControl();
this.barDockControlRight = new DevExpress.XtraBars.BarDockControl();
this.TextEdit1 = new DevExpress.XtraEditors.TextEdit();
((System.ComponentModel.ISupportInitialize)(this.BarManager1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.RepositoryItemCheckEdit1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.RepositoryItemTextEdit1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.TextEdit1.Properties)).BeginInit();
this.SuspendLayout();
//
// BarManager1
//
this.BarManager1.Bars.AddRange(new DevExpress.XtraBars.Bar[] {
this.Bar1});
this.BarManager1.DockControls.Add(this.barDockControlTop);
this.BarManager1.DockControls.Add(this.barDockControlBottom);
this.BarManager1.DockControls.Add(this.barDockControlLeft);
this.BarManager1.DockControls.Add(this.barDockControlRight);
this.BarManager1.Form = this;
this.BarManager1.Items.AddRange(new DevExpress.XtraBars.BarItem[] {
this.BarEditItem1,
this.BarEditItem2,
this.BarButtonItem1,
this.barCheckItem1});
this.BarManager1.MaxItemId = 4;
this.BarManager1.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] {
this.RepositoryItemCheckEdit1,
this.RepositoryItemTextEdit1});
//
// Bar1
//
this.Bar1.BarName = "Custom 1";
this.Bar1.DockCol = 0;
this.Bar1.DockRow = 0;
this.Bar1.DockStyle = DevExpress.XtraBars.BarDockStyle.Top;
this.Bar1.LinksPersistInfo.AddRange(new DevExpress.XtraBars.LinkPersistInfo[] {
new DevExpress.XtraBars.LinkPersistInfo(this.BarEditItem1),
new DevExpress.XtraBars.LinkPersistInfo(DevExpress.XtraBars.BarLinkUserDefines.Width, this.BarEditItem2, "", false, true, true, 135),
new DevExpress.XtraBars.LinkPersistInfo(this.BarButtonItem1),
new DevExpress.XtraBars.LinkPersistInfo(this.barCheckItem1)});
this.Bar1.Text = "Custom 1";
//
// BarEditItem1
//
this.BarEditItem1.Caption = "BarEditItem1";
this.BarEditItem1.Edit = this.RepositoryItemCheckEdit1;
this.BarEditItem1.Id = 0;
this.BarEditItem1.Name = "BarEditItem1";
this.BarEditItem1.EditValueChanged += new System.EventHandler(this.OnBarEditItemValueChanged);
//
// RepositoryItemCheckEdit1
//
this.RepositoryItemCheckEdit1.AutoHeight = false;
this.RepositoryItemCheckEdit1.Name = "RepositoryItemCheckEdit1";
//
// BarEditItem2
//
this.BarEditItem2.Caption = "BarEditItem2";
this.BarEditItem2.Edit = this.RepositoryItemTextEdit1;
this.BarEditItem2.Id = 1;
this.BarEditItem2.Name = "BarEditItem2";
this.BarEditItem2.EditValueChanged += new System.EventHandler(this.OnBarEditItemValueChanged);
//
// RepositoryItemTextEdit1
//
this.RepositoryItemTextEdit1.AutoHeight = false;
this.RepositoryItemTextEdit1.Name = "RepositoryItemTextEdit1";
//
// BarButtonItem1
//
this.BarButtonItem1.Caption = "BarButtonItem1";
this.BarButtonItem1.Id = 2;
this.BarButtonItem1.Name = "BarButtonItem1";
//
// barCheckItem1
//
this.barCheckItem1.Caption = "SaveImmediately";
this.barCheckItem1.Id = 3;
this.barCheckItem1.Name = "barCheckItem1";
this.barCheckItem1.CheckedChanged += new DevExpress.XtraBars.ItemClickEventHandler(this.barCheckItem1_CheckedChanged);
//
// barDockControlTop
//
this.barDockControlTop.CausesValidation = false;
this.barDockControlTop.Dock = System.Windows.Forms.DockStyle.Top;
this.barDockControlTop.Location = new System.Drawing.Point(0, 0);
this.barDockControlTop.Size = new System.Drawing.Size(472, 29);
//
// barDockControlBottom
//
this.barDockControlBottom.CausesValidation = false;
this.barDockControlBottom.Dock = System.Windows.Forms.DockStyle.Bottom;
this.barDockControlBottom.Location = new System.Drawing.Point(0, 261);
this.barDockControlBottom.Size = new System.Drawing.Size(472, 0);
//
// barDockControlLeft
//
this.barDockControlLeft.CausesValidation = false;
this.barDockControlLeft.Dock = System.Windows.Forms.DockStyle.Left;
this.barDockControlLeft.Location = new System.Drawing.Point(0, 29);
this.barDockControlLeft.Size = new System.Drawing.Size(0, 232);
//
// barDockControlRight
//
this.barDockControlRight.CausesValidation = false;
this.barDockControlRight.Dock = System.Windows.Forms.DockStyle.Right;
this.barDockControlRight.Location = new System.Drawing.Point(472, 29);
this.barDockControlRight.Size = new System.Drawing.Size(0, 232);
//
// TextEdit1
//
this.TextEdit1.EditValue = "TextEdit1";
this.TextEdit1.Location = new System.Drawing.Point(27, 76);
this.TextEdit1.Name = "TextEdit1";
this.TextEdit1.Size = new System.Drawing.Size(173, 20);
this.TextEdit1.TabIndex = 4;
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(472, 261);
this.Controls.Add(this.TextEdit1);
this.Controls.Add(this.barDockControlLeft);
this.Controls.Add(this.barDockControlRight);
this.Controls.Add(this.barDockControlBottom);
this.Controls.Add(this.barDockControlTop);
this.Name = "Form1";
this.Text = "How to save an in-place editor\'s value to a BarEditItem immediately when it\'s cha" +
"nged";
((System.ComponentModel.ISupportInitialize)(this.BarManager1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.RepositoryItemCheckEdit1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.RepositoryItemTextEdit1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.TextEdit1.Properties)).EndInit();
this.ResumeLayout(false);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit repositoryItemCheckEdit2;
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(FormNewMemberCreditPackageUsage));
DevExpress.XtraEditors.Repository.RepositoryItemTextEdit repositoryItemTextEdit1;
this.lkpEdtPackageCode = new DevExpress.XtraEditors.LookUpEdit();
this.label1 = new System.Windows.Forms.Label();
this.simpleButtonCancel = new DevExpress.XtraEditors.SimpleButton();
this.simpleButtonOK = new DevExpress.XtraEditors.SimpleButton();
this.label3 = new System.Windows.Forms.Label();
this.gridControl1 = new DevExpress.XtraGrid.GridControl();
this.gridView1 = new DevExpress.XtraGrid.Views.Grid.GridView();
this.gridColumn4 = new DevExpress.XtraGrid.Columns.GridColumn();
this.gridColumn1 = new DevExpress.XtraGrid.Columns.GridColumn();
this.Quantity = new DevExpress.XtraGrid.Columns.GridColumn();
this.repositoryItemSpinEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemSpinEdit();
this.gridColumn2 = new DevExpress.XtraGrid.Columns.GridColumn();
this.gridColumn3 = new DevExpress.XtraGrid.Columns.GridColumn();
this.gridView2 = new DevExpress.XtraGrid.Views.Grid.GridView();
this.checkedComboBoxEdit1 = new DevExpress.XtraEditors.CheckedComboBoxEdit();
repositoryItemCheckEdit2 = new DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit();
repositoryItemTextEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit();
((System.ComponentModel.ISupportInitialize)(repositoryItemCheckEdit2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(repositoryItemTextEdit1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.lkpEdtPackageCode.Properties)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.gridControl1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.gridView1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemSpinEdit1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.gridView2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.checkedComboBoxEdit1.Properties)).BeginInit();
this.SuspendLayout();
//
// repositoryItemCheckEdit2
//
resources.ApplyResources(repositoryItemCheckEdit2, "repositoryItemCheckEdit2");
repositoryItemCheckEdit2.Name = "repositoryItemCheckEdit2";
//
// repositoryItemTextEdit1
//
resources.ApplyResources(repositoryItemTextEdit1, "repositoryItemTextEdit1");
repositoryItemTextEdit1.Name = "repositoryItemTextEdit1";
//
// lkpEdtPackageCode
//
resources.ApplyResources(this.lkpEdtPackageCode, "lkpEdtPackageCode");
this.lkpEdtPackageCode.Name = "lkpEdtPackageCode";
this.lkpEdtPackageCode.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(((DevExpress.XtraEditors.Controls.ButtonPredefines)(resources.GetObject("lkpEdtPackageCode.Properties.Buttons"))))});
this.lkpEdtPackageCode.EditValueChanged += new System.EventHandler(this.lkpEdtPackageCode_EditValueChanged);
//
// label1
//
resources.ApplyResources(this.label1, "label1");
this.label1.Name = "label1";
//
// simpleButtonCancel
//
this.simpleButtonCancel.DialogResult = System.Windows.Forms.DialogResult.Cancel;
resources.ApplyResources(this.simpleButtonCancel, "simpleButtonCancel");
this.simpleButtonCancel.Name = "simpleButtonCancel";
//
// simpleButtonOK
//
this.simpleButtonOK.DialogResult = System.Windows.Forms.DialogResult.OK;
resources.ApplyResources(this.simpleButtonOK, "simpleButtonOK");
this.simpleButtonOK.Name = "simpleButtonOK";
this.simpleButtonOK.Click += new System.EventHandler(this.simpleButtonOK_Click);
//
// label3
//
resources.ApplyResources(this.label3, "label3");
this.label3.Name = "label3";
//
// gridControl1
//
resources.ApplyResources(this.gridControl1, "gridControl1");
this.gridControl1.MainView = this.gridView1;
this.gridControl1.Name = "gridControl1";
this.gridControl1.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] {
repositoryItemCheckEdit2,
repositoryItemTextEdit1,
this.repositoryItemSpinEdit1});
this.gridControl1.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] {
this.gridView1,
this.gridView2});
//
// gridView1
//
this.gridView1.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] {
this.gridColumn4,
this.gridColumn1,
this.Quantity,
this.gridColumn2,
this.gridColumn3});
this.gridView1.GridControl = this.gridControl1;
this.gridView1.Name = "gridView1";
this.gridView1.FocusedRowChanged += new DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventHandler(this.gridView1_FocusedRowChanged);
//
// gridColumn4
//
resources.ApplyResources(this.gridColumn4, "gridColumn4");
this.gridColumn4.ColumnEdit = repositoryItemCheckEdit2;
this.gridColumn4.FieldName = "Tick";
this.gridColumn4.Name = "gridColumn4";
//
// gridColumn1
//
resources.ApplyResources(this.gridColumn1, "gridColumn1");
this.gridColumn1.FieldName = "strPackageCode";
this.gridColumn1.Name = "gridColumn1";
this.gridColumn1.OptionsColumn.AllowEdit = false;
//
// Quantity
//
resources.ApplyResources(this.Quantity, "Quantity");
this.Quantity.ColumnEdit = this.repositoryItemSpinEdit1;
this.Quantity.FieldName = "nQuantity";
this.Quantity.Name = "Quantity";
//
// repositoryItemSpinEdit1
//
this.repositoryItemSpinEdit1.AllowNullInput = DevExpress.Utils.DefaultBoolean.False;
resources.ApplyResources(this.repositoryItemSpinEdit1, "repositoryItemSpinEdit1");
this.repositoryItemSpinEdit1.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton()});
this.repositoryItemSpinEdit1.IsFloatValue = false;
this.repositoryItemSpinEdit1.Mask.EditMask = resources.GetString("repositoryItemSpinEdit1.Mask.EditMask");
this.repositoryItemSpinEdit1.MaxValue = new decimal(new int[] {
100,
0,
0,
0});
this.repositoryItemSpinEdit1.MinValue = new decimal(new int[] {
1,
0,
0,
0});
this.repositoryItemSpinEdit1.Name = "repositoryItemSpinEdit1";
//
// gridColumn2
//
resources.ApplyResources(this.gridColumn2, "gridColumn2");
this.gridColumn2.FieldName = "strDescription";
this.gridColumn2.Name = "gridColumn2";
this.gridColumn2.OptionsColumn.AllowEdit = false;
//
// gridColumn3
//
resources.ApplyResources(this.gridColumn3, "gridColumn3");
this.gridColumn3.FieldName = "dtValidEnd";
this.gridColumn3.Name = "gridColumn3";
this.gridColumn3.OptionsColumn.AllowEdit = false;
//
// gridView2
//
this.gridView2.GridControl = this.gridControl1;
this.gridView2.Name = "gridView2";
//
// checkedComboBoxEdit1
//
resources.ApplyResources(this.checkedComboBoxEdit1, "checkedComboBoxEdit1");
this.checkedComboBoxEdit1.Name = "checkedComboBoxEdit1";
this.checkedComboBoxEdit1.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(((DevExpress.XtraEditors.Controls.ButtonPredefines)(resources.GetObject("checkedComboBoxEdit1.Properties.Buttons"))))});
//
// FormNewMemberCreditPackageUsage
//
this.AcceptButton = this.simpleButtonOK;
resources.ApplyResources(this, "$this");
this.CancelButton = this.simpleButtonCancel;
this.Controls.Add(this.checkedComboBoxEdit1);
this.Controls.Add(this.gridControl1);
this.Controls.Add(this.label3);
this.Controls.Add(this.simpleButtonCancel);
this.Controls.Add(this.simpleButtonOK);
this.Controls.Add(this.label1);
this.Controls.Add(this.lkpEdtPackageCode);
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedDialog;
this.MaximizeBox = false;
this.MinimizeBox = false;
this.Name = "FormNewMemberCreditPackageUsage";
this.ShowInTaskbar = false;
((System.ComponentModel.ISupportInitialize)(repositoryItemCheckEdit2)).EndInit();
((System.ComponentModel.ISupportInitialize)(repositoryItemTextEdit1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.lkpEdtPackageCode.Properties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.gridControl1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.gridView1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemSpinEdit1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.gridView2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.checkedComboBoxEdit1.Properties)).EndInit();
this.ResumeLayout(false);
}
