private void cbox_SelectedIndexChanged(object sender, EventArgs e)
{
if (bcbox_SelectedIndexChanged)
{
myComboBox cbox = (myComboBox)sender;
string fieldName = cbox.Name.Replace("cbox_", "");
rowHead[fieldName] = cbox.SelectedValue;
}
}
private void showCombo(int col, int row)
{
Debug.WriteLine("showCombo");
m_combo = new myComboBox(dGV_receipt);
dGV_receipt.Controls.Add(m_combo);
Rectangle Rectangle = dGV_receipt.GetCellDisplayRectangle(col, row, true);
m_combo.Size = Rectangle.Size;
m_combo.Location = Rectangle.Location;
m_combo.SelectedText = dGV_receipt.CurrentCell.Value.ToString();
m_combo.Visible = true;
ActiveControl = m_combo;
dGV_receipt.BeginEdit(true);
//m_isEditing = true;
}
/// <summary>
/// 根据控件生成查询条件串
/// </summary>
/// <param name="control"></param>
public void MakeQueryWhere(Control control)
{
string strControlName = control.Name; //控件名称
string strFieldName = string.Empty; //控件对应的字段名
if (strControlName.StartsWith("txt_")) //textbox控件
{
myTextBox tb = (myTextBox)control;
if (tb.Text.Trim().Length > 0)
{
strFieldName = tb.Tag.ToString();
if (this.myCheckBox1.Checked) //模糊查询
{
strReturnWhere += (strReturnWhere.Length > 0 ? " and " : "") + string.Format("{0} like '%{1}%'", strFieldName, StringTools.SqlLikeQ(tb.Text.Trim()));
}
else //精确查询
{
strReturnWhere += (strReturnWhere.Length > 0 ? " and " : "") + string.Format("{0}={1}", strFieldName, StringTools.SqlQ(tb.Text.Trim()));
}
}
}
else if (strControlName.StartsWith("cbox_")) //下拉控件
{
myComboBox cbox = (myComboBox)control;
if (cbox.SelectedValue != null && cbox.SelectedValue.ToString().Length > 0)
{
string tag = cbox.Tag.ToString();
string dataType = tag.Split(',')[0];
strFieldName = tag.Split(',')[1];
if (dataType == "string")
{
strReturnWhere += (strReturnWhere.Length > 0 ? " and " : "") + string.Format("{0}={1}", strFieldName, StringTools.SqlQ(cbox.SelectedValue.ToString()));
}
else if (dataType == "int")
{
strReturnWhere += (strReturnWhere.Length > 0 ? " and " : "") + string.Format("{0}={1}", strFieldName, cbox.SelectedValue);
}
}
}
else if (strControlName.StartsWith("date_")) //日期控件
{
myDateTimePicker dtp = (myDateTimePicker)control;
if (dtp.Checked)
{
string tag = dtp.Tag.ToString();
string index = tag.Split(',')[0];
strFieldName = tag.Split(',')[1];
if (index == "0") //表示是指定日期
{
strReturnWhere += (strReturnWhere.Length > 0 ? " and " : "") + string.Format("{0}={1}", strFieldName, dtp.Value.ToShortDateString());
}
else if (index == "1") //表示起始日期
{
strReturnWhere += (strReturnWhere.Length > 0 ? " and " : "") + string.Format("{0}>='{1} 00:00:01'", strFieldName, dtp.Value.ToShortDateString());
}
else if (index == "2") //表示截止日期
{
strReturnWhere += (strReturnWhere.Length > 0 ? " and " : "") + string.Format("{0}<'{1} 23:59:59'", strFieldName, dtp.Value.ToShortDateString());
}
}
}
else if (strControlName.StartsWith("datetime_")) //日期(包含时间)控件
{
myDateTimePicker dtp = (myDateTimePicker)control;
if (dtp.Checked)
{
string tag = dtp.Tag.ToString();
string index = tag.Split(',')[0];
strFieldName = tag.Split(',')[1];
if (index == "1") //表示起始时间
{
strReturnWhere += (strReturnWhere.Length > 0 ? " and " : "") + string.Format("{0}>='{1}'", strFieldName, dtp.Value.ToString("yyyy-MM-dd HH:mm:ss"));
}
else if (index == "2") //表示截止时间
{
strReturnWhere += (strReturnWhere.Length > 0 ? " and " : "") + string.Format("{0}<'{1}'", strFieldName, dtp.Value.ToString("yyyy-MM-dd HH:mm:ss"));
}
}
}
}
public myItems(myComboBox parent)
{
parentCB = parent; // reference to the outer class
}
