//会员注册
public static int MemberRegister(List <object> infoList)
{
if (mySqlclient == null)
{
mySqlclient = MySqlClient.GetMySqlClient();
}
StringBuilder sb = new StringBuilder();
sb.Append("memberRegister ");//存储过程名称
List <MySqlParameter> parameters = new List <MySqlParameter>()
{
new MySqlParameter("@v_mid", MySqlDbType.String),
new MySqlParameter("@v_mname", MySqlDbType.String),
new MySqlParameter("@v_cardName", MySqlDbType.String),
new MySqlParameter("@v_phone", MySqlDbType.String),
new MySqlParameter("@v_status", MySqlDbType.String),
new MySqlParameter("@v_balance", MySqlDbType.Double),
new MySqlParameter("@v_companyId", MySqlDbType.Int32)
};
parameters[0].Value = infoList[0];
parameters[1].Value = infoList[1];
parameters[2].Value = infoList[2];
parameters[3].Value = infoList[3];
parameters[4].Value = infoList[4];
parameters[5].Value = infoList[5];
parameters[6].Value = infoList[6];
return(mySqlclient.ExecuteNonQuery(sb.ToString(), parameters, CommandType.StoredProcedure));
}
public static int DelSkillByID(int id)
{
if (mySqlclient == null)
mySqlclient = MySqlClient.GetMySqlClient();
StringBuilder sb = new StringBuilder();
sb.Append("DELETE FROM Skill ");
//筛选条件
sb.Append("WHERE SkillId = @SkillId ");
sb.Append(ANDCOMPANYID);
List<MySqlParameter> parameters = new List<MySqlParameter>(){
new MySqlParameter("@SkillId", MySqlDbType.Int32)
};
parameters[0].Value = id;
return mySqlclient.ExecuteNonQuery(sb.ToString(), parameters, CommandType.Text);
}
//会员挂失
public static int MemberLossByID(string id)
{
if (mySqlclient == null)
{
mySqlclient = MySqlClient.GetMySqlClient();
}
StringBuilder sb = new StringBuilder();
sb.Append("UPDATE member SET MStatus= @MStatus ");
//筛选条件
sb.Append("WHERE MId = @MId ");
sb.Append(ANDCOMPANYID);
List <MySqlParameter> parameters = new List <MySqlParameter>()
{
new MySqlParameter("@MStatus", MySqlDbType.String),
new MySqlParameter("@MId", MySqlDbType.String)
};
parameters[0].Value = "挂失";
parameters[1].Value = id;
return(mySqlclient.ExecuteNonQuery(sb.ToString(), parameters, CommandType.Text));
}
public static int InsertData(object data, Type type)
{
if (mySqlclient == null)
{
mySqlclient = MySqlClient.GetMySqlClient();
}
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(")");
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);
}
}
return(mySqlclient.ExecuteNonQuery(sb.ToString(), parameters, CommandType.Text));
}
