public bool AddMember(memberType model)
{
bool result = false;
result = memberdal.AddMemberType(model);
return(result);
}
private void button1_Click(object sender, EventArgs e)
{
memberType user = new memberType();
user.memberName = hymctextBox.Text.Trim();
user.memberTypechild = splxcomboBox.SelectedItem.ToString();
user.memberCardMoney = bkjetextBox.Text.Trim();
user.memberRebate = spzktextBox.Text.Trim();
user.memberTopUp = czcstextBox.Text.Trim();
user.memberSend = Convert.ToDouble(Convert.ToDouble(bkjetextBox.Text.Trim()) / Convert.ToInt32(czcstextBox.Text.Trim()));
memberTypeCURD memberType = new memberTypeCURD();
bool result = memberType.EditMemberUp(user);
if (result)
{
MessageBox.Show("修改成功！");
editsuccess();
this.Close();
}
else
{
MessageBox.Show("修改失败！");
editsuccess();
this.Close();
}
}
/// <summary>
/// 成员信息转换为数据列
/// </summary>
/// <param name="type">成员类型</param>
/// <param name="sqlMember">SQL成员信息</param>
/// <returns>数据列</returns>
internal override column getColumn(Type type, dataMember sqlMember)
{
SqlDbType sqlType = SqlDbType.NVarChar;
int size = sqlMember.MaxStringLength;
memberType memberType = sqlMember.DataType != null ? sqlMember.DataType : type;
if (memberType.IsString)
{
if (size > 0)
{
sqlType = SqlDbType.NVarChar;
}
else
{
sqlType = SqlDbType.NText;
size = int.MaxValue;
}
}
else
{
sqlType = memberType.Type.formCSharpType();
size = sqlType.getSize();
}
return(new column
{
DbType = sqlType,
Size = size,
IsNull = (sqlMember.IsDefaultMember && !memberType.IsString ? ((memberType)type).IsNull : sqlMember.IsNull),
DefaultValue = sqlMember.DefaultValue,
UpdateValue = sqlMember.UpdateValue
});
}
//查询所有的信息
public List <memberType> SelectAllList(string name)
{
List <memberType> list = new List <memberType>();
memberType model;
string str = "select * from memberType where DPName=@DPName";
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@DPName", name)
};
SqlDataReader read = SqlHelper.ExecuteReader(str, pms);
while (read.Read())
{
if (read.HasRows)
{
model = new memberType();
model.memberCardMoney = read["memberCardMoney"].ToString();
model.memberRebate = read["memberRebate"].ToString();
model.memberTopUp = read["memberTopUp"].ToString();
model.memberTypechild = read["memberType"].ToString();
model.memberName = read["memberName"].ToString();
model.memberSend = Convert.ToDouble(read["memberSend"].ToString().Trim());
list.Add(model);
}
}
return(list);
}
public bool EditMemberUp(memberType model)
{
bool result = false;
result = memberdal.EditMemberUp(model);
return(result);
}
/// <summary>
/// 检测异步回调方法
/// </summary>
private void checkAsynchronousReturn()
{
if (methodParameters == null)
{
methodParameters = Method.Parameters;
methodReturnType = Method.ReturnType;
if (ServiceAttribute.IsAsynchronous && Attribute.IsAsynchronousCallback && Method.ReturnType.Type == typeof(void) && methodParameters.Length != 0)
{
Type type = methodParameters[methodParameters.Length - 1].ParameterType.Type;
if (type.IsGenericType && type.GetGenericTypeDefinition() == typeof(action <>))
{
Type parameterType = type.GetGenericArguments()[0];
if (parameterType == typeof(asynchronousReturn))
{
isAsynchronousCallback = true;
}
else if (parameterType.IsGenericType && parameterType.GetGenericTypeDefinition() == typeof(asynchronousReturn <>))
{
methodReturnType = parameterType.GetGenericArguments()[0];
isAsynchronousCallback = true;
}
if (isAsynchronousCallback)
{
methodParameters = parameterInfo.Get(methodParameters.getSub(0, methodParameters.Length - 1));
}
}
}
}
}
/// <summary>
/// 生成部分代码
/// </summary>
/// <param name="partName">部分名称</param>
/// <param name="typeName">类型名称</param>
/// <param name="members">成员集合</param>
/// <returns>部分代码</returns>
public static string PartCode(string partName, memberType type, setup.memberInfo[] members)
{
cSharp coder = new cSharp();
coder.type = type;
coder.Members = members;
coder.create(false);
return(coder._partCodes_[partName]);
}
public static hylxedit Create(memberType edit, editup ss)
{
edit1 = edit;
editsuccess = ss;
if (hyfl == null)
{
hyfl = new hylxedit();
}
return(hyfl);
}
private void hyflcomboBox_SelectedIndexChanged(object sender, EventArgs e)
{
string name = hyflcomboBox.Text;
memberType mode = bll.EditMember(name);
spzktextBox.Text = mode.memberRebate;
spzktextBox.ReadOnly = true;
fwzktextBox.Text = "0";
fwzktextBox.ReadOnly = true;
czjetextBox.Text = mode.memberTopUp;
czjetextBox.ReadOnly = true;
bkjetextBox.Text = mode.memberCardMoney;
textBox1.Text = mode.memberTypechild;
textBox1.ReadOnly = true;
}
private void hylbxgbutton_Click(object sender, EventArgs e)
{
var rows = dataGridView1.SelectedRows;
if (rows.Count != 1)
{
MessageBox.Show("请选择一条数据");
return;
}
string name = rows[0].Cells[0].Value.ToString();
memberType edit = memberbll.EditMember(name);
hylxedit zjhyfl = hylxedit.Create(edit, gridbind);
zjhyfl.Show();
zjhyfl.Focus();
}
/// <summary>
/// 加载店铺中会员卡的信息
/// </summary>
public void dataBind()
{
List <memberType> list = new List <memberType>();
list = memberbll.SelectAllList(FilterClass.DianPu1.UserName);
memberType model = new memberType()
{
memberName = "无卡",
memberTypechild = "",
memberCardMoney = "",
memberRebate = "",
memberTopUp = ""
};
list.Insert(0, model);
dataGridView1.DataSource = list;
}
//修改一个会员信息类别
public bool EditMemberUp(memberType user)
{
bool result = false;
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@memberName", user.memberName),
new SqlParameter("@memberType", user.memberTypechild),
new SqlParameter("@memberCardMoney", user.memberCardMoney),
new SqlParameter("@memberRebate", user.memberRebate),
new SqlParameter("@memberTopUp", user.memberTopUp),
new SqlParameter("@memberSend", user.memberSend),
new SqlParameter("@DPName", FilterClass.DianPu1.UserName.Trim())
};
if (SqlHelper.ExecuteNonQuery("update memberType set memberType=@memberType,memberCardMoney=@memberCardMoney,memberRebate=@memberRebate,memberTopUp=@memberTopUp,memberSend=@memberSend where memberName=@memberName and DPName=@DPName", pms) > 0)
{
result = true;
}
return(result);
}
//添加会员类别
public bool AddMemberType(memberType user)
{
bool result = false;
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@memberName", user.memberName),
new SqlParameter("@memberType", user.memberTypechild),
new SqlParameter("@memberCardMoney", user.memberCardMoney),
new SqlParameter("@memberRebate", user.memberRebate),
new SqlParameter("@memberTopUp", user.memberTopUp),
new SqlParameter("@memberSend", user.memberSend),
new SqlParameter("@DPName", FilterClass.DianPu1.UserName.Trim())
};
if (SqlHelper.ExecuteNonQuery("insert into memberType(memberName,memberType,memberCardMoney,memberRebate,memberTopUp,DPName,memberSend) values(@memberName,@memberType,@memberCardMoney,@memberRebate,@memberTopUp,@DPName,@memberSend)", pms) > 0)
{
result = true;
}
return(result);
}
//查询一个对象的详细信息
public memberType EditMember(string name)
{
string dpname = FilterClass.DianPu1.UserName.Trim();
memberType result = new memberType();
SqlParameter[] pms;
string str;
//if (dpname == "admin")
//{
// pms = new SqlParameter[] {
//new SqlParameter("@memberName",name)
//};
// str = "select * from memberType where memberName=@memberName";
//}
//else
//{
pms = new SqlParameter[] {
new SqlParameter("@memberName", name),
new SqlParameter("@DPName", dpname)
};
str = "select * from memberType where memberName=@memberName and DPName=@DPName";
//}
var read = SqlHelper.ExecuteReader(str, pms);
while (read.Read())
{
if (read.HasRows)
{
result.memberName = read[0].ToString();
result.memberTypechild = read[1].ToString();
result.memberCardMoney = read[2].ToString();
result.memberRebate = read[3].ToString();
result.memberTopUp = read[4].ToString();
}
}
return(result);
}
private void button1_Click(object sender, EventArgs e)
{
if (hymctextBox.Text == "" || bkjetextBox.Text == "" || spzktextBox.Text == "" || czcstextBox.Text == "")
{
MessageBox.Show("信息不能为空！");
}
else
{
memberType user = new memberType();
user.memberName = hymctextBox.Text.Trim();
user.memberTypechild = splxcomboBox.SelectedItem.ToString();
user.memberCardMoney = bkjetextBox.Text.Trim();
user.memberRebate = spzktextBox.Text.Trim();
user.memberTopUp = czcstextBox.Text.Trim();
user.memberSend = Convert.ToDouble(Convert.ToDouble(czcstextBox.Text.Trim()) / Convert.ToDouble(bkjetextBox.Text.Trim()));
memberTypeCURD memberType = new memberTypeCURD();
bool result = memberType.AddMember(user);
if (result)
{
MessageBox.Show("添加成功！");
this.Close();
}
}
}
public List <Member> getMembers(memberType type, int unitId, DateTime date = new DateTime())
{
List <Member> members = new List <Member>();
string sql = "SELECT id, first_name, last_name, " + common.formatDate("birthdate") +
", unit_id, " + common.formatDate("created_by") + ", member_record, (select count(0) from lds_frequency where created_by >= (curdate() - INTERVAL 3 MONTH) and member_id = m.id) presencas, restricted, gender, unit_member " +
"FROM bakeappdb.lds_member m where unit_id = @unit ";
string sqlCont = string.Empty;
switch (type)
{
case memberType.active:
// check last three months
sqlCont += " and id in (select member_id from lds_frequency where created_by >= (curdate() - INTERVAL 3 MONTH)) ";
break;
case memberType.absent:
// if absent last sunday
DateTime sunday = common.getLastSundayDate();
sqlCont += string.Format(" and id not in (select member_id from lds_frequency where created_by >= '{0}-{1}-{2}') ",
sunday.Year, sunday.Month.ToString().PadLeft(2, '0'), sunday.Day.ToString().PadLeft(2, '0'));
break;
case memberType.beehive:
// female ages 12 to 13
sqlCont += " and gender = 'F' and " +
"DATEDIFF(CURRENT_DATE, birthdate) >= (12 * 365.25) and " +
"DATEDIFF(CURRENT_DATE, birthdate) < (14 * 365.25) ";
break;
case memberType.miaMaid:
// female ages 14 to 15
sqlCont += " and gender = 'F' and " +
"DATEDIFF(CURRENT_DATE, birthdate) >= (14 * 365.25) and " +
"DATEDIFF(CURRENT_DATE, birthdate) < (16 * 365.25) ";
break;
case memberType.laurel:
// female ages 16 to 17
sqlCont += " and gender = 'F' and " +
"DATEDIFF(CURRENT_DATE, birthdate) >= (16 * 365.25) and " +
"DATEDIFF(CURRENT_DATE, birthdate) < (18 * 365.25) ";
break;
case memberType.deacon:
// male ages 12 to 13
sqlCont += " and id in (select member_id from lds_priesthood where reference = 1) ";
break;
case memberType.teacher:
// male ages 14 to 15
sqlCont += " and id in (select member_id from lds_priesthood where reference = 2) ";
break;
case memberType.priest:
// male ages 16 to 17
sqlCont += " and id in (select member_id from lds_priesthood where reference = 3) ";
break;
case memberType.elder:
// male ages 18+ minus high priest or elder
sqlCont += " and gender = 'M' and " +
"DATEDIFF(CURRENT_DATE, birthdate) >= (18 * 365.25) and id not in (select member_id from lds_priesthood where reference = 5) ";
break;
case memberType.highPriest:
// male with high priest
sqlCont += " and id in (select member_id from lds_priesthood where reference = 5) ";
break;
case memberType.reliefSociety:
// female ages 18+
sqlCont += " and gender = 'F' and " +
"DATEDIFF(CURRENT_DATE, birthdate) >= (18 * 365.25) ";
break;
case memberType.sundaySchool:
// members 18+
sqlCont += " and DATEDIFF(CURRENT_DATE, birthdate) >= (18 * 365.25) ";
break;
case memberType.sundaySchoolYouth:
// members ages 12 to 17
sqlCont += " and DATEDIFF(CURRENT_DATE, birthdate) >= (12 * 365.25) and " +
"DATEDIFF(CURRENT_DATE, birthdate) < (18 * 365.25) ";
break;
case memberType.primary:
// members age 0 to 11
sqlCont += " and DATEDIFF(CURRENT_DATE, birthdate) < (12 * 365.25) ";
break;
case memberType.youngMen:
// men age 12 to 17
sqlCont += " and gender = 'M' and " +
"DATEDIFF(CURRENT_DATE, birthdate) >= (12 * 365.25) and " +
"DATEDIFF(CURRENT_DATE, birthdate) < (18 * 365.25) ";
break;
case memberType.youngWomen:
// women age 12 to 17
sqlCont += " and gender = 'F' and " +
"DATEDIFF(CURRENT_DATE, birthdate) >= (12 * 365.25) and " +
"DATEDIFF(CURRENT_DATE, birthdate) < (18 * 365.25) ";
break;
case memberType.adultsMen:
// men age 18+
sqlCont += " and gender = 'M' and " +
"DATEDIFF(CURRENT_DATE, birthdate) >= (18 * 365.25) ";
break;
}
sql += sqlCont + " order by last_name, first_name";
foreach (List <string> data in database.retrieveData(sql, unitId))
{
Member member = new Member();
member.Id = common.convertNumber(data[0]);
member.FirstName = data[1];
member.LastName = data[2];
member.BirthDate = common.convertDate(data[3]);
member.Date = common.convertDate(data[5]);
member.MemberRecord = data[6];
member.Actived = (data[7] != "0");
member.Restricted = common.convertBool(data[8]);
member.Gender = data[9];
member.Present = new Frequency().wasPresent(member.Id, date, type);
member.isUnitMember = common.convertBool(data[10]);
members.Add(member);
}
members = members.OrderByDescending(m => m.Actived).ThenBy(m => m.LastName).ThenBy(m => m.FirstName).ToList();
return(members);
}
MemberTypes.Constructor => GetMethodInfo(memberType, className),
MemberTypes.Property => GetMethodInfo(memberType, className, methodName),
_ => GetMethodInfo(memberType, className, methodName),
public List<Member> getMembers(memberType type, int unitId, DateTime date = new DateTime())
{
List<Member> members = new List<Member>();
string sql = "SELECT id, first_name, last_name, " + common.formatDate("birthdate") +
", unit_id, " + common.formatDate("created_by") + ", member_record, (select count(0) from lds_frequency where created_by >= (curdate() - INTERVAL 3 MONTH) and member_id = m.id) presencas, restricted, gender, unit_member " +
"FROM bakeappdb.lds_member m where unit_id = @unit ";
string sqlCont = string.Empty;
switch (type)
{
case memberType.active:
// check last three months
sqlCont += " and id in (select member_id from lds_frequency where created_by >= (curdate() - INTERVAL 3 MONTH)) ";
break;
case memberType.absent:
// if absent last sunday
DateTime sunday = common.getLastSundayDate();
sqlCont += string.Format(" and id not in (select member_id from lds_frequency where created_by >= '{0}-{1}-{2}') ",
sunday.Year, sunday.Month.ToString().PadLeft(2, '0'), sunday.Day.ToString().PadLeft(2, '0'));
break;
case memberType.beehive:
// female ages 12 to 13
sqlCont += " and gender = 'F' and " +
"DATEDIFF(CURRENT_DATE, birthdate) >= (12 * 365.25) and " +
"DATEDIFF(CURRENT_DATE, birthdate) < (14 * 365.25) ";
break;
case memberType.miaMaid:
// female ages 14 to 15
sqlCont += " and gender = 'F' and " +
"DATEDIFF(CURRENT_DATE, birthdate) >= (14 * 365.25) and " +
"DATEDIFF(CURRENT_DATE, birthdate) < (16 * 365.25) ";
break;
case memberType.laurel:
// female ages 16 to 17
sqlCont += " and gender = 'F' and " +
"DATEDIFF(CURRENT_DATE, birthdate) >= (16 * 365.25) and " +
"DATEDIFF(CURRENT_DATE, birthdate) < (18 * 365.25) ";
break;
case memberType.deacon:
// male ages 12 to 13
sqlCont += " and id in (select member_id from lds_priesthood where reference = 1) ";
break;
case memberType.teacher:
// male ages 14 to 15
sqlCont += " and id in (select member_id from lds_priesthood where reference = 2) ";
break;
case memberType.priest:
// male ages 16 to 17
sqlCont += " and id in (select member_id from lds_priesthood where reference = 3) ";
break;
case memberType.elder:
// male ages 18+ minus high priest or elder
sqlCont += " and gender = 'M' and " +
"DATEDIFF(CURRENT_DATE, birthdate) >= (18 * 365.25) and id not in (select member_id from lds_priesthood where reference = 5) ";
break;
case memberType.highPriest:
// male with high priest
sqlCont += " and id in (select member_id from lds_priesthood where reference = 5) ";
break;
case memberType.reliefSociety:
// female ages 18+
sqlCont += " and gender = 'F' and " +
"DATEDIFF(CURRENT_DATE, birthdate) >= (18 * 365.25) ";
break;
case memberType.sundaySchool:
// members 18+
sqlCont += " and DATEDIFF(CURRENT_DATE, birthdate) >= (18 * 365.25) ";
break;
case memberType.sundaySchoolYouth:
// members ages 12 to 17
sqlCont += " and DATEDIFF(CURRENT_DATE, birthdate) >= (12 * 365.25) and " +
"DATEDIFF(CURRENT_DATE, birthdate) < (18 * 365.25) ";
break;
case memberType.primary:
// members age 0 to 11
sqlCont += " and DATEDIFF(CURRENT_DATE, birthdate) < (12 * 365.25) ";
break;
case memberType.youngMen:
// men age 12 to 17
sqlCont += " and gender = 'M' and " +
"DATEDIFF(CURRENT_DATE, birthdate) >= (12 * 365.25) and " +
"DATEDIFF(CURRENT_DATE, birthdate) < (18 * 365.25) ";
break;
case memberType.youngWomen:
// women age 12 to 17
sqlCont += " and gender = 'F' and " +
"DATEDIFF(CURRENT_DATE, birthdate) >= (12 * 365.25) and " +
"DATEDIFF(CURRENT_DATE, birthdate) < (18 * 365.25) ";
break;
case memberType.adultsMen:
// men age 18+
sqlCont += " and gender = 'M' and " +
"DATEDIFF(CURRENT_DATE, birthdate) >= (18 * 365.25) ";
break;
}
sql += sqlCont + " order by last_name, first_name";
foreach (List<string> data in database.retrieveData(sql, unitId))
{
Member member = new Member();
member.Id = common.convertNumber(data[0]);
member.FirstName = data[1];
member.LastName = data[2];
member.BirthDate = common.convertDate(data[3]);
member.Date = common.convertDate(data[5]);
member.MemberRecord = data[6];
member.Actived = (data[7] != "0");
member.Restricted = common.convertBool(data[8]);
member.Gender = data[9];
member.Present = new Frequency().wasPresent(member.Id, date, type);
member.isUnitMember = common.convertBool(data[10]);
members.Add(member);
}
members = members.OrderByDescending(m => m.Actived).ThenBy(m => m.LastName).ThenBy(m => m.FirstName).ToList();
return members;
}
private void hyzjForm_Load(object sender, EventArgs e)
{
#region//打开摄像头
try
{
//连接//开启摄像头
videoDevices = new FilterInfoCollection(FilterCategory.VideoInputDevice);
if (videoDevices.Count == 0)
{
throw new ApplicationException();
}
foreach (FilterInfo device in videoDevices)
{
list.Add(device.Name);
}
CameraConn();
}
catch (ApplicationException)
{
videoDevices = null;
}
#endregion
#region//窗口打开的时候初始化的内容
dateTimePicker1.Value = new DateTime(DateTime.Now.Year + 2, DateTime.Now.Month, DateTime.Now.Day);
//初始化会员分类
string[] str = new string[] {};
List <string> list1 = bll.selectNodes();
str = list1.ToArray();
hyflcomboBox.Items.AddRange(str);
if (hyflcomboBox.Items.Count > 0)
{
hyflcomboBox.SelectedIndex = 0;
}
string name = hyflcomboBox.Text;
memberType mode = bll.EditMember(name);
spzktextBox.Text = mode.memberRebate;
spzktextBox.ReadOnly = true;
fwzktextBox.Text = "0";
fwzktextBox.ReadOnly = true;
czjetextBox.Text = mode.memberTopUp;
czjetextBox.ReadOnly = true;
bkjetextBox.Text = mode.memberCardMoney;
textBox1.Text = mode.memberTypechild;
textBox1.ReadOnly = true;
hyxbcomboBox.SelectedIndex = 0;
ztcomboBox.SelectedIndex = 0;
szmmbutton.Enabled = false;
#endregion
//连锁店名初始化
if (FilterClass.isadmin())
{
List <string> strdp = dpbll.selectDPName();
foreach (var iteam in strdp)
{
lsdcomboBox.Items.Add(iteam);
}
lsdcomboBox.SelectedIndex = 0;
}
else
{
lsdcomboBox.Text = FilterClass.DianPu1.UserName;
lsdcomboBox.Enabled = false;
}
List <jbcs> listname = staffbll.selectSH();
foreach (var iteam in listname)
{
ywycomboBox.Items.Add(iteam.AllType);
}
if (ywycomboBox.Items.Count > 0)
{
ywycomboBox.SelectedIndex = 0;
}
}
