/// <summary>
/// 根据ID找出员工名字
/// </summary>
/// <returns></returns>
public static string SelectStaffNameByID(string staffId)
{
if (mySqlclient == null)
{
mySqlclient = MySqlClient.GetMySqlClient();
}
string sql = @"SELECT StaffName FROM StaffInfo WHERE StaffId=@StaffId " + ANDCOMPANYID;
List <MySqlParameter> parameters = new List <MySqlParameter>()
{
new MySqlParameter("@StaffId", MySqlDbType.String)
};
parameters[0].Value = staffId;
return(mySqlclient.ExecuteScalar(sql, parameters) as string);
}
public static object InsertDataRetrunID(object data)
{
if (mySqlclient == null)
{
mySqlclient = MySqlClient.GetMySqlClient();
}
Type type = data.GetType();
DataAttr dataAttr = (DataAttr)type.GetCustomAttribute(typeof(DataAttr), false);
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO ");
sb.Append(dataAttr.TableName + "(");
PropertyInfo[] propertyInfos = type.GetProperties();
foreach (PropertyInfo info in propertyInfos)
{
DataAttr infoAttr = (DataAttr)info.GetCustomAttribute(typeof(DataAttr), false);
if (infoAttr == null)
{
continue;
}
if (infoAttr.Bquery)
{
sb.Append(info.Name + ",");
}
}
sb.Remove(sb.Length - 1, 1);//移除 多余的 ","
sb.Append(")");
sb.Append("VALUES(");
foreach (PropertyInfo info in propertyInfos)
{
DataAttr infoAttr = (DataAttr)info.GetCustomAttribute(typeof(DataAttr), false);
if (infoAttr == null)
{
continue;
}
if (infoAttr.Bquery)
{
sb.Append("@" + info.Name + ",");
}
}
sb.Remove(sb.Length - 1, 1);//移除 多余的 ","
sb.Append(") ; select @@identity");
List <MySqlParameter> parameters = new List <MySqlParameter>();
for (int i = 0; i < propertyInfos.Length; ++i)
{
PropertyInfo info = propertyInfos[i];
DataAttr infoAttr = (DataAttr)info.GetCustomAttribute(typeof(DataAttr), false);
if (infoAttr == null)
{
continue;
}
if (infoAttr.Bquery)
{
string strPara = "@" + info.Name;
MySqlParameter parameter = new MySqlParameter(strPara, ConvertDBType(info.PropertyType));
parameter.Value = info.GetValue(data);
parameters.Add(parameter);
}
}
object id = mySqlclient.ExecuteScalar(sb.ToString(), parameters.ToList(), CommandType.Text);
return(id);
}
