[自用] 臨時工作筆記

[工作用的臨時筆記，僅供私人用途，無參考價值XD]

多一個欄位，繫結ibpm_dlt

https://www.taaze.tw/products/11313057209.html#

https://www.taaze.tw/products/11312776831.html

https://www.taaze.tw/usedList.html?oid=11100033190

日文解釋所引起之台灣譯者的翻譯問題點―以長句子的處理為中心―

 

https://evshary.com/2018/01/03/HTTP-header-%E5%AE%89%E5%85%A8%E8%A8%AD%E5%AE%9A/

ChatGPT

https://www.playpcesor.com/2023/04/chatgpt-midjourney-ai.html

https://tracyting.com/midjourney-%E5%85%8D%E8%B2%BB%E6%AC%A1%E6%95%B8%E7%94%A8%E5%AE%8C%E4%BA%86-%E6%9C%89%E6%B2%92%E6%9C%89%E3%80%8Cmidjourney%E7%A0%B4%E8%A7%A3%E7%89%88%EF%BC%9F%E3%80%8D%E6%89%8B%E6%8A%8A%E6%89%8B/#%E5%8F%AA%E8%A6%81%E9%82%80%E8%AB%8B%E6%9C%8B%E5%8F%8B%EF%BC%8C%E5%B0%B1%E8%83%BD%E5%85%8D%E8%B2%BB%E4%B8%80%E7%9B%B4%E7%94%A8_midjourney

電子表單(前端)

$(document).ready(function(){

    var params = {

       itype: 'funcion_name'

    };

 

YZSoft.Ajax.RFC({

            url: 'function.ashx',

            sync: true,

            params: params,

            success: function (action) {

                var res = Ext.decode(action.responseText);

                var stepData = Ext.decode(res.stepData);

                var seletor = $('#XDropDownList1')[0];

 

                var i = 0;

               

                stepData.forEach(function (item) {                   

                    if (i == 0) {

                        seletor.remove(0); //移除預設(未繫結)

                        seletor.add(new Option('-請選擇-', ''));

                    }

 

                    i++;

                    seletor.add(new Option(item.DisplayName,item.Code));

                });

 

                seletor.selectedIndex = 0;

            },

            failure: function (action) {

                var res = Ext.decode(action.responseText);

                alert(res.msg);

            }

        });

});

 

後端

public void ProcessRequest(HttpContext context)

    {

        JsonItem rv = new JsonItem();

        Global.errMsg = "";

       

        //取得傳入參數

        bool typeError = false;

 

        string itype = "";

 

        try

        {

            itype = context.Request.QueryString["itype"];

        }

        catch (Exception ex)

        {

            Global.errMsg = "傳入參數處理錯誤-" + ex.Message;

            typeError = true;

        }

        if (typeError == false)

        {

            result ST = new result();

            DataTable dt = new DataTable();

            switch (itype)

            {

                case "function_name":

                    List<DDLItem> stepList = get_ddl_account();

                    rv.Attributes.Add("stepData", new JavaScriptSerializer().Serialize(stepList));

                    break;

            }

        }

 

        if (Global.errMsg == "")

        {

            rv.Attributes.Add("success", true);

        }

        else

        {

            rv.Attributes.Add("success", false);

        }

        rv.Attributes.Add("msg", Global.errMsg);

        context.Response.Write(rv.ToString());

    }

 

public static List<DDLItem> function_name()

    {

        List<DDLItem> rtList = new List<DDLItem>();

 

        string sql = string.Empty;

        sql += "select * from data";

 

        DataTable dt = SqlServerDbConnection.MakeDate(ExecWhere.ashx, DataMode.Get, sql);

 

        foreach (DataRow row in dt.Rows)

        {

            DDLItem item = new DDLItem()

            {

                DisplayName = string.Format("{0}", row["DisplayName"]),

                Code = string.Format("{0}", row["UserAccount"])

            };

 

            rtList.Add(item);

        }

 

        return rtList;

    }

 

 

/// <summary>節點選項</summary>

public class DDLItem

{

    /// <summary>節點代號</summary>

    public string Code { get; set; }

 

    /// <summary>節點資訊</summary>

    public string DisplayName { get; set; }

}

 

 

 

string datetime = String.Format("{0:yyyy-MM-dd} 17:30:00", "2022-04-08");
            datetime = "2022-04-08";

            DateTime a = Convert.ToDateTime(String.Format("{0:yyyy-MM-dd}", datetime));

            string year = a.Year.ToString();
            if (a.Month <= 3)
            {
                a = Convert.ToDateTime(year + "-03-31");
            }
            else if (a.Month <= 6)
            {
                a = Convert.ToDateTime(year + "-06-30");
            }
            else if (a.Month <= 9)
            {
                a = Convert.ToDateTime(year + "-09-30");
            }
            else if (a.Month <= 12)
            {
                a = Convert.ToDateTime(year + "-12-31");
            }
            datetime = String.Format("{0:yyyy-MM-dd}", a);
            
            Console.WriteLine(a);
            Console.WriteLine(datetime);