Example #1
0
        public C_ROUTE_DETAIL_DIRECTLINK GetDataObject()
        {
            C_ROUTE_DETAIL_DIRECTLINK DataObject = new C_ROUTE_DETAIL_DIRECTLINK();

            DataObject.ID = this.ID;
            DataObject.C_ROUTE_DETAIL_ID          = this.C_ROUTE_DETAIL_ID;
            DataObject.DIRECTLINK_ROUTE_DETAIL_ID = this.DIRECTLINK_ROUTE_DETAIL_ID;
            return(DataObject);
        }
Example #2
0
        public int Add(C_ROUTE_DETAIL_DIRECTLINK newdirectlink, OleExec DB)
        {
            string strSql = $@"insert into c_route_detail_directlink(id,c_route_detail_id,directlink_route_detail_id)";

            strSql = strSql + $@"values(:id,:c_route_detail_id,:directlink_route_detail_id)";
            OleDbParameter[] paramet = new OleDbParameter[3];
            paramet[0] = new OleDbParameter(":id", newdirectlink.ID);
            paramet[1] = new OleDbParameter(":c_route_detail_id", newdirectlink.C_ROUTE_DETAIL_ID);
            paramet[2] = new OleDbParameter(":directlink_route_detail_id", newdirectlink.DIRECTLINK_ROUTE_DETAIL_ID);
            int res = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet);

            return(res);
        }