private void colRight_SelectedIndexChanged(object sender, EventArgs e)
{
Heren.Common.Controls.TableView.FindComboBoxEditingControl control = sender as Heren.Common.Controls.TableView.FindComboBoxEditingControl;
if (control.SelectedItem != null)
{
GyGydm gyGydm = control.SelectedItem as GyGydm;
this.dataTableView1.CurrentRow.Cells[this.col_DM.Index].Value = gyGydm.DM;
}
}
private void LoadMC(RecCodeCompasion recCodeCompasion)
{
if (this.col_MC.Items == null)
{
return;
}
//待选项
this.col_MC.Items.Clear();
DataSet ds = null;
short shRet = BAJKCommonAccess.Instance.ExecuteQuery(recCodeCompasion.TO_SQL, out ds);
if (m_lstGyGydm == null)
{
m_lstGyGydm = new List <GyGydm>();
}
m_lstGyGydm.Clear();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
this.m_lstGyGydm.Clear();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
GyGydm item = new GyGydm();
item.DM = ds.Tables[0].Rows[i]["DM"].ToString();
item.DMLB = ds.Tables[0].Rows[i]["DMLB"].ToString();
item.MC = ds.Tables[0].Rows[i]["MC"].ToString();
m_lstGyGydm.Add(item);
}
}
if (m_lstGyGydm == null)
{
return;
}
foreach (GyGydm item in m_lstGyGydm)
{
this.col_MC.Items.Add(item);
}
}
public short GetGyGydms(string mc, string dmlb, ref List <GyGydm> lstGyGydms)
{
if (base.BAJKDataAccess == null)
{
return(SystemData.ReturnValue.PARAM_ERROR);
}
StringBuilder sbField = new StringBuilder();
sbField.AppendFormat("{0},", SystemData.GyGydmTable.DM);
sbField.AppendFormat("{0},", SystemData.GyGydmTable.DMLB);
sbField.AppendFormat("{0}", SystemData.GyGydmTable.MC);
string szCondition = string.Format("1=1");
szCondition = string.Format("{0} AND {1} = '{2}' "
, szCondition
, SystemData.GyGydmTable.DMLB
, dmlb);
if (!string.IsNullOrEmpty(mc))
{
szCondition = string.Format("{0} AND {1} like '%{2}%' "
, szCondition
, SystemData.GyGydmTable.MC
, mc);
}
string szOrderBy = string.Format("{0}", SystemData.GyGydmTable.DM);
string szSQL = string.Format(SystemData.SQL.SELECT_WHERE_ORDER_ASC
, sbField.ToString(), TableName, szCondition, szOrderBy);
IDataReader dataReader = null;
try
{
dataReader = base.BAJKDataAccess.ExecuteReader(szSQL, CommandType.Text);
if (dataReader == null || dataReader.IsClosed || !dataReader.Read())
{
return(SystemData.ReturnValue.RES_NO_FOUND);
}
if (lstGyGydms == null)
{
lstGyGydms = new List <GyGydm>();
}
do
{
GyGydm item = new GyGydm();
for (int i = 0; i < dataReader.FieldCount; i++)
{
if (dataReader.IsDBNull(i))
{
continue;
}
switch (dataReader.GetName(i))
{
case SystemData.GyGydmTable.DM:
item.DM = dataReader.GetValue(i).ToString();
break;
case SystemData.GyGydmTable.DMLB:
item.DMLB = dataReader.GetValue(i).ToString();
break;
case SystemData.GyGydmTable.MC:
item.MC = dataReader.GetValue(i).ToString();
break;
default: break;
}
}
lstGyGydms.Add(item);
} while (dataReader.Read());
return(SystemData.ReturnValue.OK);
}
catch (Exception ex)
{
LogManager.Instance.WriteLog("", new string[] { "szSQL" }, new object[] { szSQL }, ex);
return(SystemData.ReturnValue.EXCEPTION);
}
finally { base.BAJKDataAccess.CloseConnnection(false); }
}
