示例#1
0
        public void delete(CInMoneyDetail p_data)
        {
            string l_Sql = "";

            l_Sql += "delete from  [KG].[dbo].[tbInMoneyDetail]";
            l_Sql += " WHERE [f_id] = " + p_data.f_id + "";

            ivContext.資料管理員.excuteSqlNonquery(l_Sql);
        }
示例#2
0
        public void insert(CInMoneyDetail p_data)
        {
            string l_Sql = "";

            l_Sql += "INSERT INTO [KG].[dbo].[tbInMoneyDetail] VALUES (";
            l_Sql += " '" + p_data.f_workid工單單號 + "'";
            l_Sql += ", " + p_data.f_money應收金額 + "";
            l_Sql += ", '" + p_data.f_editdate沖帳日期 + "'";
            l_Sql += ")";
            ivContext.資料管理員.excuteSqlNonquery(l_Sql);
        }
示例#3
0
        private CInMoneyDetail[] queryBySql(string p_sql)
        {
            DataView l_dv = ivContext.資料管理員.getDataViewBySql(p_sql);

            CInMoneyDetail[] l_datas = new CInMoneyDetail[l_dv.Count];

            if (l_dv != null)
            {
                for (int i = 0; i < l_datas.Length; i++)
                {
                    l_datas[i]                = createCInMoneyDetail();
                    l_datas[i].f_id           = Convert.ToInt32(l_dv[i]["f_id"].ToString());
                    l_datas[i].f_workid工單單號   = l_dv[i]["f_workid"].ToString();
                    l_datas[i].f_money應收金額    = Convert.ToInt32(l_dv[i]["f_money"].ToString());
                    l_datas[i].f_editdate沖帳日期 = l_dv[i]["f_editdate"].ToString();
                }
                return(l_datas);
            }
            return(null);
        }