using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace xxtsoft.Application
{
    /// <summary>
    /// 日目标管理
    /// </summary>
    //登录判断
    [Authorize]
    public class MbExtService : IDynamicApiController, ITransient
    {
        private readonly SqlSugar.ISqlSugarClient _db;

        public MbExtService(ISqlSugarClient db)
        {
            this._db = db;
        }

        /// <summary>
        /// 增加或更新：存在日期，则更新
        /// </summary>
        /// <param name="usrid">员工id</param>
        /// <param name="rq">日期</param>
        /// <param name="yxbfcs">有效拜访次数</param>
        /// <param name="whzxxbfcs">未合作学校有效拜访次数</param>
        /// <param name="qkcfcs">请客吃饭次数</param>
        /// <param name="jyzgbmbfcs">教育主管部门拜访次数</param>
        /// <param name="ldjtcs">领导交谈次数</param>
        /// <param name="bzryscs">班主任演示次数</param>
        /// <param name="xmfbwcgs">项目复盘表完成个数</param>
        /// <returns></returns>
        [Route("Add1")]
        [HttpPost]
        public async Task<int> Add1(int usrid, [FromForm] string rq, [FromForm] int yxbfcs, [FromForm] int whzxxbfcs, [FromForm] int qkcfcs, [FromForm] int jyzgbmbfcs, [FromForm] int ldjtcs, [FromForm] int bzryscs, [FromForm] int xmfbwcgs)
        {
            var dt = await _db.Ado.GetDataTableAsync("select id from  mb where usrid=" + usrid + " and rq='" + rq + "'");
            string sql = "";
            if (dt.Rows.Count > 0)
            {
                sql = "update mb set yxbfcs=" + yxbfcs + ",whzxxbfcs=" + whzxxbfcs + ",qkcfcs=" + qkcfcs + ",jyzgbmbfcs=" + jyzgbmbfcs + ",ldjtcs=" + ldjtcs + ",bzryscs=" + bzryscs + ",xmfbwcgs=" + xmfbwcgs + " where id=" + dt.Rows[0]["id"].ToString();
            }
            else
            {
                sql = "insert into mb(usrid,rq,yxbfcs,whzxxbfcs,qkcfcs,jyzgbmbfcs,ldjtcs,bzryscs,xmfbwcgs) values(" + usrid + ",'" + rq + "'," + yxbfcs + "," + whzxxbfcs + "," + qkcfcs + "," + jyzgbmbfcs + "," + ldjtcs + "," + bzryscs + "," + xmfbwcgs + ")";
            }
            FileHelper.FileAdd("1.txt", sql);
            int x = await _db.Ado.ExecuteCommandAsync(sql);
            dt.Dispose();

            return x;
        }

    }
}

@page
@model xxtsoft.Web.Entry.Pages.sysadmins.mb.mb_addModel
@{
    Layout = "_LayoutAdmin";
    ViewData["Title"] = "日目标上报";
}
<div class="layui-fluid">

    <div class="layui-panel layui-padding-3">
        <form class="layui-form" action="" id="form1" lay-filter="form1">
          
            <div class="layui-form-item">
                <label class="layui-form-label">日期：<font color="red">*</font></label>
                <div class="layui-input-block layui-input-wrap">
                    <div class="layui-input-prefix">
                        <i class="layui-icon layui-icon-date"></i>
                    </div>
                    <input type="text" name="rq" id="rq" lay-affix="clear" placeholder="请输入" autocomplete="off" class="layui-input" lay-verify="date" value="@DateTime.Now.ToString("yyyy-MM-dd")">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">有效拜访<br>次数：<font color="red">*</font></label>
                <div class="layui-input-block">
                    
                    <select name="yxbfcs" id="yxbfcs" lay-verify="required">
                        <option value="">请选择</option>
                        <option>0</option>
                        <option>1</option>
                        <option>2</option>
                        <option>3</option>
                        <option>4</option>
                        <option>5</option>
                    </select>

                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">未合作学<br>校有效拜<br>访次数：<font color="red">*</font></label>
                <div class="layui-input-block">
                   
                    <select name="whzxxbfcs" id="whzxxbfcs" lay-verify="required">
                        <option value="">请选择</option>
                        <option>0</option>
                        <option>1</option>
                        <option>2</option>
                        <option>3</option>
                        <option>4</option>
                        <option>5</option>
                    </select>
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">请客吃饭<br>次数：<font color="red">*</font></label>
                <div class="layui-input-block">
                   
                 
                    <select name="qkcfcs" id="qkcfcs" lay-verify="required">
                        <option value="">请选择</option>
                        <option>0</option>
                        <option>1</option>
                        <option>2</option>
                        <option>3</option>
                        <option>4</option>
                        <option>5</option>
                    </select>
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">教育主管<br>部门拜访<br>次数：<font color="red">*</font></label>
                <div class="layui-input-block">
                   
                    <select name="jyzgbmbfcs" id="jyzgbmbfcs" lay-verify="required">
                        <option value="">请选择</option>
                        <option>0</option>
                        <option>1</option>
                        <option>2</option>
                        <option>3</option>
                        <option>4</option>
                        <option>5</option>
                    </select>
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">领导交谈<br>次数：<font color="red">*</font></label>
                <div class="layui-input-block">
                  
                    <select name="ldjtcs" id="ldjtcs" lay-verify="required">
                        <option value="">请选择</option>
                        <option>0</option>
                        <option>1</option>
                        <option>2</option>
                        <option>3</option>
                        <option>4</option>
                        <option>5</option>
                        <option>6</option>
                        <option>7</option>
                        <option>8</option>
                        <option>9</option>
                    </select>
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">班主任演<br>示次数：<font color="red">*</font></label>
                <div class="layui-input-block">
                   
                    <select name="bzryscs" id="bzryscs" lay-verify="required">
                        <option value="">请选择</option>
                        <option>0</option>
                        <option>1</option>
                        <option>2</option>
                        <option>3</option>
                        <option>4</option>
                        <option>5</option>
                        <option>6</option>
                        <option>7</option>
                        <option>8</option>
                        <option>9</option>
                    </select>
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">项目复盘<br>表完成个<br>数：<font color="red">*</font></label>
                <div class="layui-input-block">
                  
                    <select name="xmfbwcgs" id="xmfbwcgs" lay-verify="required">
                        <option value="">请选择</option>
                        <option>0</option>
                        <option>1</option>
                        <option>2</option>
                        <option>3</option>
                        <option>4</option>
                        <option>5</option>
                        <option>6</option>
                        <option>7</option>
                        <option>8</option>
                        <option>9</option>
                    </select>
                </div>
            </div>
            
            
            <div class="layui-form-item layui-layout-admin">
                <div class="layui-input-block">
                    <input type="hidden" name="fst" id="fst" value="@Request.Query["fst"]" class="layui-input">
                    <input type="hidden" name="usrid" id="usrid" value="@Model.loginSid" class="layui-input">
                    <input type="hidden" name="id" id="id" value="@Model.id" class="layui-input">
                    <input type="hidden" name="cdt" id="cdt" value="@DateTime.Now" class="layui-input">
                    <button class="layui-btn btn-block" lay-submit lay-filter="form1-submit">提交</button>
                </div>
            </div>
        </form>
    </div>
</div>
<script>
    layui.config({
        base: '/layui/' // 静态资源所在路径
    }).extend({
        index: 'lib/index' //主入口模块
    }).use(function () {
        var $ = layui.$;
        var laydate = layui.laydate;
        var form = layui.form;
        var layer = layui.layer;
        laydate.render({
            elem: '#rq',
           
          
        });
      
        //获取id值，赋值
        var id = $("#id").val();
        var ajaxurl = "/api/mbExt/Add1/@Model.loginSid";
        if (Number(id) > 0) {
            console.log(id);
            ajaxurl = "/api/mb/Update";
            $.ajax({
                url: "/api/mb/readByID/" + id,
                type: "POST",
                contentType: 'application/json', // 设置请求头中的 Content-Type 为 application/json
                success: function (response) {
                    var data = response.data;
                    if (response.statusCode == 200) {
                        form.val('form1', {
                            "usrid": data[0].usrid,
                            "rq": layui.util.toDateString(data[0].rq, "yyyy-MM-dd"),
                            "yxbfcs": data[0].yxbfcs,
                            "whzxxbfcs": data[0].whzxxbfcs,
                            "qkcfcs": data[0].qkcfcs,
                            "jyzgbmbfcs": data[0].jyzgbmbfcs,
                            "ldjtcs": data[0].ldjtcs,
                            "bzryscs": data[0].bzryscs,
                            "xmfbwcgs": data[0].xmfbwcgs,                           
                        });
                    } else {
                        layer.msg("操作失败", { icon: 5 });
                    }
                }
            });
        }
        // 提交事件
        form.on('submit(form1-submit)', function (data) {
            var field = data.field; // 获取表单全部字段值

            console.log(field);
             console.log(field["rq"]);
          
            layer.confirm('确定提交吗?', function (index) {
                layer.close(index); 

                
                $.ajax({
                    url: ajaxurl,
                    type: "POST",
                    data: {
                        rq:field['rq'],
                        yxbfcs:field['yxbfcs'],
                        whzxxbfcs:field['whzxxbfcs'],
                        qkcfcs:field['qkcfcs'],
                        jyzgbmbfcs:field['jyzgbmbfcs'],
                        ldjtcs:field['ldjtcs'],
                        bzryscs:field['bzryscs'],
                        xmfbwcgs:field['xmfbwcgs']
                    },
                   contentType: 'application/x-www-form-urlencoded', // 设置请求头中的 Content-Type 为 application/json
                    success: function (response) {
                        // console.log(response);
                        if (response.statusCode == 200) {
                               layer.alert("操作成功", { icon: 6 }, function () {
                                // 获得frame索引
                                var index = parent.layer.getFrameIndex(window.name);
                                //关闭当前frame
                                parent.layer.close(index);
                                parent.location.reload();
                            });
                        } else {
                            layer.msg("操作失败", { icon: 5 });
                        }
                    }
                });
            });
            return false;
        });
    });
</script>