Example #1
0
        /// <summary>
        /// 更新家长数据
        /// </summary>
        /// <returns></returns>
        private string UpdateData()
        {
            string     result          = string.Empty;
            List <int> successRowIndex = new List <int>();

            XF.Model.Base_Family model;
            foreach (int index in lstUpdate)
            {
                model             = new XF.Model.Base_Family();
                model.FamilyID    = zDataConverter.ToInt(xfDataGridView1.Rows[index].Cells[ColFamilyID.Name].Value);
                model.FamilyCode  = zDataConverter.ToString(xfDataGridView1.Rows[index].Cells[ColFamilyCode.Name].Value);
                model.FamilyName  = zDataConverter.ToString(xfDataGridView1.Rows[index].Cells[ColFamilyName.Name].Value);
                model.CourseCount = zDataConverter.ToDecimal(xfDataGridView1.Rows[index].Cells[ColCourseCount.Name].Value);
                model.Phone       = zDataConverter.ToString(xfDataGridView1.Rows[index].Cells[ColPhone.Name].Value);
                model.OpenId      = zDataConverter.ToString(xfDataGridView1.Rows[index].Cells[ColOpenId.Name].Value);
                model.Description = zDataConverter.ToString(xfDataGridView1.Rows[index].Cells[ColDescription.Name].Value);
                if (bll.Update(model))
                {
                    successRowIndex.Add(index);
                }
                else
                {
                    result += MessageText.SQL_ERROR_UPDATE + MessageText.KEY_ENTER;
                }
            }
            foreach (int rowIndex in successRowIndex)
            {
                lstUpdate.Remove(rowIndex);
            }
            return(result);
        }
Example #2
0
        /// <summary>
        /// 新增家长数据
        /// </summary>
        /// <returns></returns>
        private string AddData()
        {
            string     result          = string.Empty;
            List <int> successRowIndex = new List <int>();

            XF.Model.Base_Family model;
            foreach (int index in lstInsert)
            {
                model             = new XF.Model.Base_Family();
                model.FamilyCode  = zDataConverter.ToString(xfDataGridView1.Rows[index].Cells[ColFamilyCode.Name].Value);
                model.FamilyName  = zDataConverter.ToString(xfDataGridView1.Rows[index].Cells[ColFamilyName.Name].Value);
                model.CourseCount = zDataConverter.ToDecimal(xfDataGridView1.Rows[index].Cells[ColCourseCount.Name].Value);
                model.Phone       = zDataConverter.ToString(xfDataGridView1.Rows[index].Cells[ColPhone.Name].Value);
                model.OpenId      = zDataConverter.ToString(xfDataGridView1.Rows[index].Cells[ColOpenId.Name].Value);
                model.Description = zDataConverter.ToString(xfDataGridView1.Rows[index].Cells[ColDescription.Name].Value);
                int ret = bll.Add(model);
                if (ret == PhysicalConstants.SQL_Existed)
                {
                    result += string.Format(MessageText.SQL_ERROR_FAMILY_EXIST, index + 1) + MessageText.KEY_ENTER;
                }
                else
                {
                    xfDataGridView1.Rows[index].Cells[ColFamilyID.Name].Value = ret;
                    successRowIndex.Add(index);
                }
            }
            foreach (int rowIndex in successRowIndex)
            {
                lstInsert.Remove(rowIndex);
            }
            return(result);
        }