/// <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); }