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