コード例 #1
0
        public int Add(PEIS.Model.OnCustReportManage model)
        {
            StringBuilder stringBuilder = new StringBuilder();

            stringBuilder.Append("insert into OnCustReportManage(");
            stringBuilder.Append("ID_ReportWay,ID_ReprotWay,ReportWay,Is_Informed,Informer,InformedDate,Is_InformReturned,Is_ReportReceipted,Is_SelfReceipted,ReportReceiptor,ReportReceiptedDate,ID_ReportOffer,ReportOffer,Is_ReportPrinted,ID_ReportPrinter,ReportPrinter,ReportPrintedDate,ID_ReportChecker,ReportChecker,ReportCheckDate,ReportPosition)");
            stringBuilder.Append(" values (");
            stringBuilder.Append("@ID_ReportWay,@ID_ReprotWay,@ReportWay,@Is_Informed,@Informer,@InformedDate,@Is_InformReturned,@Is_ReportReceipted,@Is_SelfReceipted,@ReportReceiptor,@ReportReceiptedDate,@ID_ReportOffer,@ReportOffer,@Is_ReportPrinted,@ID_ReportPrinter,@ReportPrinter,@ReportPrintedDate,@ID_ReportChecker,@ReportChecker,@ReportCheckDate,@ReportPosition)");
            stringBuilder.Append(";select @@IDENTITY");
            SqlParameter[] array = new SqlParameter[]
            {
                new SqlParameter("@ID_ReportWay", SqlDbType.Int, 4),
                new SqlParameter("@ID_ReprotWay", SqlDbType.Int, 4),
                new SqlParameter("@ReportWay", SqlDbType.VarChar, 50),
                new SqlParameter("@Is_Informed", SqlDbType.Bit, 1),
                new SqlParameter("@Informer", SqlDbType.VarChar, 30),
                new SqlParameter("@InformedDate", SqlDbType.DateTime),
                new SqlParameter("@Is_InformReturned", SqlDbType.Bit, 1),
                new SqlParameter("@Is_ReportReceipted", SqlDbType.Bit, 1),
                new SqlParameter("@Is_SelfReceipted", SqlDbType.Bit, 1),
                new SqlParameter("@ReportReceiptor", SqlDbType.VarChar, 30),
                new SqlParameter("@ReportReceiptedDate", SqlDbType.DateTime),
                new SqlParameter("@ID_ReportOffer", SqlDbType.Int, 4),
                new SqlParameter("@ReportOffer", SqlDbType.VarChar, 30),
                new SqlParameter("@Is_ReportPrinted", SqlDbType.Bit, 1),
                new SqlParameter("@ID_ReportPrinter", SqlDbType.Int, 4),
                new SqlParameter("@ReportPrinter", SqlDbType.VarChar, 30),
                new SqlParameter("@ReportPrintedDate", SqlDbType.DateTime),
                new SqlParameter("@ID_ReportChecker", SqlDbType.Int, 4),
                new SqlParameter("@ReportChecker", SqlDbType.VarChar, 30),
                new SqlParameter("@ReportCheckDate", SqlDbType.DateTime),
                new SqlParameter("@ReportPosition", SqlDbType.VarChar, 30)
            };
            array[0].Value  = model.ID_ReportWay;
            array[1].Value  = model.ID_ReprotWay;
            array[2].Value  = model.ReportWay;
            array[3].Value  = model.Is_Informed;
            array[4].Value  = model.Informer;
            array[5].Value  = model.InformedDate;
            array[6].Value  = model.Is_InformReturned;
            array[7].Value  = model.Is_ReportReceipted;
            array[8].Value  = model.Is_SelfReceipted;
            array[9].Value  = model.ReportReceiptor;
            array[10].Value = model.ReportReceiptedDate;
            array[11].Value = model.ID_ReportOffer;
            array[12].Value = model.ReportOffer;
            array[13].Value = model.Is_ReportPrinted;
            array[14].Value = model.ID_ReportPrinter;
            array[15].Value = model.ReportPrinter;
            array[16].Value = model.ReportPrintedDate;
            array[17].Value = model.ID_ReportChecker;
            array[18].Value = model.ReportChecker;
            array[19].Value = model.ReportCheckDate;
            array[20].Value = model.ReportPosition;
            object single = DbHelperSQL.GetSingle(stringBuilder.ToString(), array);
            int    result;

            if (single == null)
            {
                result = 0;
            }
            else
            {
                result = Convert.ToInt32(single);
            }
            return(result);
        }
コード例 #2
0
        public bool Update(PEIS.Model.OnCustReportManage model)
        {
            StringBuilder stringBuilder = new StringBuilder();

            stringBuilder.Append("update OnCustReportManage set ");
            stringBuilder.Append("ID_ReportWay=@ID_ReportWay,");
            stringBuilder.Append("ID_ReprotWay=@ID_ReprotWay,");
            stringBuilder.Append("ReportWay=@ReportWay,");
            stringBuilder.Append("Is_Informed=@Is_Informed,");
            stringBuilder.Append("Informer=@Informer,");
            stringBuilder.Append("InformedDate=@InformedDate,");
            stringBuilder.Append("Is_InformReturned=@Is_InformReturned,");
            stringBuilder.Append("Is_ReportReceipted=@Is_ReportReceipted,");
            stringBuilder.Append("Is_SelfReceipted=@Is_SelfReceipted,");
            stringBuilder.Append("ReportReceiptor=@ReportReceiptor,");
            stringBuilder.Append("ReportReceiptedDate=@ReportReceiptedDate,");
            stringBuilder.Append("ID_ReportOffer=@ID_ReportOffer,");
            stringBuilder.Append("ReportOffer=@ReportOffer,");
            stringBuilder.Append("Is_ReportPrinted=@Is_ReportPrinted,");
            stringBuilder.Append("ID_ReportPrinter=@ID_ReportPrinter,");
            stringBuilder.Append("ReportPrinter=@ReportPrinter,");
            stringBuilder.Append("ReportPrintedDate=@ReportPrintedDate,");
            stringBuilder.Append("ID_ReportChecker=@ID_ReportChecker,");
            stringBuilder.Append("ReportChecker=@ReportChecker,");
            stringBuilder.Append("ReportCheckDate=@ReportCheckDate,");
            stringBuilder.Append("ReportPosition=@ReportPosition");
            stringBuilder.Append(" where ID_ReportManage=@ID_ReportManage");
            SqlParameter[] array = new SqlParameter[]
            {
                new SqlParameter("@ID_ReportWay", SqlDbType.Int, 4),
                new SqlParameter("@ID_ReprotWay", SqlDbType.Int, 4),
                new SqlParameter("@ReportWay", SqlDbType.VarChar, 50),
                new SqlParameter("@Is_Informed", SqlDbType.Bit, 1),
                new SqlParameter("@Informer", SqlDbType.VarChar, 30),
                new SqlParameter("@InformedDate", SqlDbType.DateTime),
                new SqlParameter("@Is_InformReturned", SqlDbType.Bit, 1),
                new SqlParameter("@Is_ReportReceipted", SqlDbType.Bit, 1),
                new SqlParameter("@Is_SelfReceipted", SqlDbType.Bit, 1),
                new SqlParameter("@ReportReceiptor", SqlDbType.VarChar, 30),
                new SqlParameter("@ReportReceiptedDate", SqlDbType.DateTime),
                new SqlParameter("@ID_ReportOffer", SqlDbType.Int, 4),
                new SqlParameter("@ReportOffer", SqlDbType.VarChar, 30),
                new SqlParameter("@Is_ReportPrinted", SqlDbType.Bit, 1),
                new SqlParameter("@ID_ReportPrinter", SqlDbType.Int, 4),
                new SqlParameter("@ReportPrinter", SqlDbType.VarChar, 30),
                new SqlParameter("@ReportPrintedDate", SqlDbType.DateTime),
                new SqlParameter("@ID_ReportChecker", SqlDbType.Int, 4),
                new SqlParameter("@ReportChecker", SqlDbType.VarChar, 30),
                new SqlParameter("@ReportCheckDate", SqlDbType.DateTime),
                new SqlParameter("@ReportPosition", SqlDbType.VarChar, 30),
                new SqlParameter("@ID_ReportManage", SqlDbType.Int, 4)
            };
            array[0].Value  = model.ID_ReportWay;
            array[1].Value  = model.ID_ReprotWay;
            array[2].Value  = model.ReportWay;
            array[3].Value  = model.Is_Informed;
            array[4].Value  = model.Informer;
            array[5].Value  = model.InformedDate;
            array[6].Value  = model.Is_InformReturned;
            array[7].Value  = model.Is_ReportReceipted;
            array[8].Value  = model.Is_SelfReceipted;
            array[9].Value  = model.ReportReceiptor;
            array[10].Value = model.ReportReceiptedDate;
            array[11].Value = model.ID_ReportOffer;
            array[12].Value = model.ReportOffer;
            array[13].Value = model.Is_ReportPrinted;
            array[14].Value = model.ID_ReportPrinter;
            array[15].Value = model.ReportPrinter;
            array[16].Value = model.ReportPrintedDate;
            array[17].Value = model.ID_ReportChecker;
            array[18].Value = model.ReportChecker;
            array[19].Value = model.ReportCheckDate;
            array[20].Value = model.ReportPosition;
            array[21].Value = model.ID_ReportManage;
            int num = DbHelperSQL.ExecuteSql(stringBuilder.ToString(), array);

            return(num > 0);
        }
コード例 #3
0
        public PEIS.Model.OnCustReportManage GetModel(int ID_ReportManage)
        {
            StringBuilder stringBuilder = new StringBuilder();

            stringBuilder.Append("select  top 1 ID_ReportManage,ID_ReportWay,ID_ReprotWay,ReportWay,Is_Informed,Informer,InformedDate,Is_InformReturned,Is_ReportReceipted,Is_SelfReceipted,ReportReceiptor,ReportReceiptedDate,ID_ReportOffer,ReportOffer,Is_ReportPrinted,ID_ReportPrinter,ReportPrinter,ReportPrintedDate,ID_ReportChecker,ReportChecker,ReportCheckDate,ReportPosition from OnCustReportManage ");
            stringBuilder.Append(" where ID_ReportManage=@ID_ReportManage");
            SqlParameter[] array = new SqlParameter[]
            {
                new SqlParameter("@ID_ReportManage", SqlDbType.Int, 4)
            };
            array[0].Value = ID_ReportManage;
            PEIS.Model.OnCustReportManage onCustReportManage = new PEIS.Model.OnCustReportManage();
            DataSet dataSet = DbHelperSQL.Query(stringBuilder.ToString(), array);

            PEIS.Model.OnCustReportManage result;
            if (dataSet.Tables[0].Rows.Count > 0)
            {
                if (dataSet.Tables[0].Rows[0]["ID_ReportManage"].ToString() != "")
                {
                    onCustReportManage.ID_ReportManage = int.Parse(dataSet.Tables[0].Rows[0]["ID_ReportManage"].ToString());
                }
                if (dataSet.Tables[0].Rows[0]["ID_ReportWay"].ToString() != "")
                {
                    onCustReportManage.ID_ReportWay = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_ReportWay"].ToString()));
                }
                if (dataSet.Tables[0].Rows[0]["ID_ReprotWay"].ToString() != "")
                {
                    onCustReportManage.ID_ReprotWay = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_ReprotWay"].ToString()));
                }
                onCustReportManage.ReportWay = dataSet.Tables[0].Rows[0]["ReportWay"].ToString();
                if (dataSet.Tables[0].Rows[0]["Is_Informed"].ToString() != "")
                {
                    if (dataSet.Tables[0].Rows[0]["Is_Informed"].ToString() == "1" || dataSet.Tables[0].Rows[0]["Is_Informed"].ToString().ToLower() == "true")
                    {
                        onCustReportManage.Is_Informed = new bool?(true);
                    }
                    else
                    {
                        onCustReportManage.Is_Informed = new bool?(false);
                    }
                }
                onCustReportManage.Informer = dataSet.Tables[0].Rows[0]["Informer"].ToString();
                if (dataSet.Tables[0].Rows[0]["InformedDate"].ToString() != "")
                {
                    onCustReportManage.InformedDate = new DateTime?(DateTime.Parse(dataSet.Tables[0].Rows[0]["InformedDate"].ToString()));
                }
                if (dataSet.Tables[0].Rows[0]["Is_InformReturned"].ToString() != "")
                {
                    if (dataSet.Tables[0].Rows[0]["Is_InformReturned"].ToString() == "1" || dataSet.Tables[0].Rows[0]["Is_InformReturned"].ToString().ToLower() == "true")
                    {
                        onCustReportManage.Is_InformReturned = new bool?(true);
                    }
                    else
                    {
                        onCustReportManage.Is_InformReturned = new bool?(false);
                    }
                }
                if (dataSet.Tables[0].Rows[0]["Is_ReportReceipted"].ToString() != "")
                {
                    if (dataSet.Tables[0].Rows[0]["Is_ReportReceipted"].ToString() == "1" || dataSet.Tables[0].Rows[0]["Is_ReportReceipted"].ToString().ToLower() == "true")
                    {
                        onCustReportManage.Is_ReportReceipted = new bool?(true);
                    }
                    else
                    {
                        onCustReportManage.Is_ReportReceipted = new bool?(false);
                    }
                }
                if (dataSet.Tables[0].Rows[0]["Is_SelfReceipted"].ToString() != "")
                {
                    if (dataSet.Tables[0].Rows[0]["Is_SelfReceipted"].ToString() == "1" || dataSet.Tables[0].Rows[0]["Is_SelfReceipted"].ToString().ToLower() == "true")
                    {
                        onCustReportManage.Is_SelfReceipted = new bool?(true);
                    }
                    else
                    {
                        onCustReportManage.Is_SelfReceipted = new bool?(false);
                    }
                }
                onCustReportManage.ReportReceiptor = dataSet.Tables[0].Rows[0]["ReportReceiptor"].ToString();
                if (dataSet.Tables[0].Rows[0]["ReportReceiptedDate"].ToString() != "")
                {
                    onCustReportManage.ReportReceiptedDate = new DateTime?(DateTime.Parse(dataSet.Tables[0].Rows[0]["ReportReceiptedDate"].ToString()));
                }
                if (dataSet.Tables[0].Rows[0]["ID_ReportOffer"].ToString() != "")
                {
                    onCustReportManage.ID_ReportOffer = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_ReportOffer"].ToString()));
                }
                onCustReportManage.ReportOffer = dataSet.Tables[0].Rows[0]["ReportOffer"].ToString();
                if (dataSet.Tables[0].Rows[0]["Is_ReportPrinted"].ToString() != "")
                {
                    if (dataSet.Tables[0].Rows[0]["Is_ReportPrinted"].ToString() == "1" || dataSet.Tables[0].Rows[0]["Is_ReportPrinted"].ToString().ToLower() == "true")
                    {
                        onCustReportManage.Is_ReportPrinted = new bool?(true);
                    }
                    else
                    {
                        onCustReportManage.Is_ReportPrinted = new bool?(false);
                    }
                }
                if (dataSet.Tables[0].Rows[0]["ID_ReportPrinter"].ToString() != "")
                {
                    onCustReportManage.ID_ReportPrinter = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_ReportPrinter"].ToString()));
                }
                onCustReportManage.ReportPrinter = dataSet.Tables[0].Rows[0]["ReportPrinter"].ToString();
                if (dataSet.Tables[0].Rows[0]["ReportPrintedDate"].ToString() != "")
                {
                    onCustReportManage.ReportPrintedDate = new DateTime?(DateTime.Parse(dataSet.Tables[0].Rows[0]["ReportPrintedDate"].ToString()));
                }
                if (dataSet.Tables[0].Rows[0]["ID_ReportChecker"].ToString() != "")
                {
                    onCustReportManage.ID_ReportChecker = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_ReportChecker"].ToString()));
                }
                onCustReportManage.ReportChecker = dataSet.Tables[0].Rows[0]["ReportChecker"].ToString();
                if (dataSet.Tables[0].Rows[0]["ReportCheckDate"].ToString() != "")
                {
                    onCustReportManage.ReportCheckDate = new DateTime?(DateTime.Parse(dataSet.Tables[0].Rows[0]["ReportCheckDate"].ToString()));
                }
                onCustReportManage.ReportPosition = dataSet.Tables[0].Rows[0]["ReportPosition"].ToString();
                result = onCustReportManage;
            }
            else
            {
                result = null;
            }
            return(result);
        }
コード例 #4
0
        public void UpdateCustomerReportReceiptFlag()
        {
            string text = base.GetString("AllData").TrimEnd(new char[]
            {
                '|'
            });
            string text2 = base.GetString("modelName").Trim().ToLower();
            List <PEIS.Model.OnCustReportManage> list = new List <PEIS.Model.OnCustReportManage>();

            string[] array = text.Split(new char[]
            {
                '|'
            });
            StringBuilder stringBuilder = new StringBuilder();

            stringBuilder.AppendLine(string.Format("本次共计领取{0}个", array.Length));
            if (array.Length > 0)
            {
                string[] array2 = array;
                for (int i = 0; i < array2.Length; i++)
                {
                    string   text3  = array2[i];
                    string[] array3 = text3.Split(new char[]
                    {
                        '-'
                    });
                    if (array3.Length > 0)
                    {
                        PEIS.Model.OnCustReportManage onCustReportManage = new PEIS.Model.OnCustReportManage();
                        onCustReportManage.ID_Customer         = array3[0];
                        onCustReportManage.Is_SelfReceipted    = new bool?(array3[1] == "1");
                        onCustReportManage.ReportReceiptedDate = new DateTime?(DateTime.Now);
                        onCustReportManage.ID_ReportOffer      = new int?(int.Parse(this.ID_User));
                        onCustReportManage.Is_ReportReceipted  = new bool?(true);
                        onCustReportManage.ReportOffer         = this.UserName;
                        onCustReportManage.ReportReceiptor     = array3[2];
                        onCustReportManage.ReportReceiptor     = Secret.AES.EncryptPrefix(onCustReportManage.ReportReceiptor);
                        list.Add(onCustReportManage);
                        stringBuilder.AppendLine(string.Format("姓名[{0}],体检号[{1}],是否本人[{2}],领取人[{3}]", new object[]
                        {
                            array3[3],
                            onCustReportManage.ID_Customer,
                            onCustReportManage.Is_SelfReceipted,
                            array3[2]
                        }));
                    }
                }
            }
            try
            {
                int num = CommonReport.Instance.UpdateCustomerReportReceiptFlag(list);
                if (num > 0)
                {
                    string msg = "{\"success\":\"1\",\"Message\":\"领取成功!\"}";
                    this.OutPutMessage(msg);
                    Log4J.Instance.Info(string.Concat(new string[]
                    {
                        Public.GetClientIP(),
                        ",",
                        this.LoginUserModel.UserName,
                        ",报告领取成功 详细名单:",
                        stringBuilder.ToString()
                    }));
                    DateTime now = DateTime.Now;
                    foreach (PEIS.Model.OnCustReportManage current in list)
                    {
                        if (!string.IsNullOrEmpty(current.ID_Customer))
                        {
                            base.AddOrUpdateByBackLogType(long.Parse(current.ID_Customer.ToString()), EnumBusBackLogType.报告领取, true, null);
                        }
                    }
                }
                else
                {
                    string msg = "{\"success\":\"0\",\"Message\":\"领取失败,请重试!\"}";
                    this.OutPutMessage(msg);
                    Log4J.Instance.Error(string.Concat(new string[]
                    {
                        Public.GetClientIP(),
                        ",",
                        this.LoginUserModel.UserName,
                        ",报告领取失败,0行受影响 详细名单:",
                        stringBuilder.ToString()
                    }));
                }
            }
            catch (Exception ex)
            {
                string msg = "{\"success\":\"0\",\"Message\":\"领取失败,请重试!\"}";
                this.OutPutMessage(msg);
                Log4J.Instance.Error(string.Concat(new string[]
                {
                    Public.GetClientIP(),
                    ",",
                    this.LoginUserModel.UserName,
                    ",报告领取失败,详细名单:",
                    stringBuilder.ToString(),
                    "错误原因为",
                    ex.Message
                }));
            }
        }
コード例 #5
0
        public List <PEIS.Model.OnCustReportManage> DataTableToList(DataTable dt)
        {
            List <PEIS.Model.OnCustReportManage> list = new List <PEIS.Model.OnCustReportManage>();
            int count = dt.Rows.Count;

            if (count > 0)
            {
                for (int i = 0; i < count; i++)
                {
                    PEIS.Model.OnCustReportManage onCustReportManage = new PEIS.Model.OnCustReportManage();
                    if (dt.Rows[i]["ID_ReportManage"].ToString() != "")
                    {
                        onCustReportManage.ID_ReportManage = int.Parse(dt.Rows[i]["ID_ReportManage"].ToString());
                    }
                    if (dt.Rows[i]["ID_ReportWay"].ToString() != "")
                    {
                        onCustReportManage.ID_ReportWay = new int?(int.Parse(dt.Rows[i]["ID_ReportWay"].ToString()));
                    }
                    if (dt.Rows[i]["ID_ReprotWay"].ToString() != "")
                    {
                        onCustReportManage.ID_ReprotWay = new int?(int.Parse(dt.Rows[i]["ID_ReprotWay"].ToString()));
                    }
                    onCustReportManage.ReportWay = dt.Rows[i]["ReportWay"].ToString();
                    if (dt.Rows[i]["Is_Informed"].ToString() != "")
                    {
                        if (dt.Rows[i]["Is_Informed"].ToString() == "1" || dt.Rows[i]["Is_Informed"].ToString().ToLower() == "true")
                        {
                            onCustReportManage.Is_Informed = new bool?(true);
                        }
                        else
                        {
                            onCustReportManage.Is_Informed = new bool?(false);
                        }
                    }
                    onCustReportManage.Informer = dt.Rows[i]["Informer"].ToString();
                    if (dt.Rows[i]["InformedDate"].ToString() != "")
                    {
                        onCustReportManage.InformedDate = new DateTime?(DateTime.Parse(dt.Rows[i]["InformedDate"].ToString()));
                    }
                    if (dt.Rows[i]["Is_InformReturned"].ToString() != "")
                    {
                        if (dt.Rows[i]["Is_InformReturned"].ToString() == "1" || dt.Rows[i]["Is_InformReturned"].ToString().ToLower() == "true")
                        {
                            onCustReportManage.Is_InformReturned = new bool?(true);
                        }
                        else
                        {
                            onCustReportManage.Is_InformReturned = new bool?(false);
                        }
                    }
                    if (dt.Rows[i]["Is_ReportReceipted"].ToString() != "")
                    {
                        if (dt.Rows[i]["Is_ReportReceipted"].ToString() == "1" || dt.Rows[i]["Is_ReportReceipted"].ToString().ToLower() == "true")
                        {
                            onCustReportManage.Is_ReportReceipted = new bool?(true);
                        }
                        else
                        {
                            onCustReportManage.Is_ReportReceipted = new bool?(false);
                        }
                    }
                    if (dt.Rows[i]["Is_SelfReceipted"].ToString() != "")
                    {
                        if (dt.Rows[i]["Is_SelfReceipted"].ToString() == "1" || dt.Rows[i]["Is_SelfReceipted"].ToString().ToLower() == "true")
                        {
                            onCustReportManage.Is_SelfReceipted = new bool?(true);
                        }
                        else
                        {
                            onCustReportManage.Is_SelfReceipted = new bool?(false);
                        }
                    }
                    onCustReportManage.ReportReceiptor = dt.Rows[i]["ReportReceiptor"].ToString();
                    if (dt.Rows[i]["ReportReceiptedDate"].ToString() != "")
                    {
                        onCustReportManage.ReportReceiptedDate = new DateTime?(DateTime.Parse(dt.Rows[i]["ReportReceiptedDate"].ToString()));
                    }
                    if (dt.Rows[i]["ID_ReportOffer"].ToString() != "")
                    {
                        onCustReportManage.ID_ReportOffer = new int?(int.Parse(dt.Rows[i]["ID_ReportOffer"].ToString()));
                    }
                    onCustReportManage.ReportOffer = dt.Rows[i]["ReportOffer"].ToString();
                    if (dt.Rows[i]["Is_ReportPrinted"].ToString() != "")
                    {
                        if (dt.Rows[i]["Is_ReportPrinted"].ToString() == "1" || dt.Rows[i]["Is_ReportPrinted"].ToString().ToLower() == "true")
                        {
                            onCustReportManage.Is_ReportPrinted = new bool?(true);
                        }
                        else
                        {
                            onCustReportManage.Is_ReportPrinted = new bool?(false);
                        }
                    }
                    if (dt.Rows[i]["ID_ReportPrinter"].ToString() != "")
                    {
                        onCustReportManage.ID_ReportPrinter = new int?(int.Parse(dt.Rows[i]["ID_ReportPrinter"].ToString()));
                    }
                    onCustReportManage.ReportPrinter = dt.Rows[i]["ReportPrinter"].ToString();
                    if (dt.Rows[i]["ReportPrintedDate"].ToString() != "")
                    {
                        onCustReportManage.ReportPrintedDate = new DateTime?(DateTime.Parse(dt.Rows[i]["ReportPrintedDate"].ToString()));
                    }
                    if (dt.Rows[i]["ID_ReportChecker"].ToString() != "")
                    {
                        onCustReportManage.ID_ReportChecker = new int?(int.Parse(dt.Rows[i]["ID_ReportChecker"].ToString()));
                    }
                    onCustReportManage.ReportChecker = dt.Rows[i]["ReportChecker"].ToString();
                    if (dt.Rows[i]["ReportCheckDate"].ToString() != "")
                    {
                        onCustReportManage.ReportCheckDate = new DateTime?(DateTime.Parse(dt.Rows[i]["ReportCheckDate"].ToString()));
                    }
                    onCustReportManage.ReportPosition = dt.Rows[i]["ReportPosition"].ToString();
                    list.Add(onCustReportManage);
                }
            }
            return(list);
        }
コード例 #6
0
 public bool Update(PEIS.Model.OnCustReportManage model)
 {
     return(this.dal.Update(model));
 }
コード例 #7
0
 public int Add(PEIS.Model.OnCustReportManage model)
 {
     return(this.dal.Add(model));
 }