1 windowsFrom 在panel中显示窗体:
/// <summary>
/// 将窗体添加到Panel
/// </summary>
/// <param name="aForm">Form</param>
/// <param name="aPanel">Panel</param>
public static void AddFormToPanel(Form aForm, Panel aPanel)
{
aPanel.Controls.Clear();//清空窗体上的控件
aForm.TopLevel = false;//取消顶级窗口
aForm.FormBorderStyle = FormBorderStyle.None;//去掉边框样式
aForm.Dock = DockStyle.Fill;//设置填充样式
aPanel.Controls.Add(aForm);
aForm.Show();
}
2DataReadar转换为实体类,与向存储过程批量添加参数
/// <summary>
/// 用反射将DataReader对象转换为实体
/// </summary>
/// <param name="reader">IDataReader对象</param>
/// <param name="targetObj">转换成的实体</param>
public static void ReaderToObject(IDataReader reader, object targetObj)
{
try
{
for (int i = 0; i < reader.FieldCount; i++)
{
System.Reflection.PropertyInfo propertyInfo = targetObj.GetType().GetProperty(reader.GetName(i));
if (propertyInfo != null)
{
if (reader.GetValue(i) != DBNull.Value)
{
if (propertyInfo.PropertyType.IsEnum)
{
propertyInfo.SetValue(targetObj, Enum.ToObject(propertyInfo.PropertyType, reader.GetValue(i)), null);
}
else
{
propertyInfo.SetValue(targetObj, reader.GetValue(i), null);
}
}
}
}
}
catch
{
throw;
}
}
/// <summary>
/// 为SqlCommand添加参数
/// </summary>
/// <param name="aEntityObj">实体对象</param>
/// <param name="aSqlCommand">SqlCommand对象</param>
public static void AddEntityParameters(object aEntityObj, SqlCommand aSqlCommand)
{
try
{
if (aEntityObj != null)
{
PropertyInfo[] propertyInfo = aEntityObj.GetType().GetProperties();//获取对象的所有共有属性
if (propertyInfo != null)
{
foreach (PropertyInfo aPro in propertyInfo)//遍历每个属性
{
string propertyInfoName = aPro.Name;//获取属性的名
object propertyInfoValue = aPro.GetValue(aEntityObj, null);//获取对象该属性的值
if (propertyInfoValue != null)
{
if (propertyInfoValue.GetType() == typeof(DateTime) && propertyInfoValue.ToString() == "0001/1/1 0:00:00")//排除时间是空的情况
{
continue;
}
aSqlCommand.Parameters.AddWithValue(propertyInfoName, propertyInfoValue);//添加到参数
}
}
}
}
}
catch
{
throw;
}
}